Transforming Support Staff Name Column
Hello, ETL question.
For context, I am creating a dashboard for self-service reports on customer satisfaction surveys.
Typically I would create a drop down filter card to 'Filter by: Owner', but in this case the owner
column contains multiple names:
IE:
Owner
Joe Smith, Bob Smith
Cate Smith
Cindy Smith, Sam Smith
Does anyone have suggestions on how I can transform this column(s) so that it is possible to filter the dashboard by any one individual's name?
Thank you
Best Answer
-
Hi @MycahD - You are on the right track. Do you have a max of 2 support staff per survey? If not, make sure to include up to the max in your split columns.
The next step would be to leverage the DDX brick "Searchable Filter App (Multiple Columns)"
You can follow along with @BenSchein as he walks through how to set up the app on a live stream here:
If you include the columns Support Staff 1, Support Staff 2, 3, … in your search config dataset, then you will be able to search for any single name.
The other option would be to unpivot your data so that you get multiple lines per survey, but a single line per survey and support staff. By doing this you would need to be careful about how you use the dataset because you will possibly be counting surveys multiple times when they have multiple owners.
1
Answers
-
Hi @MycahD - You are on the right track. Do you have a max of 2 support staff per survey? If not, make sure to include up to the max in your split columns.
The next step would be to leverage the DDX brick "Searchable Filter App (Multiple Columns)"
You can follow along with @BenSchein as he walks through how to set up the app on a live stream here:
If you include the columns Support Staff 1, Support Staff 2, 3, … in your search config dataset, then you will be able to search for any single name.
The other option would be to unpivot your data so that you get multiple lines per survey, but a single line per survey and support staff. By doing this you would need to be careful about how you use the dataset because you will possibly be counting surveys multiple times when they have multiple owners.
1
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.6K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 102 SQL DataFlows
- 626 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 753 Beast Mode
- 61 App Studio
- 41 Variables
- 692 Automate
- 177 Apps
- 456 APIs & Domo Developer
- 49 Workflows
- 10 DomoAI
- 38 Predict
- 16 Jupyter Workspaces
- 22 R & Python Tiles
- 398 Distribute
- 115 Domo Everywhere
- 276 Scheduled Reports
- 7 Software Integrations
- 130 Manage
- 127 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 11 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 110 Community Announcements
- 4.8K Archive