Dual KPI Insight Usage and Example

[marcpaige]

I am struggling with this new insight. Please provide some guidance by example on its use.

[shashidhar_sris]

Hi,

Dual Dynamic KPI's  are generally used to represent two metrics/measures at a time in an insight as a primary and secondary measure. Meaning, we can compare two metrics in a single KPI.

For example, I created dual dynamic KPI showing year wise total profit in the primary measure and the growth precentage in the secondary measure.

Attached are the two screenshots for your reference.

Screenshot1: Represents dual dynamic KPI insight showing profit TY & growth percentage.

Screenshot2(For reference) : Tabular form representation of year wise Profit TY , Profit LY and growth precentage. 

Now compare growth percentage in both screenshots you will get to know what is the use of this insight.

Let me know if you need more details on this.

Regards,

Shashidhar.S

[marcpaige]

Thank you. This makes sense. Would you be able to show the formulas used in Screeshot2?

[shashidhar_sris · Accepted solution]

Sure. Find the formulae below. 

For Profit_LY: 

sum(

    Shashi_Test.Sample_Store.Profit, 

    ago(

        Shashi_Test.Sample_Store.Ship_Date, 

        1, 

        "Year"

    )

)

For Growth:

(sum(

    Shashi_Test.Sample_Store.Profit

) - sum(

    Shashi_Test.Sample_Store.Profit, 

    ago(

        Shashi_Test.Sample_Store.Ship_Date, 

        1, 

        "Year"

    )

)) / sum(

    Shashi_Test.Sample_Store.Profit, 

    ago(

        Shashi_Test.Sample_Store.Ship_Date, 

        1, 

        "Year"

    )

)

Actual Growth formula is : (TY-LY)/LY

Regards,

Shashidhar.S

[marcpaige]

Thank you so much! That is perfect.