Is there a way to condition a chart to show the latest max date data?

[#1]

Hello,

I have a chart and it monitoring the latest month data how do i set it to pick the latest  month data. Date is in this format "YYYY/MM"

Rgds

[#2]

Use max(month) in either dimension or expression using an if condition. You can even do the same with a trigger.

Sometimes only max(month) will not come, try using aggr (which is similar group by in sql)

[its_anandrjs]

Hi,

In the expression write

Sum({<MonthYear = {'$(=Max(MonthYear))'}>}  Metrics)

Ex:-

Sum({<MonYr = {'$(=Max(MonYr))'}>}  Sales)

Here MonYr field is in the format of "YYYY/MM"

And  write this expression in the chart expression.

Regards

Anand

[#4]

Am applying to only one chart on a sheet not all chart on the sheet

[#5]

Then put it in a expression using if condition, Sum(if(month=max(month), sales,null())

[#6]

Didnt work

[saumyashah90]

Sum({<MonthYear = {'$(=Max(MonthYear))'}>} Metrics)

[saumyashah90]

What are you using that in... in Calendar or normal chart?

[#9]

Try aggr, if max is not working properly, use your highest aggregate column for  aggr.

[#10]

Didnt work