Forum Discussion
CW112358
Helper II
Helper IICount Something in Last N Days
I want to count Status of pending tasks in the last 7 days, 14 days, 30 days, 60 days, etc. I want to turn that into a slicer/filter for using on an entire page that has 6 graphs on it. I have been...
CW112358
It automatically updates everyday. However, after some tests, I would suggest you to use Between Slicer with the following column, this is a more dynamically way compared with create options of last days of 7,14,30,etc...
LastNdays =
var a=DATEDIFF([Date],TODAY(),DAY)
Return IF(a <= 0, BLANK(),a)
Paul Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
CW112358Helper II
Helper III could do this 100% cause I know how it works, the issue with using a drag slicer is I would have to explain that to higher management. They understand check boxes and push buttons, they don't get the drag slicer idea so I really need to make this as easy as possible for them.