How do I create a table where I can sum groups of values in a table?

I can't seem to figure out a way to sum up pageviews by slug (second column) across multple dates in my data. How do I go about doing this?

With the data below, I want to see a single instance for each slug (second column) with pageviews summed.

Find more posts tagged with

Accepted answers

Like this:

sample heat table.jpg

Compared to this:

sample heat table 2.JPG

All comments

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.

vsolanoy

I've done that, but the Domo table appears to treat it as a separate line item even with the date removed.

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.

Like this:

sample heat table.jpg

Compared to this:

sample heat table 2.JPG

vsolanoy

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

jenglund

is there a way to then filter by the sum? example, if you want to filter pageviews greater than 10000?

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.