4 Replies Latest reply on Dec 28, 2012 10:49 AM by Dan Gerena

    Computing a MAX for a window of time, without showing the elements of time in the table

    Dan Gerena

      So I've got a transactional detail, and each record has a date field. If the user filters the data for a single month (say January), I want to know for the month of January for instance, what the MAX # of daily transactions was. So if Jan had 3100 transactions, the AVG per day might be 100, but I want to know what the MAX was in that window of time (let's say one day in particular was really busy, thus had 250 transactions the result shown would be "250").

       

      If they change the filter to Q1, and if that day that in question had 250 is still the MAX for the quarter, that's what I want to show...

       

      Any way to accomplish?