Comment on page
The action will conditionally apply a symbol (icon) for a cell with a measure and the one of the predefined algorithms: “Positive/Negative” or “Less than 100%”.
"Positive/Negative" algorithm can be used to show icons for postive, negative and zero values by setting appropriate icons.
"Less than 100%" algorithm can be used to show icons for values less than 100% and for values greater or equal to 100% by setting appropriate icons.
The "Expression" option allows to map the "Symbol" expression's values to particular icons. To be able to use such option a "Symbol" expression should be set for a measure using the properties panel:
if("± SALES %" < 0, 'down', 'up')
After binding the measure with a cell (in our case the "± SALES %" measure) it is possible to map the "Symbol" expression's values to particular icons:
You can add as many mapping items as needed by clicking the button
next to the "Edit mappings" label. For each added row you need to specify a value (by entering it in the input text field) and an icon (by selecting it from the icon popup menu).