KPI("cancelled_cases")*(KPI("cost_per_transaction"))
The Cost per transaction should stay the same figure:
Cost per transaction: KPI("total_operating_costs")/Global(KPI("case_count"))
So the Case count above must stay the total amount of cases and not reduce if I filter for a shorter time. The Total operating cost is a constant figure.
Hi,
Maybe create KM variable, that will be updated on the daily basis? Then as It's not connected to any table in DM, shouldn't be affected by the filtering?
Best Regards,
Mateusz Dudek
Hi,
Maybe create KM variable, that will be updated on the daily basis? Then as It's not connected to any table in DM, shouldn't be affected by the filtering?
Best Regards,
Mateusz Dudek
thanks Mateusz, I tried the following now that seems to work
KPI("total_operating_costs") / PU_COUNT ( CONSTANT ( ) , ${{case_tbl_casekey}} )
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
