Forum Discussion
Categorize a single point on a map
- 10 years ago
I did something similar on my Olympic Bid report where the host city was a different color than the other candidate cities. It was accomplished by having a column with a "1" for host and "0" for non-host. You could add a column to your data for an "Home" flag of 1 or 0 (boolean of true/false might work too). From there, try adding that column to the Color Saturation and configure the min/max colors in the Format area.
I did something similar on my Olympic Bid report where the host city was a different color than the other candidate cities. It was accomplished by having a column with a "1" for host and "0" for non-host. You could add a column to your data for an "Home" flag of 1 or 0 (boolean of true/false might work too). From there, try adding that column to the Color Saturation and configure the min/max colors in the Format area.
Yes! I had to do some finagling and build a table that had a single column containing both addresses and an ID so i could join it back to the original table. Then I added the flag of 1 or 0. It's working perfectly. what a great end result to my first post. Thanks so much! attached screenshot for your viewing pleasure.
-Tony
Side note your olympic bid rpt is cool.