9 Replies Latest reply on Jan 16, 2019 4:10 AM by Jim Dehner

    How to show maximums value from groups of variables

    Caroline Schauder



      I am mapping senate election data, and I am trying to color each province by the winning party (the one that received the most votes). I created a calculated value to determine the max votes, and I am able to color the provinces by the maximum number of votes. However, I want to color it by the party that had the maximum number of votes for each province (for example, all provinces where Pais 1 won would be blue, etc). How can I link output the party instead of the number of votes? I attached my workbook below for reference (I apologize, some of the words are in Spanish but as a quick reference, Distrito = Province, Partido= political party, Votos = votes)


      Thank you!