Show last 15 days sales in a bar chart

[anuradhaa]

HI,

I want to show the sales in a bar chart for last 15 days.

I used below dimension 

=date(date(floor(DATE)),'MM-DD')

and expression,

=sum({$<DATE={"=DATE>=Max(total DATE)-15"}>}SALES)

all the data shows correct values but the 1st day sum is incorrect.

Please help me, what is the wrong of this expression?

Thanks

[VishalWaghole]

Hi Anuradha,

Please try this,

=sum({$<DATE={">=Max(total DATE)-15"}>}SALES)

- Regards,

Vishal Waghole

[anuradhaa]

No, that doesn't work

[anuradhaa]

simply what i need to show is sales values of last 15 days.

[#5]

Try this ..

Sum({$<DATE= {1(=Max(DATE)-15)}>}SALES)

Thanks,

Prabhu

[anuradhaa]

No, that is not working.

Could you please help me to solve my problem, how to display a bar chart that contains sales values of last 15 days.

IF you can find an answer instead of my expression that is ok. please help me.

Thanks

[anuradhaa]

Could you please help me to solve my problem, how to display a bar chart that contains sales values of last 15 days.

IF you can find an answer instead of my expression that is ok. please help me.

Thanks

[MK_QSL]

Vishal's solution should work.

If it is not working, means problem in Date format...

you can use as below...

SUM({$<DATE = {">=$(=Date(Max(Total DATE),'MM-DD')"}>}Sales)

considering that your DATE format is MM-DD.

If it is MM-DD-YYYY you can change accordingly.

Hope this helps...

[anuradhaa]

Hi this is what i have in my dimension

=date(date(floor(TURNED_ON_DATE_TIME)),'MM-DD')

and i have changed expression according to you , but doesn't work.

Thanks

[MK_QSL]

Can you share your sample data file or apps?