Joined: 06 Oct 2009
|Posted: Fri Jan 13, 2017 1:40 pm Post subject: Pivot table - > Mean (average) for all years
I monitor my working time for some years now. So I have: Subject A, Subject B... and the hours invested accordingly. Also, I compute my time/week.
With Datagraph and particularly the pivot command, I have been able to analyze my data in different ways (very powerful!—great work!). What I miss, should I have not overlooked something:
When I “compute” the % of each Subject/year, I’ll like to have the “great” mean (average) for all the years in the pivot data.
For the practical case, the pivot command gives me the % of time invested for a Subject from 2011 to 2016 for each year, but I’m also interested to know what is the “total” average as if I do not consider the years (e.g.: Total hours Subjet A 2011—>2016/Total hours 2011->2016).
When I do use the “Sum” calculation instead of the “%Col”, I do have indeed the Total hours from 2011—>2016 for each Subject. Something like that, but with the % would be useful.
Again, I’m not a “power user” of Datagraph and I may have missed something very obvious. Sorry then!