Calculating max of a category using FIXED

rahulrampa
rahulrampa Member
in Beast Mode

If I have the first three columns of the data(model, variant names and total clicks) is it possible to generate a calculated field which shows the highest click value in a given Model?

For example, Model A has 3 variants and the highest amount of clicks among the 3 variants is 33, so the 'Max clicks' column should be populated with 33.

The understanding data is at a url level so the total clicks is a calculated field with the formula count(`url`). My end goal by doing this is to highlight the row of the variant with the highest clicks

Model

variant names

Total Clicks

Max clicks

A

Variant-1

33

33

A

Variant-2

16

33

A

Variant-3

31

33

B

Variant-1

19

23

B

Variant-2

23

23

B

Variant-3

11

23

Tagged:

Best Answer

  • ColemenWilson
    ColemenWilson Coach
    edited June 2024 Answer ✓

    MAX(Total Clicks) OVER( PARTITION BY Model)

    Screenshot 2024-06-06 at 12.48.06 PM.png

    Then create a filter to leave only max rows:

    Screenshot 2024-06-06 at 12.49.56 PM.png

    If I solved your problem, please select "yes" above

Answers

  • ColemenWilson
    ColemenWilson Coach
    edited June 2024 Answer ✓

    MAX(Total Clicks) OVER( PARTITION BY Model)

    Screenshot 2024-06-06 at 12.48.06 PM.png

    Then create a filter to leave only max rows:

    Screenshot 2024-06-06 at 12.49.56 PM.png

    If I solved your problem, please select "yes" above

  • rahulrampa
    rahulrampa Member

    Apologies not adding this in the question, but I don't think I have window functions enabled in our Domo instance

  • ColemenWilson
    ColemenWilson Coach

    I don't believe you need them enabled, do you mean Nested Beast Modes? For those you can reach out to your CSM to have them enabled.

    If I solved your problem, please select "yes" above

Categories