Set chart to pick max date by default

Wed, 17 Dec 2014 21:00:01 GMT

Hello,

Find attached.

Re: Set chart to pick max date by default

MarcoWedel — Wed, 17 Dec 2014 23:15:28 GMT

Hi,

one solution could be:

default / without selection:

but still showing the result for a selected Month:

Using this chart expression:

Sum({$<MonthName={'$(=Date(Max(MonthName),'YYYY/MMM'))'}>} Data)

and changing your load script to generate an additional MonthName field during load instead of a list box with expression to do so:

table1:

CrossTable(Month, Data, 3)

LOAD Year,

Revenue,

Station,

Jan,

Feb,

Mar,

Apr,

May,

Jun,

Jul,

Aug,

Sep,

Oct,

Nov,

Dec

FROM

(ooxml, embedded labels, table is Sheet1);

Left Join

LOAD Distinct

Year,

Month,

Date#(Year&'/'&Month, 'YYYY/MMM') as MonthName

Resident table1;

hope this helps

regards

Marco