MAX value in alternate state field

[LDR]

Hi to everyone,

I'm trying to find the way to obtain the MAX value for some field that is assigned to a specific Alternate State.

First at all let me show you my data:

Data:
Load *
Inline [
ReportingPeriod
2022-09
2022-08
2022-07
2022-06
];

I have created two Alternate States: A and B. I have created two Filter Pane charts for the same field but with a differente Alternate State assigned.

In a table chart I want to show how many items were selected for each alternate state (it works) and the MAX value selected for Alternate State B (it doesn't work).

Instead of MAX({B}ReportingPeriod) I tried some other ways with no luck:

MAX({<ReportingPeriod=B::ReportingPeriod>}ReportingPeriod)

or

MAX({B<ReportingPeriod=$::ReportingPeriod>}ReportingPeriod)

Any idea about what I'm doing wrong?

Thanks in advance

[rubenmarin]

Hi, probably ReportingPeriod is being loaded as a text, not a number, so instead of Max() you can use Maxstring(). Or convert to number using Sate() and Date#() functions.

[LDR · Accepted solution]

OMG! Thanks a lot Rubén. I forgot that I was playing with alphanumerical values instead of numbers.