Ignoring all selections including the fields used in count Set

[shyamcharan]

Hi Experts,

I have created a dashboard that displays the KPIs on top in small text boxes.

KPI1: displays data for last Finanical year till yesterday

KPI1=Num(

Sum({1<FYTD_TY={1},Actual_Date=>+1<MTD_TY={1},FYTD_TY={0},Actual_Date=>+1<Actual_Date={"$(=Max(Actual_Date))"}>}Incident_Count)

,'#,##0')

Now, I have created another KPI to show data till Jan that is till completed month:

KPI2=Num(

Sum({1<FYTD_TY={1}>}Incident_Count)

,'#,##0')

Now my requirement is to display data in the below charts when the user selects any of the KPI above.

In the actions of the above text objects display I have used 'Select in Field' option.

However, when KPI2 is selected the KPI1 values is also changing because they share common field Actual_Date or FYTD_TY as part of their Sets Analysis logic.

My requirement is, irrespective of any other selections, I want the KPI values to remain unchanged.

Can you please suggest how i can achieve this?

Thanks in advance.

Regards,

Shyam.

[kaushiknsolanki]

Hi,

Can you paste sample application.

Regards,

Kaushik Solanki

[#3]

You can duplicate the data that is being used to calculate KPI2 so that it is no longer related to KPI1 by name-association of the FYTD_TY and Incident_Count fields.

In your loader script...

LOAD

    FYTD_TY as FYTD_TY_KPI2,

    Incident_Count as Incident_Count_KPI2

RESIDENT ((your table name)) ;

Your calculation should reflect these changes...  Sum({1<FYTD_TY_KPI2={1}>}Incident_Count_KPI2) ... also.

This will logically separate the KPIs.

HOWEVER, KPI2 looks pretty static to me as it's from data set {1}, so you might consider calculating it entirely at load time.

[sunny_talwar · Accepted solution]

Can you give this a shot:

KPI1 =

Num(Sum({1<FYTD_TY={1},Actual_Date=> +

                  1<MTD_TY={1},FYTD_TY={0},Actual_Date=> +

                  1<Actual_Date={"$(=Max({1} Actual_Date))"}>}Incident_Count), '#,##0')

[shyamcharan]

Thank you all for the responses.

Thanks Sunny.

That works like a charm. Thanks heaps.