Results -9 to 0 of 364

Threaded View

  1. #11
    Player
    ty_taurus's Avatar
    Join Date
    Sep 2013
    Location
    Limsa Lominsa
    Posts
    3,647
    Character
    Noah Orih
    World
    Faerie
    Main Class
    Sage Lv 90
    Quote Originally Posted by ty_taurus View Post
    I tried to include graphs like that, but there isn’t a good way to do it on google sheets. The best option would look misleading, as instead of showing how many votes were a 1, a 2 a 3, etc… it would show you how many votes were between 0.0 and 1.0, between 1.1 and 2.0, etc. So I decided against including that.

    Instead, if you return to the actual form for each job, you should have the option to view results, and not only will you be able to see those graphs the way you describe (love that google forms displays info that way but google sheets doesn’t have a similar option), but you’ll also be able to see what percentage of players selected which categories to see more of/less of.

    Those results can only be viewed one at a time, it doesn’t show the average, median, and mode values for the 1-10 ranges, and reading through the written feedback is less clear. So the spreadsheets still help communicate that info.
    To give an example of just how unhelpful my options are on Google Sheets for displaying those graphs, this was the best I could manage to create to showcase how each job is scored:



    It's not terrible, really, but you can only see the count of how many votes are for each value by mousing-over each individual column. Now compare that to the forms results tab:



    Returning to the google forms for that info is just better.
    (2)
    Last edited by ty_taurus; 04-23-2023 at 05:39 AM.