I don't think we currently have any solutions that allow you get the answer to any question with optimal performance. You could instead push the needed metrics

I don't think we currently have any solutions that allow you get the answer to any question with optimal performance. You could instead push the needed metrics to a stream during your normal processing and aggregate it. This of course duplicates the data as the same information is already available in the tenant databases but is a very reasonable trade-off.