Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a map created with 5 data points. The pin(bubble) color is the same for each of the 5 data points. What i would like to do is put in a statement that gives me three different colors. If the total estimate 5000 then green, if total estimate 3000 then yellow and if total estimate 1000 then red. Can this be done and if so can someone help me out.
Thanks,
David
instead of the expression you currently have for the background color of longitude, use below for the requirement you have in your first post. adjust accordingly to meet your specific needs:
if(TotalEstimate=5000,rgb(0,255,0), if(TotalEstimate=3000, rgb(255,255,0),rgb(255,0,0)))
what map extension are you using?
I am not using one. I have not tried extensions. I am not sure how they work or how you set them up.
Can you please post a sample QVW? I've created a Google static map in the past using a Scattered chart where we were displaying RAG per location (At least one RED will be visible else Yellow or Green).
Here is my sample data.
instead of the expression you currently have for the background color of longitude, use below for the requirement you have in your first post. adjust accordingly to meet your specific needs:
if(TotalEstimate=5000,rgb(0,255,0), if(TotalEstimate=3000, rgb(255,255,0),rgb(255,0,0)))
Thank you for your help. I am still learning about maps so I never changed the background color of longitude so I dont know where it is. Can you point it out as I wait I will play around with it.
Nevermind. Temporary Brain Freeze. Thanks for you help.
David
we have all been there
glad could help!
I Do have one more question can you put a conditional format that when you select a bubble a chart pops up. I have done it with list boxes and charts.