4 Replies Latest reply on Nov 15, 2014 7:38 AM by Matt Lutton

    How do I create hourly time buckets to graph two different time-related fields on the same axis?

    Sam Padrul

      We are trying to show for a particular day, hour-by-hour, how many tickets were closed and how many were opened in an hour.  Each record has a created_at and resolved_at field.

       

      I have two fields, created_at date, and resolved_at date.  These are both datetime fields.  I want to be able to create on the X axis, 0-23 hour buckets, and do a count of records where created_at and resolved_at fit in these hours.  Ideally, they would be side-by-side bars, so that each hour has one count of records where created_at is in that hour, and another bar doing the same for resolved_at.