Total Column in a different column
Good Morning
I have a column let's say (look below) Is there a way to create another column with the total sum of that column? So it reads a new column that says total and it should be the same number? Thanks!
category category total
A 1 A 1 6
A 0 A 0 6
A 2 A 2 6
A 3 A 3 6
A 0 A 0 6
B 0 B 0 2
B 2 B 2 2
TOTAL 8
Best Answer
-
sounds like you're trying to do a category subtotal.
you can implement that with a windowed function
sum(sum(amount)) over (partition by category)
you need to have the feature switch enabled. talk to your csm.
If you've never worked with them before they can be super powerful but also have some pretty stringent caveats.
https://www.youtube.com/watch?v=eifSYZIcPzg&list=PLUy_qbtzH0S4CkHBUvpOVpLNJluk6upOn&index=5&t=466s
Jae Wilson
Check out my 🎥 Domo Training YouTube Channel 👨💻
**Say "Thanks" by clicking the ❤️ in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"1
Answers
-
sounds like you're trying to do a category subtotal.
you can implement that with a windowed function
sum(sum(amount)) over (partition by category)
you need to have the feature switch enabled. talk to your csm.
If you've never worked with them before they can be super powerful but also have some pretty stringent caveats.
https://www.youtube.com/watch?v=eifSYZIcPzg&list=PLUy_qbtzH0S4CkHBUvpOVpLNJluk6upOn&index=5&t=466s
Jae Wilson
Check out my 🎥 Domo Training YouTube Channel 👨💻
**Say "Thanks" by clicking the ❤️ in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"1 -
It worked perfectly! Thanks!
0
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
- 659 Datasets
- 116 SQL DataFlows
- 2.2K Magic ETL
- 815 Beast Mode
- 3.3K Visualize
- 2.5K Charting
- 82 App Studio
- 45 Variables
- 775 Automate
- 190 Apps
- 481 APIs & Domo Developer
- 81 Workflows
- 23 Code Engine
- 40 AI and Machine Learning
- 20 AI Chat
- 1 AI Playground
- 1 AI Projects and Models
- 18 Jupyter Workspaces
- 410 Distribute
- 120 Domo Everywhere
- 280 Scheduled Reports
- 10 Software Integrations
- 144 Manage
- 140 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