Ignition has some very powerful tools along these lines. You may have seen some of the marketing info about the admin 47 update for groov-AR1 boxes (if you have an Enterprise license).
Here's a little more info on how groov fits in:
Here's info on their reporting options:
The Ignition software is not cheap, but for Systems Integrators, might be a good investment since you can easily bring data to/from a variety of customers/networks (via MQTT).