I have created a report that shows the daily flow from the last 14 days. The report combines 3 tables. The first table is the daily flow total. the second is a table of the averages, and the final is supposed to be a table of maximum daily values. However, my maximum value is somethings showing up less than the daily average (in the image, look at the discharge PSI for example). I have played with the aggregation modes and can’t seem to get it right. If I have an aggregation Mode of Maximum and a sample size set to Interval - 24 hour, should i expect the results to be a table maximum values over 24 hour spans? or is it a single data point taken every 24 hours? If anyone knows ow to accomplish what I am trying to do I’d really appreciate it.
