Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
samvile18
Creator III
Creator III

How to Remove These Nulls...

I've got the following set analysis which returns this table, I want the table to return just the max Sequence for each ID...can someone point out where I'm going wrong please?

Max(Aggr(Count(Distinct

{<
JourneyStartDate_MonthStart = {"$(vFromDate)"},
ProcessEndDateNoBlanks_MonthEnd = {"< $(vToDate)"},
IsAnnualReview={'N'}
>}
JourneySequence), JourneyId))

 

What I'd want here is the  ID, Status and Journey Sequence to be just relevant to the max of 8What I'd want here is the ID, Status and Journey Sequence to be just relevant to the max of 8

For the above I'd want to see just the on Id, Business in Force and 8...I feel like I'm so close.

Labels (2)
1 Reply
rubenmarin

Hi, maybe you only need: Max(TOTAL <JourneyId> JourneySequence)