topic Grouping field values on a chart in App Development

Grouping field values on a chart

ali_hijazi — Wed, 14 Feb 2024 14:47:19 GMT

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

Re: Grouping field values on a chart

Vegar — Thu, 15 Feb 2024 06:08:49 GMT

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))))

Re: Grouping field values on a chart

ali_hijazi — Thu, 15 Feb 2024 07:54:07 GMT

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