Find Max Date

[raju_insights]

Hi Techies,

I need to find max date where all dimensions are possible.

For Example:

I have A, B, C, D as Dimension

Max date of A, B, C is 9/7/2016

Max date of D is 9/8/2016

So here 9/7/2016 is the max date where all dimensions are possible.

How to get this in expression. No backend scripting. PFA.

[Anil_Babu_Samineni]

I didn't find your E dimension value?

[effinty2112 · Accepted solution]

Hi Rangaraju,

Try:

=Max(Aggr(if(Concat(Distinct Dimension) = 'ABCD',Date),Date))

Cheers

Andrew

[#4]

You forgot a convert number to a date.

Correct formula is:

=Date(Max(Aggr(if(Concat(Distinct Dimension) = 'ABCD',Date),Date)))

BR,

Bartek

[raju_insights]

Hi Anil Babu,

Updated my content again, thanks.

[sunny_talwar]

Set analysis alternative

=Date(Max({<Date = {"=Concat(DISTINCT Dimension) = 'ABCD' "}>}Date))

[raju_insights]

Awesome Sunny,

So it is like , the set analysis considers only the value in the Date field which is true for the condition "=concat(DISTINCT Dimension)='ABCD'" and fetches the max value from that. Nice

[sunny_talwar]

Absolutely. The search string is evaluated as a true or falls for each Dimension (Date in your case) and the max will be found from those rows which meets the set analysis criteria.