How to set chart to pick latest report

[#1]

Hello,

Find attached. I want to set my combo chart to pick the latest report sent in everyday of the week so that every lastest update will be show on chart then the previous data will be on history.

Rgds

Ema

[PradeepReddy]

use the bellow expressions...

Sum({<Day={$(=max(Day))}>}Actual)

Sum({<Day={$(=max(Day))}>}Target)

It is better to create a Date_ID in script and use that Date_ID in the expression as well.

EX: Year&'-'&Month&'-'&Day

[#3]

This worked to some extent but cant we use the date instead of day? because this doesn't consider the month.

I already concatenated Month and Day.

[PradeepReddy]

Concatenate the Year also...

Take the Date of the transaction and use it in the the expression.

[#5]

After concatenation i did this:

Sum({<Date={$(=max(Date))}>}Actual)

Didnt work out

[#6]

Find attached i now got the first answer i was running away from when i use only "sum(Acutal)" and "sum(Target)" Please how do i resolve this?

[PradeepReddy]

Try like this...

Sum({<Date1={'$(=max(Date1))'}>}Actual)

Sum({<Date1={'$(=max(Date1))'}>}Target)

[sateeshkumar]

Try this one

=Sum({<Date1={'$(=vmaxdate)'}>}Actual)

where vmaxdate=max(Date1)

[#9]

Hello Pradeep,

This worked but when i click on the previous date chart doesn't display previous days info. which is very rigid not flexible to swiitch back to history. Also this script: Sum({<Date1={'$(=max(Date1))'}>}Actual) will not obey the law of date in ascending order because its dealing with the value direct giving you the Max number instead of the latest date