Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a field called 'capLEVEL'
I want to use this in a chart as a dimension, however when I use this field, i want to exclude the following, which are records in this field:
100 Preferred Rinkside
100 Level II Rinkside
100 Level III Rinkside
Hockey Suite.
How would I structure the 'expression' for my dimension
May be like this
If(not Match(capLEVEL, '100 Preferred Rinkside', '100 Level II Rinkside', '100 Level III Rinkside', 'Hockey Suite.'), capLEVEL)
May be like this
If(not Match(capLEVEL, '100 Preferred Rinkside', '100 Level II Rinkside', '100 Level III Rinkside', 'Hockey Suite.'), capLEVEL)
Helpful as always, thank you