Area chart - Y-axis values issue
Hello all Domo users,
I want to represent my data in stocked area chart. Data have structur: month/value/description, I want to sort them by description, like this:
But this, only partly shows what I want to visualize, because the values are counted not by the overall values (whole value of rows) but only for this specific series. This chart should have values like this one below (that is for total rows) and be divided by series in specific description. I don't know how to deal with this.
I know mathematically what eqution is needed to count these value, but i don't know how to do this in Domo. Maybe I should somehow create that this 'description' is subgroup of 'total', so when it will qalculate it will divide the sum of filtred values by all the number of rows and not by filtred.
Any help would be appreciated.
Cheers,
Rafal
Comments
-
Is anyone able to help out with this request?
0 -
Your question is not clear. I am assuming Total is an aggregation of all the series.
If you want to exclude some number of series and show the same total amount, then you cannot do it. You can cluster the series you want to exclude into one and name it something or add them to one of the series you want to include.
Its not clear what you want to do. You might want to edit the question.
Thanks0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 297 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 614 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 729 Beast Mode
- 53 App Studio
- 40 Variables
- 677 Automate
- 173 Apps
- 451 APIs & Domo Developer
- 45 Workflows
- 8 DomoAI
- 34 Predict
- 14 Jupyter Workspaces
- 20 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 121 Manage
- 118 Governance & Security
- Domo Community Gallery
- 32 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive