Thx for the additional explanation. So your issue is that you need to capture some values each night such as the # of unassigned tickets.
I suggest making a special table Summary Totals. Create exactly one record in that table and then lock down so no one, even admin cannot add or delete. The Record ID# will be 1.
Make a relationship back to any details tables you like where the reference field on the child side is a formula numeric field with a formula of 1.
Use the relationship to roll up any summary totals you want.
Then create pipeline to run every day to add those summary totals to a daily stats table where you will have a field for the date, and then a bunch of fields for all the values that you want to capture and record each night.
Post ack if you need any help with the pipeline once you have the structure all set up. The fiorst step of the pipeline would be in the Quickbase Chanel to "Lookup Record" and you know the [Record ID#] will be 1.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
