1 Reply Latest reply on Nov 10, 2016 10:11 AM by Sherzodbek Ibragimov

    Running AVG for a changing field

    Chrissy Scott

      Hi All,

       

      Is it possible to create a month over month view for a status that changes?

       

      My customer wants to see a monthly running average for how many incident tickets were sent to the vendor. When a ticket is sent to the vendor, the status is changed to "Awaiting Vendor." Then, it comes back to us, and is simply moved to "Resolved" status. So.. how? How on earth do I get a moving calculation for a changing attribute?

       

      Thanks,

      Chrissy