Year and Previous Year Issue - Set Analysis

[brunov86]

Hello all,

I'm having an issue on set analysis regarding Year and Previous Year.

I have 2 KPIs:

- 1 shows the number of student for the year selection

-1 shows the number of student for the year selection - 1 year.

The issue I have is when I select a year I have the same number for both KPIs.

Year Selection KPI:

count(distinct ${<[Calendar_Year]={$(=max([Calendar_Year]))},[ClassStatus]={'Registered'},[FinalStatus]={'Absent','Failed','In-Progress','Passed'}>} [studentid])

Year Selection-1 year KPI:

count(distinct ${<[Calendar_Year]={$(=max([Calendar_Year])-1)},
[ClassStatus]={'Registered'},
[FinalStatus]={'Absent','Failed','In-Progress','Passed'}>} [studentid])

I try to identify what is wrong with my set analysis but cannot see.

Bruno

[TimvB · Accepted solution]

The dollar in front of the set analysis is incorrect. Try this:

Year Selection KPI:

count(distinct {<[Calendar_Year]={$(=max([Calendar_Year]))},[ClassStatus]={'Registered'},[FinalStatus]={'Absent','Failed','In-Progress','Passed'}>} [studentid])

Year Selection-1 year KPI:

count(distinct {<[Calendar_Year]={$(=max([Calendar_Year])-1)},
[ClassStatus]={'Registered'},
[FinalStatus]={'Absent','Failed','In-Progress','Passed'}>} [studentid])

[maniram23]

HI Gentleman,

Please try below one.
Year Selection KPI:

count(distinct {<[Calendar_Year]={'=$(=max([Calendar_Year]))'},[ClassStatus]={'Registered'},[FinalStatus]={'Absent','Failed','In-Progress','Passed'}>} [studentid])

Year Selection-1 year KPI:

count(distinct {<[Calendar_Year]={'=$(=max([Calendar_Year])-1)'},[ClassStatus]={'Registered'},
[FinalStatus]={'Absent','Failed','In-Progress','Passed'}>} [studentid])

[brunov86]

Hello Tim,

Thank you very much for your inputs. It works well 😀.

Bruno