Specific group date ranges

[Theasianmenace]

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:

1. 0-5 days
2. 6-10 days
3. 11-15 days
4. 16-30 days
5. 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!

[Phil_Seamark]

HI @Theasianmenace

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?

[Theasianmenace]

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.

[Anonymous]

HI @Theasianmenace,

>>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?

Nope, it is impossible.

AFAIK, you can only write a customized calculate column to grouping records with specific category.

Regards,

Xiaoxin Sheng

[Theasianmenace]

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.