Help with an Expression

[Anonymous]

Hi Guys,

I am currently working on a Chart,

I have ACCT_ID & Customer_Name as my dimensions.

At the minute I have one express Max(END_DT_YEARMONTH)

But basically what I am trying to find out is an expression that will only give me the ACCT_ID & Customer_Name and END_DT_YEARMONTH of customers where their Max END_DT_YEARMONTH is lower than the Highest Max END_DT_YEARMONTH available.

Hope that makes sense,

Cheers

[swuehl]

Wouldn't that include all customers? Or can END_DT_YEARMONTH be NULL?

[Anonymous]

Hi Swuehl,

Every customer has an END_DT_YEARMONTH,

For instance most will be 2015Feb, but some could be 2015Jan – These are the ones I want to be able to see.

[swuehl · Accepted solution]

Ah, I see, lower not lower equal 😉

Every customer only has a single record for END_DT_YEARMONTH, right?

Maybe like this:

Reuse your straight table chart, but for the expression use:

=only({<END_DATE_YEARMONTH = {"<$(=max(END_DATE_YEARMONTH))"}>} END_DT_YEARMONTH)

Your END_DATE_YEARMONTH needs to have a numeric representation, not only being a pure text field.

[Anonymous]

This seems to work perfectly.

Thank you!