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
Page 1 / 1
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.
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.
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
yes, thank you:D but this is a workaround:D I was wondering whether the histogram offers such a feature by itself.
Best,
Maria
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.