Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
Wouldn't that include all customers? Or can END_DT_YEARMONTH be NULL?
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.
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.
This seems to work perfectly.
Thank you!