When I am trying to calculate a percentage over time with the rolling weighted denominator, what is that called? The calculation is basically
Users With WiFi Activity/Users
The line graph that I have is graphed daily on the x axis but at each day, it is only calculating the day of so the percentage is extremely lower, but what I want is on the line graph, on day, the percentage of WiFi users rolling 30 up to that day is this % vs only day x $.
Is that called a moving average?
Also, how is that calculate?
What Data should look like
Day Percentage SUMTotalWiFiUsersRolling SumTotalUsersRolling 8/1 85% 1800 2000 8/1 81% 1700 2100
What Tableau is doing
Day Percentage SUMTotalWiFiUsersDayOnly SumTotalUsersRolling 8/1 30% 600 2000 8/1 35% 735 2100
Hello Ena,
For the precise definition of Moving Average, please refer to Moving average - Wikipedia .
Also, it seems this KB might contain some useful information.
Moving Average Returns Incorrect Values
For more specific advices, please attach a sample workbook or some sample data.
Regards
Lei
