Forum Discussion

Ttaylor9870's avatar
Ttaylor9870
Helper III
3 years ago

Visualising tick box data

Hey Experts, hope you're well!

 

I have a data source where the title of the column is a question and then the fields are the answer for example...

 

IDTest ATest BTest CTest D
1YesYesNoYes
2YesNoNoYes

 

What would be the best way of visualising which ID has completed which test? This is a large dataset I have so I can't necessarily change the way the data was recorded. The source is tick box data pulled in from Dynamics 365.

 

Any suggestions are greatly appriciated!

 

Many Thanks,

 

Taylor

1 Reply

  • Use Conditional Formatting - Icons.

     

    It is highly advisable to unpivot that source data to bring it into a maintainable format.