Selecting Latest Quarter

[Anonymous]

I need to create a line chart by selecting the latest year and quarter. PERIOD field has values like:

2013 1Q

2013 1H

2013 2Q

2013 FY

2012 4Q

2012 2H

...

I need to look for 2013 2Q for example.

Is there any finction that I could use or need to split it by Substring() ?

[Nicole-Smith · Accepted solution]

=maxstring({<PERIOD = {'???? ?Q'}>}PERIOD)

[Anonymous]

This worked fine in a Text Object but can't seem to use it as a calculated Dimension in a Straight Chart.

[Nicole-Smith]

Make a variable (i.e. vMaxQuarter with the expression from above), then make your dimension on the chart:

=if(PERIOD = vMaxQuarter, PERIOD)