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]

Didnt work

[#3]

See what i added:

Sum({<Status={'Actual'}, Date = {'$(=Max(Date))'}>} Data)

[its_anandrjs]

Hi,

What is your date format  And assume this example

LOAD *,Date(Date,'YYYY/MM') as MonYr;

LOAD * Inline

[

Date,Amount

1/2/2013,1589632

8/12/2013,12569

8/14/2014,14896

9/24/2014,25698

];

Dim:- MonYr

Expre:- sum({<MonYr = {'$(=max(MonYr))'}>}  Amount)

In this out put you get 25698 out put same you can do with the field even triggers but it affects the other charts also.

Hope this helps

Regards,

Anand

[its_anandrjs]

Did you check the date format is correct also check the value of this expression =Max(Date) in any text object and what you get.

Regards,

Anand

[#6]

Am dealing with dbase

[#7]

Sum({<Activity={'Stations'}, Status={'Actual'}, Aggr(Date)>} Data)

Didnt work

[its_anandrjs]

If you use AGGR you have to use the fields means from which rows you need to aggregate the data

Ex:-

Aggr(Sum(Sales),FIELD1,field2)

Check the fields first.

Regards

Anand

[#9]

The only field i have from cross loading is 'Data'

[#10]

This off the point

[#11]

Hi,

Lets supose that your field name is AnoMes. then you have ty apply a Set Analysis in the expresstion you are using.

Example:

if you have sum(sales) then you type:

Sum({<AnoMes={$(=Max(AnoMes))}>}  sales)