i have a single metric in my view, the range of the metric is -.20 to .33 it is a continuous measue so it can take on any values within that range. but it only shows 1 value at a time
instead of a text value i want to show a colored shape, either Green UP arrow or Red DOWN arrow... so if user changes flter on this view the value will change and the arrow and color should change...
right now i dragged the metric onto color selected 2 color diverging and the current value is + so i selected the up arrow... but when i change the filters, the arrow stays up. how do i properly make these adjustments for all the condiitons
Hi Jon,
Try creating a calculated field i.e:
IF SUM ([your_field]) > 0 THEN "Positive" ELSE "Negative" END
(i'm using > 25000 in this example)
Then put this field in your "Shape":
Change the shape so it shows "Arrows", and select the ones you like:
(Did this using Superstore data sample)
Hope it helps!.
BR,
Aldimar.
