Skip to main content
Top Header
Question

How do I keep the denominator in my Calculation constant (so that it doesnt change when I filter on it for different dates)

bennita.dutoi12
Level 4
Forum|alt.badge.img+6

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.

    mateusz.dudek14
    Level 7
    Forum|alt.badge.img+11

    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

    bennita.dutoi12
    Level 4
    Forum|alt.badge.img+6
    mateusz.dudek14 wrote:

    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}} )

     

     

    Reply


    Community Code of Conduct