Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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))))
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