can you pass me the ranges of colors to create the calculated field please
I have 13 zones so I wanted to evaluate each zone like this:
(COUNT([hitszona6]=TRUE) / COUNT([Zone]="zona6"))
blue from 0 to .225
white from .225 to .315
red from .315 to 1.000
Hi Alan, is there a way? thanks for your help!
I think you'll need to get all the values in a single field in order to accomplish what you are looking for. Could you not create a field similar to the below:
IF [hitszona6] = 'TRUE' THEN (COUNT([hitszona6]=TRUE) / COUNT([Zone]="zona6"))
ELSEIF [hitszona1] = 'TRUE' THEN (COUNT([hitszona1]=TRUE) / COUNT([Zone]="zona1"))
That should get all the metrics in single field which you could then use to color the viz.
Hope this helps,
Can you share a twbx of your work?