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

• Michael Bennett

Hi Anna,

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

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

• Anna H

Hi Michael,

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

• 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