Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Comparing averages to a baseline date

Hello everyone! I want to take some averages that come from a baseline date, then take averages from all other dates and subtract the second one from the first. I have created a formula that is sh...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

az38 

 

This is what I get. Seeing the total row my guess is that somewhere it the total average of all queries while I want the average of each individual Query.

az38's avatar
az38
Icon for Community Champion rankCommunity Champion
6 years ago

Anonymous 

you've got 7.71 when you tried

RETURN
baselineAverage
 
do you have 7.71 if you use
RETURN
baselineAverage - currentAverage

?