topic Dual KPI Insight Usage and Example in Dashboards & Analytics Discussions

Dual KPI Insight Usage and Example

marcpaige — Wed, 06 Sep 2023 21:59:03 GMT

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

Re: Dual KPI Insight Usage and Example

Shashidhar — Thu, 07 Sep 2023 13:47:16 GMT

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

Re: Dual KPI Insight Usage and Example

marcpaige — Fri, 08 Sep 2023 14:22:00 GMT

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

Re: Dual KPI Insight Usage and Example

Shashidhar — Fri, 08 Sep 2023 15:13:53 GMT

Sure. Find the formulae below.

For Profit_LY:

sum(

Shashi_Test.Sample_Store.Profit,

ago(

Shashi_Test.Sample_Store.Ship_Date,

"Year"

)

For Growth:

(sum(

Shashi_Test.Sample_Store.Profit

) - sum(

Shashi_Test.Sample_Store.Profit,

ago(

Shashi_Test.Sample_Store.Ship_Date,

"Year"

)

)) / sum(

Shashi_Test.Sample_Store.Profit,

ago(

Shashi_Test.Sample_Store.Ship_Date,

"Year"

)

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

Regards,

Shashidhar.S

Re: Dual KPI Insight Usage and Example

marcpaige — Fri, 08 Sep 2023 15:11:45 GMT

Thank you so much! That is perfect.