Grouping field values on a chart

[ali_hijazi]

Hello I got a column in a dashboard called "Monthly Submission Offsets" with the below values

the user wants to see instead the following values:

so 01: < End Date -2, 02: End Date -2, 03: End Date -1, and 04: End Date would be replaced by 01: <= End Date and so on...

I know that it can be made in the script but the situation now is that we need to do it at the level of UI
Kindly advise

[Vegar]

You can create a master dimension where you use an nested if statement 

If(left([Monthly Submission Offsets],2)<0, '01: <= Enddate', if(...if(...etc))))

[ali_hijazi]

let me try it cause I'm using an aggr to exclude other various values
it's a calculated dimension
hope selections won't cumbersome display of filters at the top