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.
“There is a superhero in all of us, we just need the courage to put on the cape.” -Superman1
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.
“There is a superhero in all of us, we just need the courage to put on the cape.” -Superman1
Categories
- 10.6K All Categories
- 8 Connect
- 918 Connectors
- 250 Workbench
- 474 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 478 Datasets
- 214 Visualize
- 259 Beast Mode
- 2.1K Charting
- 12 Variables
- 19 Automate
- 356 APIs & Domo Developer
- 89 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 249 Distribute
- 65 Domo Everywhere
- 243 Scheduled Reports
- 21 Manage
- 42 Governance & Security
- 191 Product Ideas
- 1.2K Ideas Exchange
- 11 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive