Domo Beast mode row aggregation

Hi Domo-Community!

Hopefully, you can help me!

I have a table like the enclosed one, which is based on a huge file, with the help of ETL I was able to reduce the complexity to this level.

My problem is that I can´t aggregate each day to one row. The aggregation is based on the filter.

So, when I want to see salesfigure for all platforms and all productgroups, there only should be one row with an aggregation of the sales figures 1 to 3.

If I won´t to check platform 1+2 and sales for product group 2+3, there only should be 1 row per day, if anysales happend.

Unfortunately, I was not able to find a good solution for my problem, perhaps someone knows a smart one!

Many thanks!

Nikolaus

Example DOMO question.xlsx

Find more posts tagged with

Accepted answers

RGranada

Ok,

Do you have the "salesfigure" fields calculation set to SUM? Like this:

All the 3 fields need to be set this way.

Let me know if it worked for you.

All comments

RGranada

Hi,

If I correctly understood your problem and you want to aggregate to the level you are describing, you can't have the "platform" or "productgroup" columns directly on the table, because like that you are setting your grouping to date, platform, productgroup. With every different combination of the date, platform, productgroup DOMO will add a new row to the table.

Either find a suitable aggregator for "Platform" and "ProductGroup", or delete them from the table.

If you really need the columns present in the table, what would their value be?

Hope this helps, don't hesitate to ask if you need more insight on this.

nlonkai

Hi,

I actually don´t need "Productgoup" and "Platform" within the table. I tried your suggestion before, but unfortunately I still had the same outcome, but without those 2 columns.