Cards, Dashboards, Stories

Cards, Dashboards, Stories

Any ideas how to best visualize boolean data?

I have data where as checkboxes are used to describe an event - on the drill of the event - I am looking to represent visually if the check boxes were utilized… this is how the data is gathered on the collection form… any ideas out there? I would like to use the Checkbox selector chart type - but you cannot populate the checkmarks with it

Checkbox Ecample.png

Welcome!

It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
Sign In

Answers

  • Perhaps a horizontal bar chart to see what the top selected values are for a group of participants? Or do you want to see individual responses?

    If I solved your problem, please select "yes" above

  • I have tried that - it doesn't do the best representation - you end up in a situation like this…

    Example.png
  • You could use an HTML table and then create a beast mode that pulls in an image of a checkmark

    1. CASE WHEN `myBool`
    2. then
    3. CONCAT('<div style="text-align:center"><img height="20px" src="https://banner2.kisspng.com/20180715/klo/kisspng-check-mark-emojipedia-computer-icons-symbol-cek-5b4bdef7a0b662.6919404015316989356583.jpg">','</div>')
    4. end
  • @Andy_A Is your data structured as a single row per response? If so, you may be able to visualize the results in a bar chart better by using an Unpivot/Dynamic Unpivot tile in ETL to create a row per response and checkbox.

  • @MichelleH Yeah - it has been pivoted - so this is what I am trying to best viusalize.

    image.png

Welcome!

It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
Sign In