5 Replies Latest reply on Jan 14, 2019 10:15 AM by Tim Dines

HOW CAN I USE 2 OR MORE COLOR MARKS WITH DIFERENT CALCULATIONS

Hi, i'm working with a data set and some polygons to identify zones, and I want to create a HeatMap doing some calculations for each zone.

This is the calculation i'm using for the zone

(COUNT([hitszona6]=TRUE) / COUNT([Zone]="zona6"))

But my problem is that i can only use 1 calculation for colors

And I need to evaluate with colors each zone for example if the calculation for zone 6 is >.300 that zone has to be Red, if zone 2 is <.250 has to be Blue, but again I can't run the calculations I need to color them, hopefully I can get any kind of guidance thanks!

• 1. Re: HOW CAN I USE 2 OR MORE COLOR MARKS WITH DIFERENT CALCULATIONS

can you pass me the ranges of colors to create the calculated field please

Regards

• 2. Re: HOW CAN I USE 2 OR MORE COLOR MARKS WITH DIFERENT CALCULATIONS

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

• 3. Re: HOW CAN I USE 2 OR MORE COLOR MARKS WITH DIFERENT CALCULATIONS

Hi Alan, is there a way? thanks for your help!

• 4. Re: HOW CAN I USE 2 OR MORE COLOR MARKS WITH DIFERENT CALCULATIONS

Hi Hector,

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"))

ELSEIF...

END

That should get all the metrics in single field which you could then use to color the viz.

Hope this helps,

Travis

• 5. Re: HOW CAN I USE 2 OR MORE COLOR MARKS WITH DIFERENT CALCULATIONS

Can you share a twbx of your work?