How do I create a table where I can sum groups of values in a table?
Best Answer
-
Like this:
Compared to this:
Aaron
MajorDomo @ Merit Medical
**Say "Thanks" by clicking the heart in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"0
Answers
-
I think you have to remove the date column. The aggregation occurrs across the lowest level of detail. Without the date column, the lowest level of detail is custom dimension 22 x custom dimension 26 in this view.
Aaron
MajorDomo @ Merit Medical
**Say "Thanks" by clicking the heart in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"0 -
I've done that, but the Domo table appears to treat it as a separate line item even with the date removed.
0 -
The only additional thing I can think of is to make sure the numerical column is actually summed, not just displayed, and that the other custom dimension(s) isn't causing the detail to split out also.
Aaron
MajorDomo @ Merit Medical
**Say "Thanks" by clicking the heart in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"0 -
Like this:
Compared to this:
Aaron
MajorDomo @ Merit Medical
**Say "Thanks" by clicking the heart in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"0 -
Thank you - that worked perfectly. I did a slight variation - I couldn't set Value1 to SUM and get it to work, but I used BeastMode to do a sum of Pageviews, now the grouping seems to work perfectly!
Victor
0 -
is there a way to then filter by the sum? example, if you want to filter pageviews greater than 10000?
0 -
At present you can't filter on aggregations, but Domo's aware of that need and are working on it.
There might be a way to use beast modes though. A conditional in a case statement like this:
CASE
WHEN sum(`value`) > 10000
THEN 'Yes'
ELSE 'No'
END
Use a filter like that, select just the 'Yes' values. If it works depends on whether Domo does the sum on the individual raw data row or on the grouped row.
That might not work, but it's worth a shot.
Aaron
MajorDomo @ Merit Medical
**Say "Thanks" by clicking the heart in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"0
Categories
- 10.5K All Categories
- 5 Connect
- 915 Connectors
- 250 Workbench
- 459 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 476 Datasets
- 185 Visualize
- 250 Beast Mode
- 2.1K Charting
- 11 Variables
- 16 Automate
- 354 APIs & Domo Developer
- 88 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 245 Distribute
- 62 Domo Everywhere
- 242 Scheduled Reports
- 20 Manage
- 41 Governance & Security
- 170 Product Ideas
- 1.2K Ideas Exchange
- 10 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive