Incident IQ and Looker Studio

I’ve tried to work on something for this multiple times, but we are a large district so the amount of data we pull takes forever to do with the API. If you’re ok with your data being a couple hours behind, and if you’re willing to spend a few bucks, you could write what you need to BigQuery and then connect Looker to that.

OR - if you’re a smaller district, you can write to a Google Sheet and connect Looker to that. (We have too much data for our size to use this method.)
I think several districts on here have done something like this, but @calexander did a pretty nice writeup on it (credit where it’s due!)
 

Both of these can be done with Google Apps Script.

I’ve pitched the request numerous times for read-only access directly to the database for our site, where I can just write a SQL query or something directly in Looker or Power BI to get real-time data.

There’s a couple of idea posts around reporting as well that you could vote on.

 

https://community.incidentiq.com/ideas/save%2Dcustom%2Danalytic%2Dviews%2D525