multiple Groups shown in just one column
Hello DOMO -
Good Day!
I am using the Data governance dataset that has the users and groups.
what we wanted to show is the pages/dashboard and then all the groups that can view it.
currently, I can show the different pages and the different groups in different columns.
just wanted to know if we can show all the different groups that we have in just one column?
Thanks!
Best Answer
-
Yep then Group Concat is the way to go! See a basic MagicETL setup below (just swap `state` for `Page` and `Sales Rep` for `Group`:
If you are using MySQL dataflow instead, use GROUP_CONCAT() and be sure to have a GROUP BY `page` in your query.
If I solved your problem, please select "yes" above
0
Answers
-
I am not sure exactly the format you are hoping to have, but if you could provide a screenshot or a data table from excel or something showing the format I could help out.
I think maybe you are looking for a concatentation into a single column, which you could accomplish using GROUP_CONCAT()You could do this in a MySQL dataflow or using the Group by tile in Magic ETL
If I solved your problem, please select "yes" above
1 -
basically, this is what we want to see»>
0 -
Yep then Group Concat is the way to go! See a basic MagicETL setup below (just swap `state` for `Page` and `Sales Rep` for `Group`:
If you are using MySQL dataflow instead, use GROUP_CONCAT() and be sure to have a GROUP BY `page` in your query.
If I solved your problem, please select "yes" above
0
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