This content has been marked as final.
Show 2 replies

1. Re: Discrete Fixed Calculation Not Averaging Correctly
swaroop.gantela Jul 7, 2016 6:40 PM (in response to Ashwin Chandak)Ashwin,
I think you might need to split it up into two parts.
I created a [ParamAvg]:
{FIXED [Metric],[Date]:AVG([Param Value])}
which produced the average for the metric for each day.
Then I averaged those values:
{ FIXED [Metric]: AVG([ParamAvg])}
The original {FIXED [Metric]:AVG([Param Value])}
was averaging all the points regardless of dates,
but this other version averages the averages at particular dates.
If each date had the same number of measurements,
then I think the results would be the same.
There seems to be a lot of general discussion about
taking averages of averages.

210650dummy data.twbx 70.4 KB


2. Re: Discrete Fixed Calculation Not Averaging Correctly
Ashwin Chandak Jul 8, 2016 4:14 PM (in response to Ashwin Chandak)This approach worked, Thanks!