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

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…

  • ggenovese
    ggenovese Contributor

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

    CASE WHEN `myBool`
    then  
    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>')
    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.