Difference between revisions of "Help:Octofy: Data analysis"
m (→Analysis types) |
m (→Exclude blanks) |
||
| (7 intermediate revisions by the same user not shown) | |||
| Line 24: | Line 24: | ||
===Category distribution percentage=== | ===Category distribution percentage=== | ||
[[File:Octofy_Category_distribution_percentage.png|250px|thumb|right|Octofy category percentiles and average]] | [[File:Octofy_Category_distribution_percentage.png|250px|thumb|right|Octofy category percentiles and average]] | ||
:Calculate the number of rows by grouping the category column | :Calculate the number of rows by grouping the category column and the distribution column values and displaying them using a 100% stacked bar chart. | ||
===Scatter plot of count=== | |||
[[File:Octofy_Count_scatter.png|250px|thumb|right|Octofy count scatter analysis]] | |||
:Uses bubbles to represent values for two data columns in a data set. The size of a bubble means the count of the same x and y values. | |||
===Scatter plot of sum=== | |||
[[File:Octofy_Sum_scatter.png|250px|thumb|right|Octofy sum scatter analysis]] | |||
:Uses bubbles to represent values for two data columns in a data set. The size of a bubble represents the sum of the values in the sum column. | |||
---- | ---- | ||
To perform data analysis, select the analysis type, | To perform data analysis, select the analysis type, select the category column, the distribution column, and the sum column according to the analysis type. The results will be displayed in the graph area and the graph data grid. | ||
==Data filter== | ==Data filter== | ||
| Line 32: | Line 41: | ||
The data filters panel is located on the left side of the analysis window. It can be hidden or visible by click on the splitter or from the <strong>View</strong> menu.</br> | The data filters panel is located on the left side of the analysis window. It can be hidden or visible by click on the splitter or from the <strong>View</strong> menu.</br> | ||
The data column tree listed categorical columns as the first level and the category value as the child level.</br> | The data column tree listed categorical columns as the first level and the category value as the child level.</br> | ||
To select a subset of the data, check or uncheck the tree node in the data column tree. | To select a subset of the data, check or uncheck the tree node in the data column tree. You can choose a date range for a DateTime column by right-clicking on the column and selecting an '''Add date range''' from the popup menu, then specify the date range from the '''Date Range Dialog'''. After choosing the filter value, the '''Apply data filter''' button on the top will change to a green color to indicate the change of the filter selection. To apply the change, click on the '''Apply data filter''' button. | ||
==Exclude blanks== | ==Exclude blanks== | ||
You can exclude the blanks by clicking on the '''Exclude blanks of Y-axis''' button. You can also exclude the blanks by using the data filter. | |||
==Sort the results== | ==Sort the results== | ||
Latest revision as of 19:41, 27 November 2021
Analysis types
- Octofy provides the following analysis types. The analysis type can be selected from the menu items in the toolbar or the analysis menu.
Category count
- Group column values and count the number of rows in each group.
Category sum
- Sum the values of the specified column and group them by the values in the category column.
Category distribution count
- Calculate the number of rows by grouping the category column value and the distribution column value.
Category sum
- Sum the values of the specified column and group them by category column and distribution column.
Category percentile are average
- Show the percentiles and the average of the specified column grouped by the category column.
Category distribution percentage
- Calculate the number of rows by grouping the category column and the distribution column values and displaying them using a 100% stacked bar chart.
Scatter plot of count
- Uses bubbles to represent values for two data columns in a data set. The size of a bubble means the count of the same x and y values.
Scatter plot of sum
- Uses bubbles to represent values for two data columns in a data set. The size of a bubble represents the sum of the values in the sum column.
To perform data analysis, select the analysis type, select the category column, the distribution column, and the sum column according to the analysis type. The results will be displayed in the graph area and the graph data grid.
Data filter
The data filters can be used to analyze the subset of the raw data.
The data filters panel is located on the left side of the analysis window. It can be hidden or visible by click on the splitter or from the View menu.
The data column tree listed categorical columns as the first level and the category value as the child level.
To select a subset of the data, check or uncheck the tree node in the data column tree. You can choose a date range for a DateTime column by right-clicking on the column and selecting an Add date range from the popup menu, then specify the date range from the Date Range Dialog. After choosing the filter value, the Apply data filter button on the top will change to a green color to indicate the change of the filter selection. To apply the change, click on the Apply data filter button.
Exclude blanks
You can exclude the blanks by clicking on the Exclude blanks of Y-axis button. You can also exclude the blanks by using the data filter.
Sort the results
You can quickly reorganize categories by sorting them. Use the sort button on the toolbar or the grid title of the chart data grid to sort the data.
- If the analysis type is category count or category sum:
- Click on the Sort button on the toolbar
- Click on the grid title of the chart data grid.
- If the analysis type is category distribution count or category distribution sum:
- Click the distribution item name from the drop-down Sort button on the toolbar.
- Click on the grid title of the chart data grid.
Search the categories
The result categories are searchable. When the number of matching categories is greater than 10, a search text box will be displayed on the toolbar. You can enter what you want to search in the text box, and then press Enter key to start the search. The system will display the number of matches and the current selection index on the right side of the text box. If there are multiple category names that match the search content, the system will display the next and previous buttons on the toolbar so that you can use the buttons to move the selected category to the next or previous matching category. You can also use the F3 key or Enter key to move to the next matching category.
Drill down to the raw data
You can view the raw data of each unit of the graph chart or each cell of the data grid in the raw data grid panel. To view the data, click on the bar unit of the graph chart or click on the data grid cell on the chart data grid.
∗For category percentile analysis, it displays the raw data of the selected category.
When clicking on the category name label on the graphic chart or clicking on a cell of the first column on the chart data grid, the raw data panel will list all related raw data of the selected category.
When clicking on the Grand total label on the bottom left corner of the graph chart, the raw data panel will list all raw data.
You can also click on the Show all raw data menu item in the View menu to view all raw data.
Export the results
The chart data or the selected raw data can be export to a CSV file. To export the data, right-click on the chart data grid or the raw data grid and select Export the chart data or Export the raw data popup menu item. You can also export the data from the menu items in the File menu.
The CSV output format can be changed in the CSV options dialog. To change the CSV output format, click on the Options menu item in the Tools menu.
Feature availability
- Data filter is not available in the Octofy Express edition.
- Raw data view is not available in the Octofy Express edition.
- Date group feature is not available in the Octofy Express edition.
Back to Octofy User Manual
