Aggregating Dates Beast Mode

I have an existing simple bar chart that is displaying a count of daily activity.

The current fields are Date_StatusChange on my X axis and COUNT of Status_Desc as my Y axis.

I'd like to aggregate all dates prior to Aug, 25, 2024 as "Carry-In" so I can display a count of everything prior to that date as "Carry-In" and continue the daily count after Aug, 25, 2024.

Is this possible? All my attempts have been off so far. Thanks

Best Answer

  • ArborRose
    ArborRose Coach
    Answer ✓

    A calculated field something like this?

    CASE 
    WHEN `Date_StatusChange` < '2024-08-25' THEN 'Carry-In'
    ELSE CONCAT(YEAR(`Date_StatusChange`), '-', MONTH(`Date_StatusChange`), '-', DAY(`Date_StatusChange`))
    END

    ** Was this post helpful? Click Agree or Like below. **
    ** Did this solve your problem? Accept it as a solution! **

Answers

  • ArborRose
    ArborRose Coach
    Answer ✓

    A calculated field something like this?

    CASE 
    WHEN `Date_StatusChange` < '2024-08-25' THEN 'Carry-In'
    ELSE CONCAT(YEAR(`Date_StatusChange`), '-', MONTH(`Date_StatusChange`), '-', DAY(`Date_StatusChange`))
    END

    ** Was this post helpful? Click Agree or Like below. **
    ** Did this solve your problem? Accept it as a solution! **