Aggregating Numbers
Hello, I have a table that has both positive and negative numbers in them (in my ETL process). What I would like to do is leave it this way, and in the visualization, allow when using a chart for the calculation to take place. Is this possible? For example:
Name | Amount
Joe | 10
Mary | -20
This is how the tabular data looks. I want, in the vizualization for the bar chart to automatically calculate it so that when I use the SUM function in the bar chart, it would show -10.
My question is, would this happen?
Comments
-
You can’t change how the data is displayed conditionally based on the type of chart selected. You can graph it as a bar chart and by default it will display the raw data table when the user clicks on the card in the details view.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**2 -
@mroker Agree with@GrantSmith above. You can just aggregate as normal in the card using SUM() and it will take into account negatives. Then in the drill path, your raw data will show the amount as you posted above.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**
2
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 292 Workbench
- 4 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 95 SQL DataFlows
- 603 Datasets
- 2.1K Magic ETL
- 3.7K Visualize
- 2.4K Charting
- 697 Beast Mode
- 43 App Studio
- 39 Variables
- 658 Automate
- 170 Apps
- 441 APIs & Domo Developer
- 42 Workflows
- 5 DomoAI
- 32 Predict
- 12 Jupyter Workspaces
- 20 R & Python Tiles
- 386 Distribute
- 111 Domo Everywhere
- 269 Scheduled Reports
- 6 Software Integrations
- 113 Manage
- 110 Governance & Security
- 8 Domo University
- 30 Product Releases
- Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 98 Community Announcements
- Domo Community Gallery
- 4.8K Archive