Citizen Service Requests | Tableau Exchange

Citizen Service Requests

by Tableau


The Tableau Accelerator for Citizen Service Requests (CSR) gives you a jumpstart to data-driven insights into CSR activities. Local and state government agencies can use this Accelerator to better understand the ongoing management of CSRs and where to prioritize their efforts.

Answer key business questions

  • What CSRs are we managing?
  • What type of CSRs are most commonly submitted?
  • Which CSRs should we focus on first?
  • How many CSRs are opened each hour on average?
  • What is the capacity of our departments to answer citizen requests?
  • In which neighborhoods should we prioritize efforts?

Monitor and improve KPIs

  • Open CSRs
  • CSR Opening time
  • Closed CSRs
  • CSR time to close
  • Created CSRs
  • Overdue CSRs
  • Overdue CSRs %

Required attributes

  • CSR Creation Date (date)
  • CSR Closed Date (date)
  • CSR Number (string)
  • CSR Type (string)
  • CSR Priority (string) ← expected values: "Hazardous", "Emergency", "Standard"
  • Is Overdue Flag (string) ← Contains "Y" if the CSR is overdue, "N" else
  • CSR Status (string) ← expected values: "Open", "Closed", "On-hold"
  • Department (string)
  • Sub-Department (string)
  • Country (string)
  • City (string)
  • ZipCode (string)
  • Neighborhood (string)

Tech Specifications

Supported Layouts

Security and Legal