Selecting Max date and Max value to display Dimension

[adley51788]

Hello,

I am trying to display a dimension based on the max of two values.  For example:

Engagement :: Date :: Level

A ,10/1/2015,3

A ,10/1/2015,2

A, 09/29/2015,3

B,10/2/2015,3

B ,10/2/2015,2

B, 09/29/2015,3

C ,10/2/2015,3

C ,10/2/2015,2

C, 09/29/2015,3

I would expect to see --

A,10/1/2015,3

B,10/2/2015,3

C,10/2/2015,3

Thank you!

[sunny_talwar · Accepted solution]

Try this:

Dimension

Engagement

Expression

1) =Date(Max(Date))

2) =FirstSortedValue(Level, -(Date*10000 + Level))

[adley51788]

Thank you for your response.

I am getting a null value for the level field in my data set. Would it be possible to display the max level even if the date is null?

Thanks!

[sunny_talwar]

Would you be able to share a sample for that scenario with the expected output?