What is the syntax for trailing Quarter for last 90 days from Today?

[arunqlik2view]

Hello All, 

Please help me with the syntax for Trailing Quarter for past 90 days from today(). 

I'm trying to have a chart with 2 measures 

1. Sum (Actual_Revenue)

2.  Sum (Predicted_Revenue)

These two Measure should data only for last 90 days from Today. 

the dimension for Date is "Date1"

Thanks in Advance,

Arun

[sunny_talwar · Accepted solution]

May be try set analysis or a calculated dimension like this

If(Date1 >= Today() - 90, Date1)

and make sure to select 'Suppress When Value Is Null' on the dimension tab for the above dimension

[arunqlik2view]

Hi Sunny,

Thanks for the Quick reply. I got the chart, but I got them as individual bars for each day in the last 90 days.

1. Can I have it have as just 1 bar for all 90 days as Trailing Quarter. 
2. Also it took like 3 or 4 days extra, I mean instead of 90 days , it seems like it took last 94 days.
   The most recent date I have for the column Date1 is 26-11-2018 , 
   so (26-11-2018 -  90 days) = 28-08-2018 , shows in excel. 

Thank you,

Arun

[sunny_talwar · Accepted solution]

1) Use this may be

If(Date1 >= Today() - 90, 'Trailing Quarter')

2) Difficult to say without seeing a sample

[arunqlik2view]

@  2) Difficult to say without seeing a sample .

Here is the data I use and out put i get for last 90 days after using "=If(Date1 >= Today() - 90, Date1)" syntax. 

Kindly take a look and let me know what Am I doing wrong. 

Thanks,

Arun 

[arunqlik2view]

data file 

[purna]

Hello Sunny

Can you please give me the expression for last 60days sales value using addmonth

I have oct,nov,dec sales

Expression Given:

=sum({<Month={"$(=addmonth(max(Month)-2))>=$(addmonth(max(Month)))"}>}Sales)

Result:

But throwing the result same as sum(sales),but i want only last 60 days value, please help me in this

Thanks in advance

Purna.