Overview: The campus I work for has a website that students can use to vote how they feel in terms of comfort in a particular room. The options the students have when logged into the site are : Cold, Perfect and Hot. The votes are stored in a large database that contains the time the student voted, the building and room they are in and the type of comfort vote they selected. This gives my team an idea of either overcooling a particular room / building or not cooling enough.
Initial Idea: My idea was to plot the votes that are coming in onto a graph that can be updated as the students vote throughout the day. Cold votes be +1, hot votes be -1 and perfect would be 0, This was to give a general overview of overcooling, undercooling across campus. The problem I ran into is this would never indicate that people are feeling perfect if even one person voted cold/hot.
One option suggested in the comments was to create a bar graph which could keep a sum of the three votes separately, possibly a bar graph per day, then sum the daily count of votes for a monthly bar graph and per year.
Question: I was wondering if there was a way to visualize this in 2D, to quickly get an idea of the comfort of people, whether they are mostly Hot, Cold or Perfect or would I have to keep this in 3D with each dimension pertaining to the vote type?