Color based on %

[NavinReddy]

Dear Experts,

i have google map based on percentage i want to give bubble colors

not sure where im doing wrong i not getting colors on map

please help me on this error

for reference i have attached sample application

Best Regards,

Niranjan

[anagharao]

Hi Niranjan,

Please use column() function to specify which column value you want to check and equate a color to.

[tresesco]

Instead of using the background color for your P1Month expression use it for Longitude. It should work. One more thing, I notice values for your variable is same 102.98 for all states. Is that right?

[NavinReddy]

Hi Tresesco,

Thanks for your reply,

yes the is for all the states for rolling 3 months

how can i validate the map is displaying only 3months values

please suggest me

Best regards,

Niranjan

[tresesco]

Now it's a different question. Well, you can check your monthly data at state level and check if the latest three months data is summing up to 102.82 or not.

[NavinReddy]

Actually my concern is based on bubble i want to display 3months information of sales

but bubble is displaying different information

i can see longitude and latitude information bubble

Any suggestion how to display expression information on bubble. please help me on this error

Thanks,

Niranjan

[NavinReddy]

Good Morning to All,

i want to display expression value on google map bubble

Any suggestions

Best Regards,

Niranjan

[Anonymous]

in two ways to give the colour to select the custom format cell (cltrl g) than select partcular cell to give condition in the condition which way you want

[NavinReddy]

Hi Sudhakar,

Thanks for your reply

i want to display expression values on bubble

now on bubble im getting longitude and latitude, but i want to display values

Best Regards,

Niranjan

[tresesco · Accepted solution]

1. Presentation tab-> Uncheck 'Pop-up Labels'
2. Expression tab-> Select your expression 'P1Month'-> Check 'Text as pop-up'