Calculating max of a category using FIXED

rahulrampa · June 6

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

ColemenWilson · June 6

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

ColemenWilson · June 6

MAX(Total Clicks) OVER( PARTITION BY Model)

Then create a filter to leave only max rows:

rahulrampa · June 6

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

ColemenWilson · June 6

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.

Calculating max of a category using FIXED

Best Answer

Answers

Categories