Forum Discussion

DeepaPrashant1's avatar
DeepaPrashant1
Qrew Cadet
5 years ago

Report that shows tickets that were Open at the end of every quarter

Hello, I am tracking tickets/cases in this app and created a separate table to be able to compute our fiscal quarters as we have a 4-4-5 quarter...very different from the Calendar qtr. I need a...
reports and charts
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
5 years ago
Are you just looking to capture one number for each Quarter, or a whole breakdown summary by ticket type of open tickets at the end if the quarter.

also is it possible that a ticket could stay open across two quarters or does 99% of the time a ticket gets closed in a much sorter interval than 3 months.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
  • DeepaPrashant1's avatar
    DeepaPrashant1
    Qrew Cadet
    5 years ago
    Hi Mark,

    I am looking for one number...the number of tickets that were open on the last day of each Fiscal quarter. The tickets do span across quarters...some have been open for 3 quarters plus...while most get resolved within the same quarter it was opened.

    Thanks

    ------------------------------
    Deepa Deepa
    ------------------------------
    • MarkShnier__You's avatar
      MarkShnier__You
      Icon for Qrew Legend rankQrew Legend
      5 years ago
      I can't think of an easy way to do this.
      You may have to do the history manually with an <ask the user> report and then set up an Automation to record the value going forward.

      There would need to be a helper table set up with a single record in it related to all tickets and a summary field / relationship  there to count up the open tickets.

      ------------------------------
      Mark Shnier (YQC)
      Quick Base Solution Provider
      Your Quick Base Coach
      http://QuickBaseCoach.com
      mark.shnier@gmail.com
      ------------------------------