Expression

[smilingjohn]

Hi All

I have   bar chart which should display always 9 months from current date.

this is December month therefore it should display from dec to April.(4 to 12)

The month is in number format it displays  for Jan- 1, Feb-2....and so on ... as shown in the the screenshot.

Iam using the the below expression expression to display 9 month data ..

Please correct me ..this is not working .

The dimension is Month

expression :  

Sum ({<Month={">=$(=date(addmonths(Month,-9),'MMM-YYYY'))<=$(=max(date(addmonths(Month,0)),'MMM-YYYY'))"}>}Tickets)

Thanks in advance

[its_anandrjs]

Simple use but no need to change date format if required then change.

Sum ({<Datefield={">=$(=Date(addmonths(Datefield,-9))) <=$(=max(Date(addmonths(Month,0))))"}>} Tickets)