QB Trending Reports

CINDYKRAUSCH
Qrew Member
11 months ago

Hi Mark:

My leadership likes the various QB Leadership Dashboard reporting I have built in QB for the access team. They look at the unassigned Intake/Request queues daily, and regularly look at the various dashboards in the Access QB leadership dashboard (screenshot below).

One of the things that I think would be helpful for my leadership is to get some of this information trending over time.

For example, the unassigned ticket queue that I get in email (and is the same as that top left chart) are snapshots for that particular day – but I am interesting in seeing the daily trends over time like "Cristy Swink BB Multi-Product Create a New Account" had 4 unassigned as of the email this morning, but if I look at yesterday's report there was only 1. This would probably end up being a line chart with a lot of lines, and that's fine. They are not really looking for anything pretty at first – just trying to get a better since of what the trends look like.

My Leadership has have been copying the daily results into excel and creating a chart there, but do you know of a way that you could built that directly into QB? This isn't urgent, but I figured I would ask you to see if there is a better way than what I'm doing now 

Basically, my leadership is wanting a daily trending report. But I'm unsure how to capture that in Quickbase.

Please let me know if you have any questions about what I'm asking, and we can chat live.

Best Regards!

Cindy Krausch

Workforce Operations & Automation - Access, Roles and Config (ARC)

ARC QuickBase Administrator and Data Analytics Developer

CUSTOMER ADVOCACY & SERVICE

125 Corporate Office Dr, Earth City, MO 63045

CK2456@att.com
(636) 667-9681 (cell)

Serve Customers First + Move Faster + Act Boldly + Win As One
- MarkShnier__You
  Qrew Legend
  11 months ago
  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
  ------------------------------
  - CINDYKRAUSCH
    Qrew Member
    11 months ago
    
    I need help in setting up a pipeline to create the daily trending data.
    
    Best Regards!
    
    Cindy Krausch
    
    Workforce Operations & Automation - Access, Roles and Config (ARC)
    
    ARC QuickBase Administrator and Data Analytics Developer
    
    CUSTOMER ADVOCACY & SERVICE
    
    125 Corporate Office Dr, Earth City, MO 63045
    
    CK2456@att.com
    (636) 667-9681 (cell)
    
    Serve Customers First + Move Faster + Act Boldly + Win As One

Forum Discussion