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 graph by fiscal quarter that shows the defect trend. So cases that were in Status 'Open' at the end of every fiscal qtr.  I have the date ticket was opened field 'Activity Logged Date' and a date ticket was closed field 'Closed Date' both of which are related to my Fiscal Calendar table allowing me to pull up the related 'Fiscal Quarter' using those dates. I also have a status field - Open or close.

In summary, I need a graph of tickets that were open at the end of every Fiscal Quarter. How would I achieve this? 

Thanks
Deepa

Thanks


------------------------------
Deepa Deepa
------------------------------
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
        ------------------------------