Forum Discussion
Specific group date ranges
Hi Community, I'd like to ask if it is possible to group dates and report them out via a slicer or by a measure? Value: The # of days a task takes. For instance: 0-5 days 6-10 days 11-15...
Hi Phil,
Partially! Say I have ten case numbers. Each case is associated with a time stamp on how long it took to complete.
When I choose a case, I'd like to show how long it took using this specific format:
0-5 days, 6-10 days, 11-15 days, 16-30 days
As you see it goes in increments of five, but then by 15 as the time progresses. I'd like to be able to customize that range on a single slicer. Is that possible?
Looking at it in a different light, I want to know if a case took 1 week or 2 weeks, or a month.
Thanks for your quick response.
If it helps my date format is:
Case creation date
1/1/2018 10:50:20 AM
Case close date
2/20/2018 1:23:45 PM
I am taking the difference to calculate the days or hours to pull into this slicer.