MAX on dimensions on card build

elvarliiv

Hey.

I am building a card and I am aggregating data over time (ie last X days). I have this issue that I want to use MAX aggregation on dimension field, but only aggregation DOMO allows for this type fields is count. Is there a way to use MAX on these fields?

Example

Fields: Date, Id, name, spend

Row1: 2022-01-01, 1, test1, 10

Row2: 2022-01-02, 1, null, 12

Id and name are dimensions, spend is measure. Lets say I choose the time period Jan 2022

The result I expect is:

Row1: 1, test1, 22

but right now I get

Row1: 1, test1, 10

Row2: 1, null, 12

In SQL it would look like:

select id, max(name), sum(spend) from table1 where Date between '2022-01-01' and '2022-01-31' group by 1

Thx,

Elvar

GrantSmith

Hi @elvarliiv

have you tried using a beast mode to take the MAX of your dimension field?

elvarliiv

beast mode does the trick, thx

GrantSmith

Great to hear @elvarliiv . If you could mark my answers as accepted so others could more easily find it I'd appreciate it.