Hello,
My name is Behnam, and I am the APAC QA/QC Manager responsible for quality across APAC projects. I am reaching out to explore the possibility of fully automating the process of displaying observations, inspections, and punch lists in QuickSight using a traffic light system to improve visibility and streamline project tracking.
As I understand it, data related to these items is currently synced from Procore to QuickSight likely every 24 hours. The objective is to have QuickSight automatically categorize these items based on their created date and status, so stakeholders can quickly assess outstanding issues:
• Black Light – If the status is Closed
• Green Light – If the status is not Closed (e.g., Open, Under Review, etc.) and the created date is less than a month
• Yellow Light – If the status is not Closed and the created date is between one and two months
• Red Light – If the status is not Closed and the created date exceeds two months
I’d like this to be fully automated, ensuring stakeholders can simply open the dashboard via a shared link, apply relevant filters, and instantly see the traffic light system for their respective projects.
Before implementing this, I would also appreciate the opportunity to discuss the details with someone from the QuickSight team to ensure feasibility and alignment.
Please let me know if you can arrange a meeting or direct me to the appropriate contact.
Looking forward to your response.
Best regards,
Behnam