topic Re: Set Analysis Help... in App Development

Set Analysis Help...

samvile18 — Thu, 27 Jan 2022 11:44:21 GMT

Hi all,

I have the following set analysis which returns the attached table:

Count(Distinct{<IsAnnualReview={'N'}>}JourneyId)

Test table

I need to add a line to the expression so it only shows the max JourneySequence. I assumed it was a mixture off Aggr(Max but I cannot seem to get it to work properly.

Any help would be greatly appreciated.

Thanks in advance.

Re: Set Analysis Help...

Marcel_Garcia — Thu, 27 Jan 2022 11:57:07 GMT

Try this:
Max(Aggr(Count(Distinct{<IsAnnualReview={'N'}>}JourneyId)))

Re: Set Analysis Help...

samvile18 — Thu, 27 Jan 2022 12:00:23 GMT

Sadly, it didn't like that at all...error on the expression with aggr needing 2 or more parameters.

Re: Set Analysis Help...

samvile18 — Thu, 27 Jan 2022 15:27:34 GMT

**BUMP**