sum case
Answers
-
I think that you could do this with a Pareto. Place
BrandName
in the Pareto Name andSales
in the Pareto Value. The graph will then tell you the % of total sales.However, if it needs to be a Bar graph, you can use a formula like this:
SUM(
Sales
) / SUM(SUM(Sales
)) FIXED (FILTER DENYBrandName
)Using this formula should let you place the brand name on the x axis and this value in the y axis to create your desired graph.
If you are running into issues, it would be helpful to see what your dataset looks like and how you expect to visualize your data.
“There is a superhero in all of us, we just need the courage to put on the cape.” -Superman1
Categories
- 10.5K All Categories
- 7 Connect
- 917 Connectors
- 250 Workbench
- 464 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 477 Datasets
- 190 Visualize
- 252 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
- 246 Distribute
- 62 Domo Everywhere
- 243 Scheduled Reports
- 21 Manage
- 42 Governance & Security
- 173 Product Ideas
- 1.2K Ideas Exchange
- 12 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive