Dashboard fatigue
Department heads won't log into three systems every morning.
ReportingSolution
One morning email.
Three systems behind it.
Read from several systems, put the records in one shape, count and sort them, and email a digest to the people who need it, with the full list archived.
This solution
Operations reporting
StartsOn a schedule · Weekdays at 7 am
SystemsSentra 311, SentraQueue, PostgreSQL / PostGIS, SFTP server…
Templates3 ready-made flows to start from3
Stored recordsNone: pass-through, in memory only0
Preview any template on your own data before it writes anything.
§ The problem
What it looks like today.
Different shapes
Each system names the same things differently.
Data quality
Nobody notices the bad records until a report is wrong.
§ How it works
How it works: Operations reporting
- 01Read 3 sources311, SentraQueue, database
- 02One shapeMap each to the same fields
- 03CombineSort newest first
- 04CountOpen items by source
- 05EmailDigest to staff
- 06ArchiveJSON on SFTP
§ 01 / Morning digest
Weekdays at 7 am.
Reads 311 requests, SentraQueue lobby visits and database work orders, puts them in one shape, combines and sorts them, emails a count of open items by source, and archives the whole list as JSON on SFTP.
- Combine any number of sources
- Summarize with group-by and totals
- Email with CSV or JSON attached
§ 02 / Weekly summary
Monday's numbers, without asking.
Every Monday at 7 am, last week's closed 311 requests are counted by type and emailed to department heads.
- Filter by date window
- Group by any field
- No report server needed
§ Templates
Ready-made flows for this.
Sentra 311 → SentraQueue → PostgreSQL / PostGIS → SFTP server
Morning operations digest from three systems
Weekdays at 7 am, reads 311 requests, SentraQueue lobby visits and database work orders, puts them in one shape, combines and sorts them, emails a…
Sentra 311Weekly 311 summary for department heads
Every Monday at 7 am, counts last week's closed 311 requests by type and emails the summary.
Data quality alert (sub-flow)
A reusable sub-flow: other flows hand it the records that failed their checks, and it emails the data team a summary with a CSV attached.
§ Systems
Works with
Pre-built connectors used in this solution. Anything else with an API, a database or SFTP works too.
Sentra 311
SentraQueueSee your own systems connected.
We'll set up a workspace with your systems in a sandbox and build your first flow with you.