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
- 101 SQL DataFlows
- 622 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 748 Beast Mode
- 59 App Studio
- 41 Variables
- 686 Automate
- 176 Apps
- 453 APIs & Domo Developer
- 47 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 396 Distribute
- 113 Domo Everywhere
- 276 Scheduled Reports
- 7 Software Integrations
- 125 Manage
- 122 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 109 Community Announcements
- 4.8K Archive