Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Change your expression to :
=sum({$<SALESDATE={"=SALESDATE>=Max(total Floor(SALESDATE))-15"}>}SALES)
Hi Anuradha,
Please try this,
=sum({$<DATE={">=Max(total DATE)-15"}>}SALES)
- Regards,
Vishal Waghole
No, that doesn't work
simply what i need to show is sales values of last 15 days.
Try this ..
Sum({$<DATE= {1(=Max(DATE)-15)}>}SALES)
Thanks,
Prabhu
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
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
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...
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
Can you share your sample data file or apps?