11 Replies Latest reply on Sep 3, 2013 9:08 AM by Steve Deckrow

    How to find the minimum value for a particular weekday/hour over a range of weeks

    Steve Deckrow

      I want to create a graph showing the minimum number of calls that happened in a particular weekday/hour combination over a time period of 20 weeks.

       

      The closest I can get is this:

      pic1.png

      So I have what I want, it's just repeated for every week in my date range.  I only want to show one row with the minimum for all weeks.

       

      Here's my formula for Min Trip Count:

      WINDOW_MIN([Trip Count])

      And It's computed using Table(Down).

       

      I've considered just creating a new data source that would mimic what is in the image above (Columns = Weekday/hour, rows = Week number) but then I would lose important fields that I want to use in my filters.

       

      Any suggestions?  Thanks!