Skip to main content
Question

Multiple KPIs in Histogram

  • June 17, 2020
  • 2 replies
  • 5 views

Hi everyone, i was wondering whether it is possible to include multiple similar KPIs in one histogram ? how many days since a)activity a till now b) activity b till now. Best Maria

2 replies

  • Level 3
  • 15 replies
  • June 23, 2020
Hi DrWindy, That is possible by creating them as separate KPIs in your column chart (with the period as dimension for a histogram). In one analysis, I created a stacked column chart with average throughput times for days from invoice to receipt, days from receipt to posting, and days from posting to clearing. The KPIs have the same format: AVG(CALC_THROUGHPUT(FIRST_OCCURRENCE[Vendor creates Invoice] TO LAST_OCCURRENCE[Receive Invoice], REMAP_TIMESTAMPS("_CEL_VIM_ACTIVITIES".EVENTTIME, DAYS))) Replace Vendor creates Invoice and Receive Invoice with your own activities, and the _CEL_VIM_ACTIVITIES table with your own Activity Table.

  • Author
  • Level 7
  • 13 replies
  • June 24, 2020
Hi sappeneer yes, thank you:D but this is a workaround:D I was wondering whether the histogram offers such a feature by itself. Best, Maria