0

Likert Scale in Graph

Hi, 

I would like to visualize results from a question asked using the Likert scale (i.e. do you agree with the following statement?). The data is reflected the following way in the data source: 

A possible visualization could be the following way: 

Can you please explain  how to this with a Klip and / or refer to a learning base. 

 

Thank you

3 comments

  • 0
    Avatar
    Michael Bennett

    Hi Anna,

    I hope your week is going well so far! There are a few easy steps to creating this bar chart:

    1. Add column 2 to your X-axis component
    2. Add column 1 to your Series Component
    3. Go to your X-axis component "Properties" tab, and select "Group Repeating Labels" to group the results.

    We cover some of these techniques in this video here.

    I hope this helps and if you're still encountering issues please reach out to support@klipfolio.com and we'd be happy to take a closer look and walk you through the steps in more detail. Make sure support access is enabled.

    Cheers,

    Michael

  • 0
    Avatar
    Anna H

    Hi Michael, 

    Thank you very much for your quick reply. The explanations were helpful. 

    I now tried to have two data sets in the same graph but, unfortuantely, it showed the same results for both data sets. Can you please explain how to visualize several data sets in one graph. 

     

    Further, can you please provide a reference to a video / online resource on how to do a multi-dimensional graph. For example have the date / time series on the x-axis and the likert scale for each of the data points? 

    Thank you and best regards,

    Anna

  • 0
    Avatar
    Keely Davison

    Hi Anna,

    There are a few options here.  If you only have 2 columns of data the easiest might be using ARRAY as follows.

    x-axis :  ARRAY(@statement1, @statement2)

    series one: ARRAY(@statement1, blank( countall(@statement2)))

    series two; ARRAY( blank(countall(@statement1)), @statement2)

    On the x-axis make sure to "Group repeating labels"

     

    IF you are going to have several columns I would probably recommend using our LOOKUP,  GROUP and GROUPBY/COUNTDISTINCT functions.

    This would work something like

    x-axis : array with the list of values to be on the x-axis or GROUP(@statement1)

    series 1: LOOKUP(&x-axis, GROUP(@statement1), COUNTDISTINCT(@statement1))

    series 2: LOOKUP(&x-axis, GROUP(@statement2), COUNTDISTINCT(@statement2))

    end so on. 

    Here are some links you may find useful

    General information on building bar/line charts

    https://support.klipfolio.com/hc/en-us/articles/215545848-How-to-build-Bar-Line-Chart-components

    More specific on LOOKUP, GROUP, GROUPBY/COUNTDISTINCT

    https://support.klipfolio.com/hc/en-us/articles/216182777-LOOKUP-video-

    https://support.klipfolio.com/hc/en-us/articles/215547998-GROUP-GROUPBY-and-COUNTDISTINCT-video-

    Information on using result references in formulas

    https://support.klipfolio.com/hc/en-us/articles/115000181613-Writing-formulas-using-results-references

     

    Keely

     

Please sign in to leave a comment.