MAX on dimensions on card build

elvarliiv
elvarliiv
edited February 2022 in Charting

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

Best Answer

  • GrantSmith
    GrantSmith Coach
    Answer ✓

    Hi @elvarliiv

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

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**

Answers

  • GrantSmith
    GrantSmith Coach
    Answer ✓

    Hi @elvarliiv

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

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**
  • elvarliiv
    elvarliiv

    beast mode does the trick, thx

  • GrantSmith
    GrantSmith Coach

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

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**

Categories