Aggregation functions
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 values on the grid.
To sort the data right on the grid
- Hover over the name of the column/row.
- To sort the records in the rows/columns descending, click the sorting control near the hierarchy caption.
- Click again to sort ascending.
To remove sorting from the data on the grid
- Right-click the member name and cancel sorting via the context menu.
To see the most relevant information first, apply sorting to the values on the grid.
To sort the data right on the grid
- Hover over the name of the column/row.
- To sort the records in the rows/columns descending, click the sorting control near the hierarchy caption.
- Click again to sort ascending.
To remove sorting from the data on the grid
- Right-click the member name and cancel sorting via the context menu.
To see the most relevant information first, apply sorting to the values on the grid.
To sort the data right on the grid
- Hover over the name of the column/row.
- To sort the records in the rows/columns descending, click the sorting control near the hierarchy caption.
- Click again to sort ascending.
To remove sorting from the data on the grid
- Right-click the member name and cancel sorting via the context menu.
Use the filtering feature to focus on the important subsets of your data and display only those rows and columns that satisfy certain conditions.
WebDataRocks supports three types of filters:
- Filtering by member names. Use it to show the values of the specific members.
- Filtering by values. Also known as the Top/Bottom X filter. Use it to keep records within a specified range (with values higher or lower than a specified number).
- A report filter. Use it to apply filtering to the entire report.
To apply a filter by member names
- Open the filtering view by clicking the filtering control (a gear icon) near the hierarchy caption.
- Select the members to be displayed or deselect them to be hidden from the grid.
- If you want to sort the members, choose the alphabetical or reverse alphabetical order. The members of month, weekday, date, time, date and time hierarchies are sorted from the oldest to the newest and vice versa.
- Apply the filter.
To display the members unsorted (i.e., in the same order as they come inside the data source), deactivate both alphabetical and reverse alphabetical controls.
If you have a large list of hierarchy members, use the search option:
- Start typing the member’s caption in the search box.
- Select a check box of the member you are searching for.
- Apply the changes.
To apply a filter by value
- Open the filtering view by clicking the filtering control (a gear icon) near the hierarchy caption.
- Select the Top 10 button.
- Select the Bottom button or the Top button to show the results with the lowest or the highest values correspondingly.
- Enter the number of top or bottom results to show.
- Select the measure on which the filtering is based.
- Apply the changes.
To apply a report filter
- Go to the Fields () tab.
- Drag the hierarchies to the Report Filters area.
- Apply the changes.
The separate tabs of the report filters appear above the grid. Click them and choose the members to display on the grid.
Use the filtering feature to focus on the important subsets of your data and display only those rows and columns that satisfy certain conditions.
WebDataRocks supports three types of filters:
- Filtering by member names. Use it to show the values of the specific members.
- Filtering by values. Also known as the Top/Bottom X filter. Use it to keep records within a specified range (with values higher or lower than a specified number).
- A report filter. Use it to apply filtering to the entire report.
To apply a filter by member names
- Open the filtering view by clicking the filtering control (a gear icon) near the hierarchy caption.
- Select the members to be displayed or deselect them to be hidden from the grid.
- If you want to sort the members, choose the alphabetical or reverse alphabetical order. The members of month, weekday, date, time, date and time hierarchies are sorted from the oldest to the newest and vice versa.
- Apply the filter.
To display the members unsorted (i.e., in the same order as they come inside the data source), deactivate both alphabetical and reverse alphabetical controls.
If you have a large list of hierarchy members, use the search option:
- Start typing the member’s caption in the search box.
- Select a check box of the member you are searching for.
- Apply the changes.
To apply a filter by value
- Open the filtering view by clicking the filtering control (a gear icon) near the hierarchy caption.
- Select the Top 10 button.
- Select the Bottom button or the Top button to show the results with the lowest or the highest values correspondingly.
- Enter the number of top or bottom results to show.
- Select the measure on which the filtering is based.
- Apply the changes.
To apply a report filter
- Go to the Fields () tab.
- Drag the hierarchies to the Report Filters area.
- Apply the changes.
The separate tabs of the report filters appear above the grid. Click them and choose the members to display on the grid.
Use the filtering feature to focus on the important subsets of your data and display only those rows and columns that satisfy certain conditions.
WebDataRocks supports three types of filters:
- Filtering by member names. Use it to show the values of the specific members.
- Filtering by values. Also known as the Top/Bottom X filter. Use it to keep records within a specified range (with values higher or lower than a specified number).
- A report filter. Use it to apply filtering to the entire report.
To apply a filter by member names
- Open the filtering view by clicking the filtering control (a gear icon) near the hierarchy caption.
- Select the members to be displayed or deselect them to be hidden from the grid.
- If you want to sort the members, choose the alphabetical or reverse alphabetical order. The members of month, weekday, date, time, date and time hierarchies are sorted from the oldest to the newest and vice versa.
- Apply the filter.
To display the members unsorted (i.e., in the same order as they come inside the data source), deactivate both alphabetical and reverse alphabetical controls.
If you have a large list of hierarchy members, use the search option:
- Start typing the member’s caption in the search box.
- Select a check box of the member you are searching for.
- Apply the changes.
To apply a filter by value
- Open the filtering view by clicking the filtering control (a gear icon) near the hierarchy caption.
- Select the Top 10 button.
- Select the Bottom button or the Top button to show the results with the lowest or the highest values correspondingly.
- Enter the number of top or bottom results to show.
- Select the measure on which the filtering is based.
- Apply the changes.
To apply a report filter
- Go to the Fields () tab.
- Drag the hierarchies to the Report Filters area.
- Apply the changes.
The separate tabs of the report filters appear above the grid. Click them and choose the members to display on the grid.
WebDataRocks offers customization of the pivot table.
It’s useful if you want to enhance the Look & Feel of your web reporting tool and make the visitors’ interaction with your website a more pleasant experience.
WebDataRocks goes with a set of eight predefined themes:
- Dark
- Default
- Light blue
- Orange
- Teal
- Green
- Striped-Blue
- Striped-Teal
How to change the theme
Step 1. Include the CSS file
All files with themes are located in webdatarocks/theme/ folder. If you don’t specify a theme, a component will use the default one.
Open the file where WebDataRocks is imported (e.g., src/App.vue). Include a CSS file of the theme you like.
In our sample, we’ve chosen the Light blue theme:
import "@webdatarocks/webdatarocks/theme/lightblue/webdatarocks.css";
In case you want to create a custom theme, turn to the detailed tutorial on custom report themes.
Step 2. Update the webpage
Save the applied results and reload the page to see how your pivot table looks now.
Example
Applying the Light blue theme to the pivot table: