Yes/No dimension across multiple fields

PhilD

I have a SharePoint list that contains over 50 choice columns, all with their possible response limited to [ 'Yes', 'No', 'N/A' ]. Is there a way to use the [ 'Yes', 'No', 'N/A' ] dimension in a card that shows a bunch of these columns at once without having to reference each separate column's value individually? 

 

Hoping for output something like this...

 

	Yes	No	N/A
Column 1	5	4	1
Column 2	9	1	0
Column 3	5	5	0
Column 4	1	9	0
Column 5	2	8	0
Column 6	4	4	2

MarkSnodgrass

It sounds like you need to pivot your data, in which case creating an ETL and using the collapse columns tile should get you what you want. Here is the KB article that discusses it.

https://knowledge.domo.com/Prepare/Magic_Transforms/ETL_DataFlows/02ETL_Actions%3A_Edit_Columns#Collapse_Columns