Table from Multiple Datasets
I want to create a table that will pull data from multiple datasets. For example: each dataset has user name and data fields.
1st dataset has: username, date, ticket type, count by type.
2nd dataset has: username, date, inbound calls, outbound calls, productivity.
3rd dataset has: username, date, net collected, potential revenue.
I want to create a dataset that has username, date, count by ticket type, total inbound calls, total outbound calls, total productivity, total net collected, total potential revenue. (So these would be the headers and then each agent would appear once with their total for each column.)
I included a picture of sort of what I want to achieve... (headers are different in this example)
- 10.7K All Categories
- 13 Getting Started in the Community
- 37 Beastmode & Analytics
- 2.1K Data Platform & Data Science
- 59 Domo Everywhere
- 2.7K Charting
- 2.5K Ideas Exchange
- 1.3K Connectors
- 362 Workbench
- 303 Use Cases & Best Practices
- 500 APIs
- 118 Apps
- 48 News
- 753 Onboarding
- 1.2K 日本支部
- Private Company Board