Functions Description
...
Data Model Tools
Global Grouping
3 min
a new group column can be added to any valid data table containing at least one column of string data, as grouping can only be processed on string data types to access the grouping interface, click the "add grouping" button in the main menu ribbon this will bring up a new grouping pop up window the grouping interface is made of six main areas the four text interfaces at the top allow users to set base settings grouping name this textbox sets the group's name, which is shown in a new column of data in the main data visualization panel grouping column this dropdown text box allows the user to select any valid string columns in the selected data table this will populate the "unused categories" panel ungrouped label this textbox sets the labels for rows that do not fit into any of the created groups ungrouped color this dropdown interface sets the color used to describe the ungrouped category (defined above) in the dashboard unused categories panel this panel will populate once a grouping column is updated with a selected string column in the data panel items in this panel can be selected and moved into groups at which point they will be removed from this panel used categories this panel will become populated by items which have been moved from the unused categories panel to created groups categories panel this panel will update with all the different categories in the selected column in the grouping column in most cases the count will be "1", unless there are duplicate in case of duplicates, the imported data should be checked for consistency created groups & assigned categories this panel will be populated with groups created by the users, and assigned categories will be located under the group it has been added to historygram of groups this panel will update with a plot with each group shown on the x axis and the y axis showing the total number (counts) of rows which fit into each of the groups
