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 days
- 16-30 days
- 31-60 days
Similar to how you can report out by weeks, but I am looking to group them as an evaluation metric.
I've tried comparisons with a DAX calendar or used filtered slicers. Can anyone help shine a light on a more robust solution?
Many thanks!
4 Replies
Do you mean using a numeric slicer that allows users to pick any number, say 17, and based on that it will return every row that falls in to the band 16 to 30 days?
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.
