5.10.2. Aggregate & Histogram (clip0243 action)

<< Click to Display Table of Contents >>

Navigation:  5. Detailed description of the Actions > 5.10. R Visualization >

5.10.2. Aggregate & Histogram (clip0243 action)


Icon: ANATEL~3_img746  


Function: R_AggAndHisto
Property window:




Short description:

Aggregate a table and display the variables content in a Histogram chart.


Long Description:

Since the aggregation is performed by the R engine, it’s limited to tables that fits into RAM (and it’s quite slow). To display histogram on unlimited size tables, use the ANATEL~3_img740 Histogram Action from the previous section.



Variable list: Select the variables on which to compute the histograms

Bar Color for Nominal Variables: select the color for categorical variables

Bar Color for Numerical Variables: select the color for value variables

One Window per Plot: put the histogram of each variable in a separate plot

Chart orientiation horizontal: by default, plots are vertical histograms

Number of charts per line: set how many charts are on the same line, if you have not chosen to make one window per plot.

Set chart margin in general: set the margin between charts of all are on a single window

Set Chart Margin for Categorical Labels: set the margin in the categories axis

Number of categories: set the number of bins in the histogram

Font Size: set the font size (default is 0.8)

Save Images as PNG: choose whether to save the output as a PNG file or not

PNG Directory: choose where to save the file (by default in the active directory “:/”)



Using the Census Database, we want to make histograms of wage per hour, education level, and age. We will first set to “FLOAT” the type of data for age and Wage per Hour (the type of variable is automatically sent to R, and treated as such).


Then, simply select the variables you wish to generate a histogram for (in our example, age, education, and wage per hour). As “age” and “wage per hour” are both numeric, R will automatically generate a histogram, while we will get a count plot for each category of the “education” variable. As in the previous example, we kept all the plots in a single window. By selecting the option “One Window per Plot” this woud have create a new window for each plot (three separate plots)