Forum Discussion

IvanWeiss's avatar
IvanWeiss
Qrew Captain
7 years ago

Summary Table not Calculating Averages, and trying to color fields in the table

So two things I am struggling with.  First one is the more critical item which is pulling data through.  I made a summary table so that I can create data on a report to put on my dashboard pages.  I h...
APIs and custom code
Formulas and functions
Relationships
ArchiveUser's avatar
ArchiveUser
Qrew Captain
7 years ago
Ivan - Based on the information you've provided (and without me knowing a lot about your end goal) it sounds like you may need to revisit your approach. I'm guessing that a single Service Call could have many Punch List Items. If this is indeed the case, you would need to setup a relationship between these two tables and then do a Summary field from Punch List Items to Service Calls. You can then build a Summary Report on the Service Calls table to see the information you're looking for.
IvanWeiss's avatar
IvanWeiss
Qrew Captain
7 years ago
So actually I think maybe I confused you on that.  Punch List Items and Service Calls are COMPLETELY independent of each other.

I am trying to calculate an average of each for reporting purposes for every open item.

So what is the average age of all of the open punch list items
What is the average age of all open Service Calls

This way my team can see some metrics on how they are doing and be encouraged to get those numbers down