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 

specified bin width for numerical fields

 
Post new topic   Reply to topic    visualdatatools.com Forum Index -> Getting Started
View previous topic :: View next topic  
Author Message
gadam



Joined: 10 Jan 2016
Posts: 17

PostPosted: Wed Sep 05, 2018 4:48 am    Post subject: specified bin width for numerical fields Reply with quote

In the “pivot” command, if you have a numerical “Rows” field, is it possibile to map rows in a “Specified” way defining non uniform bin widths?
For example: 0-20, 21-50, 51-100 and so on.
Back to top
View user's profile Send private message
Pamela



Joined: 25 Feb 2017
Posts: 35

PostPosted: Wed Sep 05, 2018 9:53 pm    Post subject: Reply with quote

You cannot create non-uniform bins in that way. The program will actually interpret those statements as subtraction. You could use the Pivot if you have a column that identifies the bin, something you could do in the data table.

If you just need a simple non-uniform binning of a column of data, you can do this using a Plot action column in the data table.

Here is a file that demonstrates...
http://www.visualdatatools.com/phpFiles/20180905--CustomBins/BinswithPlotAction.dgraph.zip

It is set to count values but you can also compute averages and percentages.

Is this similar to what you want to do?n If you really need this in a Pivot I can send you an example of that also.
Back to top
View user's profile Send private message
gadam



Joined: 10 Jan 2016
Posts: 17

PostPosted: Fri Sep 07, 2018 3:49 am    Post subject: Reply with quote

Thanks so much.
I take this opportunity to tell you that the tooltip related to "Masked number column" and "Masked text column" is the same as that of "Plot action"
Back to top
View user's profile Send private message
Pamela



Joined: 25 Feb 2017
Posts: 35

PostPosted: Fri Sep 07, 2018 1:35 pm    Post subject: Reply with quote

Thank you for pointing that out Smile
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    visualdatatools.com Forum Index -> Getting Started 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