-
1. Re: Selecting last 3 dates from a list of dates dynamically
Mahfooj Khan Jul 28, 2016 12:29 AM (in response to Shaji Mathew)2 of 2 people found this helpfulYou can try something like this. Drag this calc field in filters shelf and filter 1 to 3.
Hope this help.
Mahfooj
-
2. Re: Selecting last 3 dates from a list of dates dynamically
Shaji Mathew Jul 28, 2016 1:21 AM (in response to Mahfooj Khan)Thanks very much. It did work.
But when I move to Columns pane, it is not working.
Even sometime it work, when additional information added, it expand to all.
Thanks..
-
3. Re: Selecting last 3 dates from a list of dates dynamically
Mark FraserJul 28, 2016 2:07 AM (in response to Shaji Mathew)
Hi Shaji
You can do it multiple ways...
Something like this is also possible - working example attached, suing Superstore (v9.3.5)
logical test if date is last 3 days (dates must be pre-sorted by date)
LAST() >= 0 and LAST()<3
That will return true for the last 3 days, then use that calc, to leverage your sales...
- sum = IF [last 3 days] THEN SUM([Sales]) END
- avg = IF [last 3 days] THEN AVG([Sales]) END
Hope that helps!
Cheers
Mark
-
212020.twbx 300.7 KB
-
4. Re: Selecting last 3 dates from a list of dates dynamically
Shaji Mathew Jul 28, 2016 2:32 AM (in response to Mark Fraser)Thanks very much..
I have resolved the issue .
Thanks once again to both Mahfooj & Mark.
-
5. Re: Selecting last 3 dates from a list of dates dynamically
Mark FraserJul 28, 2016 3:00 AM (in response to Shaji Mathew)
Shaji, out of interest, which method did you use?
-
6. Re: Selecting last 3 dates from a list of dates dynamically
Shaji Mathew Jul 28, 2016 3:15 AM (in response to Mark Fraser)1 of 1 people found this helpfulI used your solutions and used it as a filter.
thanks