Global Binning

a new binning column can be added using the "add binning" button in the main menu it should be noted that unlike grouping, binning can only be applied to numeric data columns when the "add binning" button is pressed a new binning pop up window interface will open allow users to create a new bin in the selected data table the add binning interface has six distinct panels/components, as highlighted in the above image binning setup metadata this section of the interface contains all the options to change the description as well as some base settings for the new bin this includes binning name this textbox allows users to select the description of this bin, which will be displayed at the top of the new column unbinned label this textbox allows users to select the the description of values which do not fit into any of the user created bins bin type currently only a category bin type is selectable using this option binning column this dropdown list allows users to select a valid, i e numeric data type, column of data in the selected data table unbinned color this dropdown interface sets the color used to describe the unbinned values in the dashboard view histogram of raw data this panel will be populated by the numerical data once a binning column has been selected in the binning setup section (as above) the x axis is automatically set to the lowest (left hand) to the highest (right hand) value in the selected data column and the y axis plots the frequency of the unbinned data this provide an indication to the user the ideal bin for the data histogram of binned data this panel is similar to the above plot, except this panel will plot the raw data in the created bins, and will be updated as new bin are created or removed created bin settings this panel will contain all the bins created by the users or auto generated by amics reports this panel will contain, from left to right, the name (text) of the bin, the color (for dashboard), the lower starting value, and the higher ending value auto binning interface this panel allows users to have amics report generate bins automatically this is done by assigning a start (start) and the ending (max) value, and the number of bins required (ranges numbers) once the "generate" button is pressed, reports will then create equally spaced bins between the start and end value manual binning to manually create bins, users can use the "add bin" to create a new row in the created bin settings panel the user will then need to manually enter the data in the newly created bin