topic Re: Year and Previous Year Issue - Set Analysis in App Development

Year and Previous Year Issue - Set Analysis

brunov86 — Tue, 21 Dec 2021 20:43:45 GMT

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

Re: Year and Previous Year Issue - Set Analysis

TimvB — Fri, 07 Feb 2020 18:06:57 GMT

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])

Re: Year and Previous Year Issue - Set Analysis

maniram23 — Fri, 07 Feb 2020 19:38:55 GMT

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])

Re: Year and Previous Year Issue - Set Analysis

brunov86 — Mon, 10 Feb 2020 16:32:33 GMT

Hello Tim,

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

Bruno