topic Re: KPI Chart not giving an option for Aggregation when creating KPI Chart, and not calculating correctly when using the expression creator in App Development

KPI Chart not giving an option for Aggregation when creating KPI Chart, and not calculating correctly when using the expression creator

spjuza — Fri, 10 Dec 2021 16:40:50 GMT

I am trying to create a KPI chart that will show the potential savings opportunity that exists. I have created the master measure ("Potential Savings") that relies on another Master Measure ("Average Cost") and it's displaying correctly when I create a table.

When I create a KPI chart and add it, I do not get an an option to add an aggregate function (Screenshot attached).

I read somewhere that nesting Master items can cause issues, so in the expression I just typed in the expression of the "Average Cost" master measure, but still no success.

Lastly, I tried manually doing the Sum aggregation, but it says it cannot accept nested Aggregations.

Re: KPI Chart not giving an option for Aggregation when creating KPI Chart, and not calculating correctly when using the expression creator

AshutoshBhumkar — Sat, 11 Dec 2021 13:37:06 GMT

Can you share the expression you are using ?

Re: KPI Chart not giving an option for Aggregation when creating KPI Chart, and not calculating correctly when using the expression creator

spjuza — Mon, 13 Dec 2021 13:56:34 GMT

The master expression is this:

if(([Var3]<(Sum({$<[Var1]={">0"}>}[Var2])/sum({<[Var1]={">0"}>}[Var1]))),
(Sum({$<[Var1]={">0"}>}[Var2])/sum({<[Var1]={">0"}>}[Var1])
- [Var3]) * Var4,0)

The sum block is a separate measure, so I've also tried:

if(([Var3]<([Average Cost])),([Average Cost] - [Var3]) * Qty,0)

Re: KPI Chart not giving an option for Aggregation when creating KPI Chart, and not calculating correctly when using the expression creator

spjuza — Wed, 15 Dec 2021 15:53:31 GMT

I solved this by calculating the necessary variable in the data load script. The issue seemed to be because I was including a dimension in the measure calculation.