8 Replies Latest reply: Jan 25, 2013 2:55 PM by Deepak Vadithala RSS

    Time of Occurance - how can I get the time associated with an item

      Trying to report a peak value AND the time that it occured. 

       

      Data is fairly simple:  Time (Date and Time on the hour) and a counter for an event.    Trying to go through the data by Day (Date) and report the maximum counter AND its associated time. 

       

      provided my date-time value is c_Hourly_Time and the counter is c_Count

       

      I can get the maximum value by building a chart using the Date(c_Hourly) for the chart dimension and using Max(c_Count) as the expression.  What I need now is an expression that will return the c_Hourly value associated with this Max(c_Count) record.