4 Replies Latest reply on Mar 6, 2017 10:22 AM by Seth Wells

    Dot map color based on year purchased

    Seth Wells

      Hi All!

       

      So I have two years of data for a list of customers.  I currently have the color set to year, which shows me 2015 as a blue dot and 2016 as a green dot.  What it does not do is change the dots that were blue to green as customers have purchased in both years (2015&2016).  Is it possible to have only 2 colors and 2016 be the "trump" color?  I have considered making a formula for 2015 only, 2016 only, and 2015&2016...but I do not want to have 3 options on the color legend (even if I set 2016 and 2015&2016 to the same color).

       

       

      I hope that makes sense and I appreciate any help.

       

      Best!

      Seth