Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Grouping column values

This is the visual I am currently working on, tracking aging tickets. The X-axis is derived from a Measure I created called "DaysSinceOpen" which is just a measure of DateDiff of the created da...
Need Help
  • DOLEARY85's avatar
    DOLEARY85
    3 years ago

    You could try wrapping the datediff in if statements: e.g for 1-7 days 

     

    Dayssinceopen = if(DATEDIFF(MAX('Table'[created date]),today(),DAY)<8,"1-7","more")
     
    then just add more conditions,
     
    hope this helps
DOLEARY85's avatar
DOLEARY85
Icon for Resident Rockstar rankResident Rockstar
3 years ago

You could try wrapping the datediff in if statements: e.g for 1-7 days 

 

Dayssinceopen = if(DATEDIFF(MAX('Table'[created date]),today(),DAY)<8,"1-7","more")
 
then just add more conditions,
 
hope this helps