visualdatatools.com Forum Index visualdatatools.com
Discussion for DataTank and DataGraph
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Pivot table - > Mean (average) for all years

 
Post new topic   Reply to topic    visualdatatools.com Forum Index -> Feature Request
View previous topic :: View next topic  
Author Message
ealvarez



Joined: 06 Oct 2009
Posts: 22
Location: Québec

PostPosted: Fri Jan 13, 2017 1:40 pm    Post subject: Pivot table - > Mean (average) for all years Reply with quote

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!
Back to top
View user's profile Send private message Visit poster's website
Display posts from previous:   
Post new topic   Reply to topic    visualdatatools.com Forum Index -> Feature Request All times are GMT - 3 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group