Help

Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

Covid Interaction Tool

Topic Labels: Views
282 0
cancel
Showing results for 
Search instead for 
Did you mean: 

image

Hey everyone,

To manage a safe workplace in a studio, individuals receive a tracker each day to measure their interactions. The end goal is to assess anyone who has qualified as having “close contact” with another person. These trackers measure interaction events per the above image.

How do I total up multiple records to provide a summary of a device and display it in a concise format?

Yes, I can group by day, by unit, and then filter and sort the data, but the QTY of records I get at the end of a day is quite large, and this will end up being slow and messy. I am really after a quick 40,000’ view summarising any individual that exceeds a total duration of 15minutes of contact… Ideally, I get the totaled summary of the device and put it in a chart, but I’m struggling with getting a quick summary or rollup of the totals at this point.

Open to any suggestions from all the airtable gurus out there!

I really appreciate any help you can provide.

0 Replies 0