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...
Phil_Seamark's avatar
Phil_Seamark
Microsoft Employee
8 years ago

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'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.

  • Theasianmenace's avatar
    Theasianmenace
    Frequent Visitor
    8 years ago

    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.

  • 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