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.
1
Categories
- All Categories
- 2K Product Ideas
- 2K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 311 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 3.8K Transform
- 656 Datasets
- 115 SQL DataFlows
- 2.2K Magic ETL
- 811 Beast Mode
- 3.3K Visualize
- 2.5K Charting
- 80 App Studio
- 45 Variables
- 771 Automate
- 190 Apps
- 481 APIs & Domo Developer
- 77 Workflows
- 23 Code Engine
- 36 AI and Machine Learning
- 19 AI Chat
- AI Playground
- AI Projects and Models
- 17 Jupyter Workspaces
- 410 Distribute
- 120 Domo Everywhere
- 280 Scheduled Reports
- 10 Software Integrations
- 142 Manage
- 138 Governance & Security
- 8 Domo Community Gallery
- 48 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 114 Community Announcements
- 4.8K Archive