Forum Discussion

Theasianmenace's avatar
Theasianmenace
Frequent Visitor
8 years ago

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...
Theasianmenace's avatar
Theasianmenace
Frequent Visitor
8 years ago

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's avatar
Anonymous
Not applicable
8 years ago

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