Jun 21, 2021 01:03 PM
Hi,
I want to build an Incident Table that tracks incidents. The key fields include:
I have a second Person Hour table that includes key fields:
I need to create a statistical table that pulls and summarizes incidents from the Incident Table by year and category i.e 2020 3 Near Misses, 4 First Aids, 0 Lost Time, 3 Property Damages.
Also pull the person hours from Person Hour table and record by year against the “Site”
I would then create a formula to create a frequency rate for each category of incident. Example (for near misses) (3*200000)/person hours.
I created this perfectly in Quickbase, but I cannot figure out how to do this in Airtable. Any thoughts?
Jun 21, 2021 02:02 PM
Try doing the following:
[Incidents Table]
{Statistic Value}
(or whatever) with this formula:IF(AND({Date}, {Category}), YEAR({Date}) & " - " & {Category})
Link to another record
field called {Statistic Link}
connecting to the [Statistics]
table{Statistic Value}
field into the {Statistic Link}
field (I recommend setting up an Automation to do this for you for all future records).[Statistics Table]
Count
field that counts the number of linked records[Person Hour Table]
I wasn’t exactly sure how statistics for these records would get folded in since it seemed they need to be by site
but incidents
needed to be by type. Best bet would be to follow the same instructions as the Incident
table but connecting to a separate Statistics
table. If you want a singular statistics table then the overall method would need to be adjusted.
Jun 21, 2021 04:29 PM
Thank you, that worked well.