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...
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 |
Comments
-
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.
**Check out my Domo Tips & Tricks Videos
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.0 -
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.
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.6K Connect
- 1.2K Connectors
- 302 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 104 SQL DataFlows
- 633 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 760 Beast Mode
- 62 App Studio
- 42 Variables
- 699 Automate
- 181 Apps
- 457 APIs & Domo Developer
- 51 Workflows
- 10 DomoAI
- 38 Predict
- 16 Jupyter Workspaces
- 22 R & Python Tiles
- 401 Distribute
- 116 Domo Everywhere
- 277 Scheduled Reports
- 8 Software Integrations
- 130 Manage
- 127 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 111 Community Announcements
- 4.8K Archive