Make graphs in Visual Report Builder show results based on order of choices instead of their quantity

  • Profile Image
    Asked on February 08, 2016 at 10:27 AM


    The Visual Report function isn't programmed properly to compare results. 

    When comparing similar questions, the order of the results are listed by quantity. Rather than in order of the choices - Always, Sometimes, Rarely, Never. Depending on how many people select these choices, they will be displayed in different order. Visually, they are uncomparable. And data analysis, or even just logically, it doesn't work. 


    For example, I have 19 publications to compare and use the same graph type for each publication. They are very deceiving, because the bottom line for Always, Sometimes, etc. keeps changing - On one graph, "Always" is first. On the next graph, "Always" is last. The graph is showing the highest ranking first, rather than the order of the choices. 

    Because of this, we cannot use the visual report. We have to export the data and do our own visual report properly.

    Please re-program/fix the Visual Report so that it can be used to compare and analyze data 'visually' properly, it is an essential tool for us. 

    Thank you!

  • Profile Image
    Answered on February 08, 2016 at 12:02 PM

    Hello Presby,

    I am not sure if I have understood your requirement correctly. Do you mean to say that you want the order of all options in the visual should remain same?

    Please be noted that the options in visual report seems to be placed based on which ever option received more answer.


    If Always receives 1, Sometimes receives 2, Rarely receives 3 and Never receives 4 response, the visual report will display the option which ever received more responses. In the above example, the visual report will display options in the following order:

    Never, Rarely, Sometimes, Always, 

    Do get back to us if you always want the order to remain same and we will send a feature request to our back end team.

    We will wait for your response.

    Thank you!

  • Profile Image
    Answered on February 08, 2016 at 12:42 PM

    That is correct. I would like to keep the order to remain the same, so similar responses can be compared visually.

    If JotForm can program the back end so we can select which order we want the answer categories/options to be displayed, that would be ideal. Sometimes we need to see the response categories in order of quantity received (the current default), and sometimes, with comparing multiple questions, we need to keep the categories in the same order between questions so it's easy to see the differences between questions. For example, comparing 10 publications, if the order of the categories stays the same for all 10 graphs - Always, Sometimes, Rarely, Never then we can visually look at all 10 graphs and immediately pick out which one of those 10 publications has the longest top bar ("Always" read the most), and/or easily compare the lengths of all the bottom bars ("Never" read), etc. So we can see the pattern. 

    This means that in bar and line graphs, be able to select the order of the categories;

    and in pie charts, be able to select the colour of the pie slice category. 


  • Profile Image
    Answered on February 08, 2016 at 02:44 PM

    As my colleague has suggested, we will raise this to our developers for a possibility of being implemented, however there are many that have already pre-set their Visual Reports based on the current projection of the charts and making it work in the other way might work for some, like yourself, but would lead to many having graphs working differently, so we can not tell you if this would be implemented or if it is how long will it take for the same.

    If it however gets implemented, you will be notified about the same through this thread.

    In regards to the colors, I have moved that to a new thread where we will be raising that as well. The new thread can be seen here:

  • Profile Image
    Answered on February 08, 2016 at 02:58 PM

    Ok, thank you!