I would like to get the running average of the past 7 days. As an example,
the value 20 (highlighted in yellow in the first image) is calculated by doing the average of the previous 7 days (highlighted in yellow in the second image).
the value 18.57 is calculated by doing the average of the previous 7 days.
Thank you
I tried this in Tableau, but my calculations on My avg. of the last 7 days are not correct. You can see that they do not match (highlighted in yellow in the below image)
Also, I would like to replicate this solution for the standard deviation.
Thank you in advance for all your help,
like this
Jim
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
