Show only Max Values in a chart

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?




Answers

  • MarkSnodgrass
    MarkSnodgrass Portland, Oregon 🔵

    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
    GrantSmith Indiana 🔵

    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
    jaeW_at_Onyx Budapest / Portland, OR 🔵

    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.

Sign In or Register to comment.

Hey, Stranger!

It looks like you're new here. Those who sign in get access to engage with even MORE fire content. To get involved, click one of these buttons!