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
- All Categories
- 1.2K Product Ideas
- 1.2K Ideas Exchange
- 1.3K Connect
- 1K Connectors
- 267 Workbench
- Cloud Amplifier
- 3 Federated
- 2.5K Transform
- 78 SQL DataFlows
- 524 Datasets
- 1.9K Magic ETL
- 2.9K Visualize
- 2.2K Charting
- 433 Beast Mode
- 22 Variables
- 507 Automate
- 113 Apps
- 386 APIs & Domo Developer
- 8 Workflows
- 25 Predict
- 9 Jupyter Workspaces
- 16 R & Python Tiles
- 331 Distribute
- 76 Domo Everywhere
- 255 Scheduled Reports
- 65 Manage
- 65 Governance & Security
- 1 Product Release Questions
- Community Forums
- 39 Getting Started
- 25 Community Member Introductions
- 67 Community Announcements
- 4.8K Archive