Skip to main content
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
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.
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