Forum Discussion
Clustered column average total
Yeah the sample file I sent is only one day's worth of data so I couldn't show a time comparison but yes what I'm aiming for is to use the weighted tenure average measure you saw there as the value for each month (for three months in this case) and have an additional column that has the overall average for those three months. Ideally, I'd want it to be dynamic, so if I added a fourth month the overall average column would automatically update. If it helps, I can add a day of data to my test file from a different month to better show what I'm looking for.
Here's a file with two months showing in the graph. i'd want an "overall" data point in here that would be the average of the two and would change as I added or removed months to the graph.
https://drive.google.com/open?id=1auuiCQ6hmgu1r7c7WZCEw4NV96Ft99TN