Multiple KPIs in Histogram

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 :slight_smile:
yes, thank you:D but this is a workaround:D I was wondering whether the histogram offers such a feature by itself.
Best,
Maria