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.

  • @Carlos, did ckatzman's reply help answer your question?

  • @ckatzman and @Carlos Yes, grand totals for table cards is on our product road map. Sumo is also another option to DataFlow as Sumo has Grand Totals and SubTotals available. 

This discussion has been closed.

Hey, Stranger!

It looks like you're new here. Those who sign in get access to engage with even MORE fire content. To get involved, click one of these buttons!