hi,
How can i create in aris process mining a measure in my dashboard that shows how we are performing over time. So for example: I would like to see how much more (%) PO's we have created this month vs. last month. or vs. the same month last year.
I already created calculated measures: flag: is_created_in_current_month and is_created_previous_month, that uses the date to make it a boolean. However, i cannot combine both measures, into one measure. I would like to create a ratio for example where you can SUM( flag: is_created_in_current_month) - SUM(flag:is_created_previous_month) / SUM(flag:is_created_previous_month).
Can someone help me explain how i can do this.
Nicolas Ballarin on
Hi,
I think you could achieve this using the scripted definition in an analysis. I tried to build something similar using the week day as comparison.
Raw data are:
In the scripted definition I try to follow your example:
(SUM("_ARIS.Case"."Number of cases", FILTER(VALUE_MATCHES("_ARIS.Case"."Order creation day", '3-Wednesday')))-SUM("_ARIS.Case"."Number of cases", FILTER(VALUE_MATCHES("_ARIS.Case"."Order creation day", '2-Tuesday'))))/SUM("_ARIS.Case"."Number of cases", FILTER(VALUE_MATCHES("_ARIS.Case"."Order creation day", '2-Tuesday')))*100
In my case: 6 creations on Wednesday, 2 on Tuesday which means I created 4 orders more => 200%
Not sure the logic means anything but maybe this can be adapted to your use case.