topic Keeping a KPI from changing with filter selections. in App Development

Keeping a KPI from changing with filter selections.

aschmeelk — Fri, 02 Apr 2021 07:56:39 GMT

I have a KPI on a sheet that I want to have and keep the value for a specific set modifier no matter what is selected on the sheet. Example:

So here, the large value will be the Site, the small value should be the average of All sites (There are 4 KPIs one for each site.)

This KPI has the following Measures:

Average(for specific site):

Avg(Aggr({<PLANT_CODE={'BET'}>} //Site location code
Floor(Only(
{<[Process Code]-={'CC','CP','BS'},[Tread]-={'POOL','REPONLY'},[Casing Status]-={'DELETED'}>}[Completed Date]))
-
Floor(Only(
{<[Casing Status]-={'DELETED'}, [gra_audit_trail.POST_NAME]={'RECEIVING'},ACTION_NAME={'SHIP_RECEIVING'}>}[Audit Create]))
,[Tag #]))

This Seems to work, except that when I select a filter item ie Year, Customer, Plant Name from the filter bar(below),

the KPI values change.
I want it to always reflect the average for the site code selected and I can't seem to make this happen!

Any help or insights are appreciated!

Re: Keeping a KPI from changing with filter selections.

jwjackso — Wed, 29 May 2019 18:02:44 GMT

Try using {1} as part of you set analysis statement.

Re: Keeping a KPI from changing with filter selections.

aschmeelk — Thu, 30 May 2019 13:12:14 GMT

Yeah, I've tried that, doesn't seem to work.

Re: Keeping a KPI from changing with filter selections.

Lauri — Fri, 07 Jun 2019 18:17:33 GMT

Did you put 1 in all 4 places, including for the Avg function?

Avg({1} Aggr({1<PLANT_CODE={'BET'}>} //Site location code
Floor(Only(
{1<[Process Code]-={'CC','CP','BS'},[Tread]-={'POOL','REPONLY'},[Casing Status]-={'DELETED'}>}[Completed Date]))
-
Floor(Only(
{1<[Casing Status]-={'DELETED'}, [gra_audit_trail.POST_NAME]={'RECEIVING'},ACTION_NAME={'SHIP_RECEIVING'}>}[Audit Create]))
,[Tag #]))

Re: Keeping a KPI from changing with filter selections.

aschmeelk — Mon, 10 Jun 2019 12:10:32 GMT

Thank you! Adding the {1} to the AVG function did the trick.