Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Epm macro kpi
config\{\"promptIfDirtyClose\":true,\"kpis\":[[\{\"kind\":\"datatag\",\"value\":\"datatable/https://ef.eigen.co/plugins/servlet/epm//eigen-webtools-servlet/sqlquery~cmd|EXECUTE§db|freshdesk§query|Select Count(\\\"TICKET_ID\\\") as Total from \\\"FRESHDESK_TICKETS_60D\\\";~total|$.results.0.total~~false\",\"size\":\"150\",\"textSize\":\"32\",\"padding\":\"\",\"title\":\"\",\"colour\":\"#444444\",\"fgColour\":\"#505150\",\"bgColour\":\"transparent\",\"offsetX\":0,\"offsetY\":0,\"alignment\":\"2\",\"weightWidth\":\"1\",\"weightHeight\":\"1\",\"layer\":\"1\",\"metaData\":\{\"isObjectTemplate\":null\},\"refreshRate\":10,\"decimalPlaces\":\"0\",\"units\":\"tickets\",\"display\":5,\"status\":1,\"customStates\":\{\},\"additionalTrends\":[],\"additionalTrendTypes\":[],\"additionalTrendMultipliers\":[],\"additionalTrendMetaData\":[],\"showValue\":true,\"useTimestampAsValue\":false,\"min\":\"0\",\"max\":\"100\",\"innerRadiusRatio\":\"0.6\",\"sizeOther\":null,\"orientation\":\"v\",\"timespan\":\"\",\"showStats\":false,\"autoscale\":true,\"numGraduations\":101,\"majorGraduationsEvery\":5,\"sizeDirection\":null,\"innerAlignment\":null,\"staleAfter\":false,\"showSeparator\":false,\"relatedDashboard\":false\}]],\"refreshrate\":60,\"canvasColour\":\"\",\"firstrowheadings\":false,\"hidegridlines\":false,\"padding\":\"\",\"isgrid\":true,\"diagramid\":false,\"diagramwidth\":1000,\"diagramheight\":\"\",\"vars\":\{\},\"live\":true,\"liveOffset\":\"\",\"seamless\":true,\"tags\":[],\"dontPromptOnLiveToggle\":false\}

Epm macro kpi
config\{\"promptIfDirtyClose\":true,\"kpis\":[[\{\"kind\":\"datatable\",\"value\":\{\"sourceUrl\":\"https://ef.eigen.co/plugins/servlet/epm//eigen-webtools-servlet/sqlquery\",\"sourceData\":\{\"cmd\":\"EXECUTE\",\"db\":\"freshdesk\",\"query\":\"select * from \\\"FRESHDESK_TICKETS_60D\\\";\"\},\"sourceMethod\":\"GET\",\"columnDefs\":[\{\"name\":\"TICKET_ID\",\"path\":\"$.results.*.TICKET_ID\",\"params\":\"\{\\\"sort\\\":\\\"descending\\\",\\\"width\\\":\\\"\\\",\\\"alignment\\\":\\\"left\\\",\\\"truncate\\\":\\\"no\\\",\\\"formatAsDate\\\":\\\"\\\",\\\"actionType\\\":\\\"LINK\\\",\\\"action\\\":\\\"https://eigen.freshdesk.com/support/tickets/::TICKET_ID::\\\"\}\"\},\{\"name\":\"SUBJECT\",\"path\":\"$.results.*.SUBJECT\",\"params\":\"\{\\\"sort\\\":\\\"no\\\",\\\"width\\\":\\\"20%\\\",\\\"alignment\\\":\\\"left\\\",\\\"truncate\\\":\\\"no\\\",\\\"formatAsDate\\\":\\\"\\\",\\\"actionType\\\":\\\"NONE\\\",\\\"action\\\":\\\"\\\"\}\"\},\{\"name\":\"STATUS\",\"path\":\"$.results.*.STATUS\"\},\{\"name\":\"PRIORITY\",\"path\":\"$.results.*.PRIORITY\"\},\{\"name\":\"AGENT\",\"path\":\"$.results.*.AGENT\"\},\{\"name\":\"CREATE_DATE\",\"path\":\"$.results.*.CREATE_DATE\"\},\{\"name\":\"DUE_DATE\",\"path\":\"$.results.*.DUE_DATE\"\},\{\"name\":\"APPLICATION\",\"path\":\"$.results.*.APPLICATION\"\},\{\"name\":\"ASSET\",\"path\":\"$.results.*.ASSET\"\},\{\"name\":\"TYPE\",\"path\":\"$.results.*.TYPE\"\},\{\"name\":\"JIRA_ID\",\"path\":\"$.results.*.JIRA_ID\"\},\{\"name\":\"CODE_CHANGE\",\"path\":\"$.results.*.CODE_CHANGE\"\}],\"columnActions\":[],\"showHeadings\":true,\"showControls\":true,\"refreshRate\":\"\",\"dataField\":false,\"errorCallback\":false\},\"size\":\"12\",\"textSize\":\"12\",\"padding\":\"\",\"title\":\"\",\"colour\":\"#333\",\"bgColour\":\"transparent\",\"offsetX\":0,\"offsetY\":0,\"alignment\":\"2\",\"weightWidth\":\"1\",\"weightHeight\":\"1\",\"layer\":\"1\",\"metaData\":\{\}\}]],\"refreshrate\":60,\"canvasColour\":\"\",\"firstrowheadings\":false,\"hidegridlines\":false,\"padding\":\"\",\"isgrid\":true,\"diagramid\":false,\"diagramwidth\":1000,\"diagramheight\":\"\",\"vars\":\{\},\"live\":true,\"liveOffset\":\"\",\"seamless\":false,\"tags\":[],\"dontPromptOnLiveToggle\":false\}