Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi Rangaraju,
Try:
=Max(Aggr(if(Concat(Distinct Dimension) = 'ABCD',Date),Date))
Cheers
Andrew
I didn't find your E dimension value?
Hi Rangaraju,
Try:
=Max(Aggr(if(Concat(Distinct Dimension) = 'ABCD',Date),Date))
Cheers
Andrew
You forgot a convert number to a date.
Correct formula is:
=Date(Max(Aggr(if(Concat(Distinct Dimension) = 'ABCD',Date),Date)))
BR,
Bartek
Hi Anil Babu,
Updated my content again, thanks.
Set analysis alternative
=Date(Max({<Date = {"=Concat(DISTINCT Dimension) = 'ABCD' "}>}Date))
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
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.