sum case
Ana
Member
how categorical variables can have a numerical total of another numerical variable? for example i need sum THE TOAL OF SALE FROM DIFERENT BRANDS / TOTAL OF SALES. the query needs to be smart enough to determinate the different brans AND IN A GRAPHIC THE BRANDS NEED TO BE IN X AXIS AND % IN Y AXIS
0
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
 All Categories
 1.2K Product Ideas
 1.2K Ideas Exchange
 1.4K Connect
 1.1K Connectors
 273 Workbench
 2 Cloud Amplifier
 3 Federated
 2.7K Transform
 78 SQL DataFlows
 527 Datasets
 2.1K Magic ETL
 3K Visualize
 2.2K Charting
 441 Beast Mode
 23 Variables
 514 Automate
 115 Apps
 391 APIs & Domo Developer
 8 Workflows
 26 Predict
 10 Jupyter Workspaces
 16 R & Python Tiles
 332 Distribute
 77 Domo Everywhere
 255 Scheduled Reports
 67 Manage
 67 Governance & Security
 1 Product Release Questions
 Community Forums
 41 Getting Started
 27 Community Member Introductions
 68 Community Announcements
 4.8K Archive