this is part of my api call :
This takes a few seconds to generate. If I use a wider date range, it takes even longer.
What I am using this for is to store the data into a array inside PHP and then work with the array to calculate results. Isn't there a better way that I can code, to get the data more quickly ? Maybe draw from a report where the aggregation is the average of a day instead of hourly ? Then it would only need to retrieve 30 values instead of 1944.