visualdatatools.com

[ealvarez]

Hello!

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!