Yes/No dimension across multiple fields

Reply
Highlighted
Yellow Belt

Yes/No dimension across multiple fields

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

 

 YesNo N/A
Column 1541
Column 2910
Column 3550
Column 4190
Column 5280
Column 6442
Highlighted
Black Belt

Re: Yes/No dimension across multiple fields

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#Coll...

 




**Make sure to like any users posts that helped you and accept the ones who solved your issue.**
Highlighted
Yellow Belt

Re: Yes/No dimension across multiple fields

Thanks @MarkSnodgrass !

 

I haven't had time to get back to this but I am anxious to put this information to use. I appreciate your having taken the time to reply. I will be sure to update this thread with my experience.

Announcements
What is your Dojo rank and what badges have you earned? How am I doing? Get a refresher on how to up your rank and collect badges in the Dojo here.