Discussions

Expand all | Collapse all

Report Formula Question

  • 1.  Report Formula Question

    Posted 17 days ago
    I am working with a report of tickets and I am trying to calculate the number of tickets for each date and the number of tickets completed with issues .  Is there a way to create a field in the table or use a report formula to perform these calculations?

    ------------------------------
    Paul Peterson
    ------------------------------


  • 2.  RE: Report Formula Question

    Posted 17 days ago
    I suggest that you make a formula called [Ticket had Issue count]

    Then make a formula numeric field which calculates to either a 1 or a 0 depending on it if had an issue or not.

    Then use that field in a report.

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



  • 3.  RE: Report Formula Question

    Posted 17 days ago
    Already have that part handled.  What I need to do is calculate the number of tickets per day.

    ------------------------------
    Paul Peterson
    ------------------------------



  • 4.  RE: Report Formula Question

    Posted 17 days ago
    Edited by Mark Shnier (YQC) 17 days ago
    Well, you can either just make a Summary report and group by day or else use excel to load up a table for all the dates for the next 10 years, set the Key field to be the  the Date field and then make a Relationship back to the Tickets table  Then use summary fields to calculate various totals like # of Tickets and Tickets with Issues. ​

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



  • 5.  RE: Report Formula Question

    Posted 17 days ago

    I have done that as well.  I need to do calculations on the results from the summary report data

    I think I found the solution after tweaking the summary report



    ------------------------------
    Paul Peterson
    ------------------------------



  • 6.  RE: Report Formula Question

    Posted 17 days ago
    Is there a way to group by more than 1 column in a Summary Report?

    ------------------------------
    Paul Peterson
    ------------------------------



  • 7.  RE: Report Formula Question

    Posted 17 days ago
    Yes, when you hover to the right of the group by, you can add more group levels with the + plus icon

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