How to add grand total in table ?
Hi Guys,
I am looking to add column aggregators as a row in the table.
for example I have a list of sales for each day, I need a row in the end to sum up all the values.
how can I just add this row in domo?
Comments
-
Table cards don't currently "Total", but I believe there is already a request submitted for this functionality to be developed. One of the product managers should be able to confirm that, or you may be able to search/find in the Dojo.
We had a similar quandary though, and we solved it through a DataFlow. By creating one dataset that was "detail" (or maybe it's like a product sub-total) and another data set that was "Summary" (overall total), and then performing a UNION to combine the two subsets. One thing to focus on is making sure you have a field to "sort" by so that in your card output, you can control the location of that summary line. Maybe you add a '0' value to your detail, and a '9' value to your Summary (as an extra column), then when you get to the card builder you can add that special 'sort' column to the Sort Order.
**Say thank you by clicking the 'thumbs up'
**Be sure to select the answer that represents the best solution and mark as "Accept as Solution"0
Categories
- 10.8K All Categories
- 3 Private Company Board
- 1 APAC User Group
- 12 Welcome
- 39 Domo News
- 9.7K Using Domo
- 1.9K Dataflows
- 2.5K Card Building
- 2.2K Ideas Exchange
- 1.2K Connectors
- 343 Workbench
- 260 Domo Best Practices
- 11 Domo Certification
- 465 Domo Developer
- 50 Domo Everywhere
- 106 Apps
- 717 New to Domo
- 85 Dojo
- Domopalooza
- 1.1K 日本支部
- 4 道場-日本支部へようこそ
- 27 お知らせ
- 64 Kowaza
- 299 仲間に相談
- 654 ひらめき共有