If I have the following expression as dimension, what should be the expression to "color by expression" for the returned class intervals ( 0 to 3, 3 to 6, 6 to 9, 9 & more)?
=IF(DataField<9,dual(Replace(class(DataField,3,'Days'),'<= Days <',' to '),class(DataField,3,'Days')),IF(DataField>=9,dual('9 & more',9)))
The simplest way is to create this calculated dimension as a Master Item and then you can apply colours to the Master Item in the Master items, Dimension from the Assets panel on the left in edit mode
Thank you Lisa! For me, the value colors are applied as expected. But, for users that do not have the ability to edit sheets and publish, the master dimensions are applied in the visualization. But, the value colors are not getting applied. Instead, the standard colors are applied. Can you please suggest why the value colors are not getting applied for other users with read-only access?
