Number formatting
You can change the default number formatting of the report. WebDataRocks offers many options for formatting your numerical data such as:
- Align of the text
- Thousand and decimal separators
- Quantity of decimal places
- Currency symbols
- Currency align
- Null (default) value
- Percent formatting
To format numbers
- Go to the Format tab () on the Toolbar.
- Select Format cells.
- Select the value which formatting should be changed.
- Set the properties of formatting.
- Apply the changes.
Use the drill-through feature to see from which non-aggregated records the value in the cell is composed.
To drill through the cell
- Double-click the cell.
- Look through all the information about the cell in the drill-through pop-up window.
To specify what information to show in the drill-through view, open the Field List (
).
Note that if you change the values in the drill-through pop-up window, the changes are not applied to the values from the initial grid. They are “view-only”.
Use the drill-through feature to see from which non-aggregated records the value in the cell is composed.
To drill through the cell
- Double-click the cell.
- Look through all the information about the cell in the drill-through pop-up window.
To specify what information to show in the drill-through view, open the Field List ().
Note that if you change the values in the drill-through pop-up window, the changes are not applied to the values from the initial grid. They are “view-only”.
Use the drill-through feature to see from which non-aggregated records the value in the cell is composed.
To drill through the cell
- Double-click the cell.
- Look through all the information about the cell in the drill-through pop-up window.
To specify what information to show in the drill-through view, open the Field List ().
Note that if you change the values in the drill-through pop-up window, the changes are not applied to the values from the initial grid. They are “view-only”.
Aggregation functions group together values from multiple fields to form a single compound value. To choose an aggregation function for a value, use the Field List.
WebDataRocks Pivot Table offers 17 aggregation functions which you can apply to the measures in your report:
| Name | Value | Description |
|---|---|---|
| Sum | "sum" |
Adds all values in the row/column |
| Count | "count" |
Counts the number of the rows/columns that contain values |
| Distinct Count | "distinctcount" |
Counts the number of the rows/columns that contain unique values |
| Average | "average" |
Returns the average (arithmetic mean) of the values in the row/column |
| Median | "median" |
Returns the median of the values in the row/column |
| Product | "product" |
Multiplies the values in the row/column |
| Min | "min" |
Returns the smallest number in the row/column |
| Max | "max" |
Returns the largest value in the row/column |
| % of Grand Total | "percent" |
Calculates the values distribution across grand totals in the report |
| % of Column | "percentofcolumn" |
Calculates the percent distribution across the columns |
| % of Row | "percentofrow" |
Calculates the percent distribution across the rows |
| Index | "index" |
Calculates the aggregated weighted average to reveal the impact of each value within the context of a dataset |
| Difference | "difference" |
Calculates the difference between two values in the row/column |
| % Difference | "%difference" |
Calculates the difference between two values in the row/column expressed in percentages |
| Population Standard Deviation | "stdevp" |
Calculates population standard deviation of the values in the row/column |
| Sample Standard Deviation | "stdevs" |
Calculates sample standard deviation of the values in the row/column |
| Running Totals | "runningtotals" |
Calculates running totals (cumulative sum) |
Aggregation functions group together values from multiple fields to form a single compound value. To choose an aggregation function for a value, use the Field List.
WebDataRocks Pivot Table offers 17 aggregation functions which you can apply to the measures in your report:
| Name | Value | Description |
|---|---|---|
| Sum | "sum" |
Adds all values in the row/column |
| Count | "count" |
Counts the number of the rows/columns that contain values |
| Distinct Count | "distinctcount" |
Counts the number of the rows/columns that contain unique values |
| Average | "average" |
Returns the average (arithmetic mean) of the values in the row/column |
| Median | "median" |
Returns the median of the values in the row/column |
| Product | "product" |
Multiplies the values in the row/column |
| Min | "min" |
Returns the smallest number in the row/column |
| Max | "max" |
Returns the largest value in the row/column |
| % of Grand Total | "percent" |
Calculates the values distribution across grand totals in the report |
| % of Column | "percentofcolumn" |
Calculates the percent distribution across the columns |
| % of Row | "percentofrow" |
Calculates the percent distribution across the rows |
| Index | "index" |
Calculates the aggregated weighted average to reveal the impact of each value within the context of a dataset |
| Difference | "difference" |
Calculates the difference between two values in the row/column |
| % Difference | "%difference" |
Calculates the difference between two values in the row/column expressed in percentages |
| Population Standard Deviation | "stdevp" |
Calculates population standard deviation of the values in the row/column |
| Sample Standard Deviation | "stdevs" |
Calculates sample standard deviation of the values in the row/column |
| Running Totals | "runningtotals" |
Calculates running totals (cumulative sum) |
Aggregation functions group together values from multiple fields to form a single compound value. To choose an aggregation function for a value, use the Field List.
WebDataRocks Pivot Table offers 17 aggregation functions which you can apply to the measures in your report:
| Name | Value | Description |
|---|---|---|
| Sum | "sum" |
Adds all values in the row/column |
| Count | "count" |
Counts the number of the rows/columns that contain values |
| Distinct Count | "distinctcount" |
Counts the number of the rows/columns that contain unique values |
| Average | "average" |
Returns the average (arithmetic mean) of the values in the row/column |
| Median | "median" |
Returns the median of the values in the row/column |
| Product | "product" |
Multiplies the values in the row/column |
| Min | "min" |
Returns the smallest number in the row/column |
| Max | "max" |
Returns the largest value in the row/column |
| % of Grand Total | "percent" |
Calculates the values distribution across grand totals in the report |
| % of Column | "percentofcolumn" |
Calculates the percent distribution across the columns |
| % of Row | "percentofrow" |
Calculates the percent distribution across the rows |
| Index | "index" |
Calculates the aggregated weighted average to reveal the impact of each value within the context of a dataset |
| Difference | "difference" |
Calculates the difference between two values in the row/column |
| % Difference | "%difference" |
Calculates the difference between two values in the row/column expressed in percentages |
| Population Standard Deviation | "stdevp" |
Calculates population standard deviation of the values in the row/column |
| Sample Standard Deviation | "stdevs" |
Calculates sample standard deviation of the values in the row/column |
| Running Totals | "runningtotals" |
Calculates running totals (cumulative sum) |
To see the most relevant information first, apply sorting to the field members or values on the grid.
Sorting in the pivot table
In the pivot table, you can sort by values and by members.
Sorting by values
To sort by values in the pivot table:
- Hover over a member name or a total cell and click the arrow icon that appears to sort the records descending.
- Click again to sort ascending.
To remove sorting by values:
- Right-click the member name to open the context menu.
- Select the Clear sorting option.
Sorting by members
To sort members on the grid:
- Open the field config pop-up window by clicking the gear icon () near the field caption.
- Choose the ascending or descending order using sorting controls. By default, members are sorted in ascending (AZ) order.
- Click the APPLY button to close the field config pop-up window and see the sorted members on the grid.
To remove sorting by members:
- Open the field config pop-up window by clicking the gear icon () near the field caption.
- Deselect an active sorting control to display the members unsorted (i.e., in the same order as they come inside the data source).
- Сlick the APPLY button to close the field config pop-up window and see the result.
Sorting in the flat view
In the flat view, you can sort by values:
- Hover over a field name and click the arrow icon that appears to sort the records descending.
- Click again to sort ascending.
To see the most relevant information first, apply sorting to the field members or values on the grid.
Sorting in the pivot table
In the pivot table, you can sort by values and by members.
Sorting by values
To sort by values in the pivot table:
- Hover over a member name or a total cell and click the arrow icon that appears to sort the records descending.
- Click again to sort ascending.
To remove sorting by values:
- Right-click the member name to open the context menu.
- Select the Clear sorting option.
Sorting by members
To sort members on the grid:
- Open the field config pop-up window by clicking the gear icon () near the field caption.
- Choose the ascending or descending order using sorting controls. By default, members are sorted in ascending (AZ) order.
- Click the APPLY button to close the field config pop-up window and see the sorted members on the grid.
To remove sorting by members:
- Open the field config pop-up window by clicking the gear icon () near the field caption.
- Deselect an active sorting control to display the members unsorted (i.e., in the same order as they come inside the data source).
- Сlick the APPLY button to close the field config pop-up window and see the result.
Sorting in the flat view
In the flat view, you can sort by values:
- Hover over a field name and click the arrow icon that appears to sort the records descending.
- Click again to sort ascending.
To see the most relevant information first, apply sorting to the field members or values on the grid.
Sorting in the pivot table
In the pivot table, you can sort by values and by members.
Sorting by values
To sort by values in the pivot table:
- Hover over a member name or a total cell and click the arrow icon that appears to sort the records descending.
- Click again to sort ascending.
To remove sorting by values:
- Right-click the member name to open the context menu.
- Select the Clear sorting option.
Sorting by members
To sort members on the grid:
- Open the field config pop-up window by clicking the gear icon () near the field caption.
- Choose the ascending or descending order using sorting controls. By default, members are sorted in ascending (AZ) order.
- Click the APPLY button to close the field config pop-up window and see the sorted members on the grid.
To remove sorting by members:
- Open the field config pop-up window by clicking the gear icon () near the field caption.
- Deselect an active sorting control to display the members unsorted (i.e., in the same order as they come inside the data source).
- Сlick the APPLY button to close the field config pop-up window and see the result.
Sorting in the flat view
In the flat view, you can sort by values:
- Hover over a field name and click the arrow icon that appears to sort the records descending.
- Click again to sort ascending.