Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am trying to display only last 4 months.
so for thaat I have Canonical_Month in script, which contains all 2015 and 2016 months.
LOAD
Date(CanonicalDate, 'MM-DD-YYYY') AS CanonicalDate,
Month(CanonicalDate) As Canonical_Month;
Now i need only last 4 months irrespective of year.
How could i do this? Any help is appreciated
Hi,
You can use the Where condition to restrict your data.
After From or Resident statement you should use Where condition like below.
Load *
From XYZ
where CanonicalDate >= addmonths(today(),-4);
Regards,
Kaushik Solanki
Hi,
You can use the Where condition to restrict your data.
After From or Resident statement you should use Where condition like below.
Load *
From XYZ
where CanonicalDate >= addmonths(today(),-4);
Regards,
Kaushik Solanki
Hi,
Thanks for reply
If i need to apply this condition in front end of Dimension. How could i restrict data in dimension instead of in script using where condition.
Could that be done?
Hi,
In front end you should use the set analysis.
Your expression will become.
Sum({<Date = {">=$(=Addmonths(Max(Date),-4))"}>}Sales)
Regards,
Kaushik Solanki