Show only Max Values in a chart

b_rad · 2021-05-19T16:22:29+00:00

There was an error rendering this rich post.

Hi,

I have a line chart like the one below. For each of the trend lines, I want to show the value when its the max value in that trendline.

For example, in the bottom most trendline, I want to show the value only for "2021-02-09" as its the highest value in that trendline.

Is this possible in Domo?

Find more posts tagged with

Accepted answers

All comments

MarkSnodgrass

I'm pretty sure you will need to determine your max value in Magic ETL first by using the group by tile and then join it back to the main dataset so that you have the date that the max value occurred on for that type.

GrantSmith

Hi @b_rad

Are you wanting just the single point displayed or that value for all of your dates?

If you want it for all of your dates you could utilize a window function to calculate the maximum value.

MAX(SUM(`value`)) OVER ()

jaeW_at_Onyx

case when max(amount) = max(max(amount)) over () then 1 else 0 end

would identify the day with the max amount. but i feel like this

would give you the max max on every date. only downside of doing it in ETL is you have to carefully consider, do you want the max for all time or for the range of data you're looking at (which would necessitate

ssecitate the use of windowed functions in Anlayzer, talk to you CSM as it is a feature switch that must be enabled.