Select multiple measures at one time and add to a series
Comments
-
Hey @user09698,
The answer to this question kinda depends on how your data is structured. Is your dataset wide? Structured something like Date, TotalRevenue, TotalCost?
Or is it a tall structure something like this: Date, Measure Type, Value.
If the data is wide, you might want to think about using Magic ETL to pivot your data so that it is stacked taller, it will probably make it easier to do what you're looking for.
In the tall structure, simply add your X-Axis value, your Y-Axis value will be the SUM of your value column, and the series will be the "Measure Type". Then filter your graph on "Measure Type" to only show the few measures you want to see on the card.
Let me know if this makes sense or if you have any additional questions.
**Say 'Thanks' by clicking the thumbs up in the post that helped you.
**Please mark the post that solves your problem as 'Accepted Solution'1
This discussion has been closed.
Categories
- 10.5K All Categories
- 8 Connect
- 918 Connectors
- 250 Workbench
- 472 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 477 Datasets
- 198 Visualize
- 254 Beast Mode
- 2.1K Charting
- 11 Variables
- 17 Automate
- 354 APIs & Domo Developer
- 89 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 247 Distribute
- 63 Domo Everywhere
- 243 Scheduled Reports
- 21 Manage
- 42 Governance & Security
- 176 Product Ideas
- 1.2K Ideas Exchange
- 12 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive