In the interactivity features Go-to-URL, Custom events and Custom tooltip, you can include aggregated results from any columns of the dataset(s) used in a widget, even if these columns are not directly used in the widget's slots. The available aggregation types will depend on the column's data type. All filters and grouping on the widget will directly influence the result of the configuration
By using a simple mock dataset (included below), we'll explain the different aggregation types per column, and their expected result. Next to that, we use a custom tooltip configuration in two widgets to show how grouping and filters influence the result of the configuration.
Let's first focus on a very minimalistic example orders dataset, which contains one row per order (i.e. a total of 10 orders have been placed):
Each of the examples below contain two widgets: the first column chart does not group on anything, and the second column chart groups on the "destination country" column. When hovering over the different column elements in these widgets, the tooltip will show you examples of what to expect when setting up a specific aggregation type on a specific column type. You can select one or multiple countries by using the second widget's interactivity: this will influence the first widget's tooltip information to showcase how filters directly influence the result.
Together with the raw data above, this should hopefully give a good indication of what to expect when setting this up on your own dataset's columns!
Numeric columns support the most aggregation types: 'Sum', '(Weighted) Average', 'Median', 'Count Rows', 'Count Distinct', 'Minimum', 'Maximum', 'Standard Deviation', and 'Rate'. Only 'Cumulative sum' is not available in this context.
Date(time) columns support 'Count Rows', 'Count Distinct', 'Minimum', and 'Maximum' aggregation types.
Hierarchy columns support 'Count Rows', 'Count Distinct', 'Minimum', and 'Maximum' aggregation types. Note that 'Minimum' and 'Maximum' aggregations will use ascending alphabetical ordering: in case both values "a" and "b" would exist in your data source for the specific query context, 'Minimum' would return "a" while 'Maximum' would return "b". This result can also be seen in the first widget that does not group on anything.