6 Replies Latest reply: Apr 27, 2018 5:18 PM by David P RSS

    Find max count using class function

    David P

      I have a bar graph where my dimension is the following to make 30  min time buckets create_time

      class(create_time,60*30)
      

       

      My measure is

      count(id)
      

       

      Which will give me the totals for each time bucket and it works.

       

      Now I want to display the highest total using the KPI chart type and for the life of me can't figure out the formula I need.