Conditional Expression in Visualizations
Use conditional expressions to set colours and font awesome icons base on values of dimension or measure
User can choose to render visualizations based on some condition like if the value is upto 5000 then its display in red colour; if the value is above 1000 then display the text in blue colour etc.
Likewise, user can also choose to use Icon in visualizations based on condition like if the value is upto 5000 then its display in **up arrow ** in green colour, if the value is above 1000 then display in down arrow in red colour.
Following properties use conditional expressions
- Cell colour expression
- Icon Expression
- Text colour expression
- Segment Colour Coding
-
Click on tool of visualization in which you want to use conditional expressions.
-
Click on setting option for the popup menu.
-
When you click on setting option its open right side penal. select dimension or measure you want to use for conditional expressions.
-
Select the property for conditional expressions and click on Set Conditional Expressions icon.
-
When you click on Set Conditional Expressions icon its open Colour Expression popup.
-
Colour Expression popup allows to added and remove Conditional.
-
Click on Add Condition button to added condition.
-
When you click on Add Condition button it adds a new row for the condition. that row contains three or four option.
- condition-drop-down - possible value [upto, above, below, default]
- enter value - possible value [any real number]
- Select colour - possible value [colour code]
- Icon name(optional) only add when use **icon expression . enter font awesome me.
see available font awesome icon name list
-
If you want to remove any condition then click on remove icon.
-
Click on save button to save condition expression.
