Forum Discussion
Clustered column average total
this is the chart in the sample
It looks like this is totaling all the data in the table
are you saying, you would like to get these counts for a specific month's worth of data, and compare it with the total for the previous 3 months ?
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