Any ideas how to best visualize boolean data?

Andy_A
Andy_A Member
in Cards, Dashboards, Stories

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

Answers

  • ColemenWilson
    ColemenWilson Coach

    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

  • Andy_A
    Andy_A Member

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

    Example.png

  • 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

  • MichelleH
    MichelleH Coach

    @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.

  • Andy_A
    Andy_A Member

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

    image.png

Categories