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\":\"24\",\"padding\":\"\",\"title\":\"Number of Support Tickets in Last 60 days\",\"colour\":\"#333\",\"bgColour\":\"transparent\",\"offsetX\":0,\"offsetY\":0,\"alignment\":\"2\",\"weightWidth\":\"1\",\"weightHeight\":\"1\",\"layer\":\"1\",\"metaData\":\{\"isObjectTemplate\":null\},\"refreshRate\":10,\"decimalPlaces\":\"0\",\"units\":\"\",\"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\":truefalse,\"tags\":[],\"dontPromptOnLiveToggle\":false\}

Epm macro editor
config\{\"promptIfDirtyClose\":true,\"seamless\":true,\"editor\":\{\"html\":\"%3Ctable%20style%3D%5C%22width%3A%20100o-o%3B%20border-collapse%3A%20collapse%3B%20border-style%3A%20hidden%3B%20background-color%3A%20%23004358%3B%5C%22%20border%3D%5C%221%5C%22%3E%0A%3Ctbody%3E%0A%3Ctr%20style%3D%5C%22text-align%3A%20left%3B%5C%22%3E%0A%3Ctd%20style%3D%5C%22width%3A%20100o-o%3B%20vertical-align%3A%20middle%3B%20height%3A%2036px%3B%5C%22%20scope%3D%5C%22row%5C%22%3E%3Cspan%20style%3D%5C%22color%3A%20%23ffffff%3B%5C%22%3E%3Cstrong%3E%26nbsp%3B%20Unresolved%20Tickets%20Last%2060%20Days%3C%2Fstrong%3E%3C%2Fspan%3E%3C%2Ftd%3E%0A%3C%2Ftr%3E%0A%3C%2Ftbody%3E%0A%3C%2Ftable%3E\"\},\"tags\":[\"head-office\",\"offshore\"]\}

Epm macro kpi
config\{\"promptIfDirtyClose\":true,\"kpis\":[[\{\"kind\":\"datatable\",\"value\":\{\"sourceUrl\":\"/plugins/servlet/epm//eigen-webtools-servlet/sqlquery?cmd=EXECUTE\",\"sourceData\":\{\"db\":\"freshdesk\",\"query\":\"select * from \\\"FRESHDESK_TICKETS_60D\\\";\"\},\"sourceMethod\":\"GET\",\"columnDefs\":[\{\"name\":\"Ticket_ID\",\"path\":\"$.results.*.TICKET_ID\",\"params\":\"\{\\\"sort\\\":\\\"no\\\",\\\"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\",\"params\":\"\{\\\"sort\\\":\\\"no\\\",\\\"width\\\":\\\"\\\",\\\"alignment\\\":\\\"left\\\",\\\"truncate\\\":\\\"no\\\",\\\"formatAsDate\\\":\\\"\\\",\\\"actionType\\\":\\\"NONE\\\",\\\"action\\\":\\\"\\\"\}\"\},\{\"name\":\"Priority\",\"path\":\"$.results.*.PRIORITY\",\"params\":\"\{\\\"sort\\\":\\\"no\\\",\\\"width\\\":\\\"\\\",\\\"alignment\\\":\\\"left\\\",\\\"truncate\\\":\\\"no\\\",\\\"formatAsDate\\\":\\\"\\\",\\\"actionType\\\":\\\"NONE\\\",\\\"action\\\":\\\"\\\"\}\"\},\{\"name\":\"Type\",\"path\":\"$.results.*.TYPE\",\"params\":\"\{\\\"sort\\\":\\\"no\\\",\\\"width\\\":\\\"\\\",\\\"alignment\\\":\\\"left\\\",\\\"truncate\\\":\\\"no\\\",\\\"formatAsDate\\\":\\\"\\\",\\\"actionType\\\":\\\"NONE\\\",\\\"action\\\":\\\"\\\"\}\"\},\{\"name\":\"Agent\",\"path\":\"$.results.*.AGENT\",\"params\":\"\{\\\"sort\\\":\\\"no\\\",\\\"width\\\":\\\"\\\",\\\"alignment\\\":\\\"left\\\",\\\"truncate\\\":\\\"no\\\",\\\"formatAsDate\\\":\\\"\\\",\\\"actionType\\\":\\\"NONE\\\",\\\"action\\\":\\\"\\\"\}\"\},\{\"name\":\"Asset\",\"path\":\"$.results.*.ASSET\",\"params\":\"\{\\\"sort\\\":\\\"no\\\",\\\"width\\\":\\\"\\\",\\\"alignment\\\":\\\"left\\\",\\\"truncate\\\":\\\"no\\\",\\\"formatAsDate\\\":\\\"\\\",\\\"actionType\\\":\\\"NONE\\\",\\\"action\\\":\\\"\\\"\}\"\},\{\"name\":\"Created Date\",\"path\":\"$.results.*.CREATE_DATE\",\"params\":\"\{\\\"sort\\\":\\\"no\\\",\\\"width\\\":\\\"\\\",\\\"alignment\\\":\\\"left\\\",\\\"truncate\\\":\\\"no\\\",\\\"formatAsDate\\\":\\\"YYYY-MM-DD\\\",\\\"actionType\\\":\\\"NONE\\\",\\\"action\\\":\\\"\\\"\}\"\},\{\"name\":\"Due Date\",\"path\":\"$.results.*.DUE_DATE\",\"params\":\"\{\\\"sort\\\":\\\"no\\\",\\\"width\\\":\\\"\\\",\\\"alignment\\\":\\\"left\\\",\\\"truncate\\\":\\\"no\\\",\\\"formatAsDate\\\":\\\"YYYY-MM-DD\\\",\\\"actionType\\\":\\\"NONE\\\",\\\"action\\\":\\\"\\\"\}\"\},\{\"name\":\"Application\",\"path\":\"$.results.*.APPLICATION\",\"params\":\"\{\\\"sort\\\":\\\"no\\\",\\\"width\\\":\\\"\\\",\\\"alignment\\\":\\\"left\\\",\\\"truncate\\\":\\\"no\\\",\\\"formatAsDate\\\":\\\"\\\",\\\"actionType\\\":\\\"NONE\\\",\\\"action\\\":\\\"\\\"\}\"\},\{\"name\":\"Code Change Required\",\"path\":\"$.results.*.CODE_CHANGE\",\"params\":\"\{\\\"sort\\\":\\\"no\\\",\\\"width\\\":\\\"\\\",\\\"alignment\\\":\\\"left\\\",\\\"truncate\\\":\\\"no\\\",\\\"formatAsDate\\\":\\\"\\\",\\\"actionType\\\":\\\"NONE\\\",\\\"action\\\":\\\"\\\"\}\"\},\{\"name\":\"Jira ID\",\"path\":\"$.results.*.JIRA_ID\",\"params\":\"\{\\\"sort\\\":\\\"no\\\",\\\"width\\\":\\\"\\\",\\\"alignment\\\":\\\"left\\\",\\\"truncate\\\":\\\"no\\\",\\\"formatAsDate\\\":\\\"\\\",\\\"actionType\\\":\\\"NONE\\\",\\\"action\\\":\\\"\\\"\}\"\}],\"columnActions\":[],\"showHeadings\":true,\"showControls\":false,\"refreshRate\":\"120\",\"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\":\"#F8F8F8\",\"firstrowheadings\":false,\"hidegridlines\":false,\"padding\":\"\",\"isgrid\":true,\"diagramid\":false,\"diagramwidth\":1000,\"diagramheight\":\"\",\"vars\":\{\},\"live\":true,\"liveOffset\":\"\",\"seamless\":true,\"tags\":[],\"dontPromptOnLiveToggle\":false\}