Any ideas how to best visualize boolean data?

Andy_A

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

ColemenWilson

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?

Andy_A

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

ggenovese

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

@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

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