Formula to Count # of records for consecutive business days

Question

We have drivers who must call a system that records their callouts. QB creates a record for each EID callout. I need to create a report that returns the EIDs - that call out 11 business days in a row. . HELP!

------------------------------
Penelope Wilson
------------------------------

markshnier__you · Answer

Do you have a relationship between drivers and callouts?------------------------------Mark Shnier (Your Quickbase Coach)mark.shnier@gmail.com------------------------------

penelopewilson · Answer

Unfortunately, I cannot answer that question. i'm only able to create reports based on the callout table. i thought i could create a report that would allow me to write a formula to summarize the information based on the fields in the report.

------------------------------
Penelope Wilson
------------------------------

markshnier__you · Answer

It might be possible using a Formula Query but a whole lot easier for the person who has Admin access to do, using the summary fields on relationships.

------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------

charlenewilbur1 · Answer

Hi Mark,
I'm racking my brain on how to count consecutive business days.&nbsp; I have a staff table and a days table, where days is a child to staff.&nbsp; I need to know if someone has 15 consecutive business days in the child table.------------------------------Charlene Wilbur------------------------------

chayceduncan · Answer

Easiest method would be to leverage the relationship and figure out the date of 15 business days prior and count how many working days that person is staffed after that date. So basically create a formula in your days table for '15 Day Cutoff' and make it a formula-date that subtracts 15 workdays from Todays date. Then in the relationship - summarize the # of days where that person is staff where the date is on or after that cutoff date. Have a formula then evaluate if that number is equal to 15.&nbsp;------------------------------Chayce Duncan------------------------------

Forum Discussion

Formula to Count # of records for consecutive business days