General Chart Settings
This section is available for all chart types; however, the options in it vary among chart types. All available options, regardless of the applicable chart type, have been listed in alphabetical order and briefly described in this article. Options that are specific to some charts are discussed in more detail in the individual chart type articles, and a link is provided where applicable.
Tooltips
Toggle the Tooltips option to display additional information when hovering over data points in a chart. You can also customize the information displayed in a widget's chart tooltips using a Custom Token.
Self-service Options
The Self-service Options enable users to toggle access to self-service features within their data views. The options available vary by chart type:
- Filtering: Toggle whether users can apply filters directly to the chart, refining the data displayed according to specific criteria.
- Sorting: Toggle whether users can sort data.
- Chart Selection: Toggle whether users can display data as another similar chart type.
- Download: Toggle whether users can download chart data or specify the downloaded file format.
- Fit To Panel: Toggle whether users can access the "fit to panel" button.
- Column Replacement: Toggle whether users can change the category, value, and series columns from the chart panel—or, in general, the columns used in the chart.
- Column Aggregation: Toggle whether users can adjust how the data is aggregated.
- Date Grouping: Toggle whether users can adjust the time interval for grouping data (if the category has a "Date" data type).
- Column Arrangement: Toggle whether users can rearrange the relative position of columns.
- Column Resizing: Toggle whether users can adjust column widths.
- Visualization Options: Toggle whether users can change the visualization of numeric values inside a table between values and bars.
- Adding/Removing Columns: Toggle whether users can add or remove columns.
Aggregated Formulas
This feature allows you to create a new column of data using a formula based on the aggregated columns in a table chart. It is explained in more detail in the Table Charts article.
- Default: N/A
- Applies to: Grouped Tables
Allow Pagination
This checkbox is only available for ungrouped Table charts and works in conjunction with the Max Rows value. If unchecked (default), the table appears without pagination and displays a maximum number of rows as selected in the Max Rows control (500 by default) in one long table. If selected, the table will break into smaller pages, each containing 30 rows by default. In this case, the Max Rows control is replaced with the Records Per Page control, which determines the number of records displayed per page. In this mode, you can page through all the data in the dataset.
- Default: Off
- Applies to: Ungrouped Tables
Display Averages
This checkbox is available for Min/Max charts and plots the average point for each data point when checked.
- Default: Off
- Applies to: Min/Max charts
Fixed Scale
This checkbox is only available for Dial and Bullet gauges and allows you to determine the lower and upper limits of the chart.
- Default: Off
- Applies to: Dial Gauge, Bullet Gauge
Freeze First Column
This checkbox is only available for Expandable Table charts and keeps the first column in place when the table is scrolled horizontally. It is checked by default.
- Default: On
- Applies to: Expandable Tables
Labels
The Labels checkbox controls showing or hiding labels for Rows and Columns in Crosstab Charts. When the Labels checkbox is marked, an Edit option is automatically added to the three-dot button of the label box. An additional Sorting option also appears as another checkbox. Turning on this option adds sorting icons inside the label boxes.
- Default: Off
- Applies to: Crosstab
Legends
This setting is available for charts that support legends, such as all multi-series charts, Combo and Pie charts, and most metric and map charts. When enabled, legends are displayed as colored boxes above the chart, showing the category represented by each color. Thresholds must be defined for metric charts before legends are displayed.
Legends can be toggled on or off using the icons shown in the following images. By default, legends are enabled.
- Default: On
- Applies to: Multi-Series Bar, Multi-Series Line, Multi-Series Symbol, Combo, Pie, Dial, Bullet, Heatmap, Bubble Map, Choropleth Map
Max Data Points / Max Slices
This setting allows you to define the maximum number of data points to display in your chart. By default, the Max Data Points limit is set to 50 for performance reasons, but it can be adjusted to a lower or higher number. To define the maximum number of data points, set the desired number in the box, which will immediately be reflected in the chart preview. Keep in mind that selecting a large number of data points may result in longer loading times.
Note: If your chart appears to be missing data, check the Max Data Points section and increase the limit to display more data.
Note 2: For pie charts, this setting is referred to as Max Slices.
- Default: 50
- Applies to: Bar, Line, Symbol, Multi-Series Bar, Multi-Series Line, Multi-Series Symbol, Dot Map, Bubble Map, Choropleth Map, Pie, Heatmap, Box & Whisker, Word Cloud
Overriding the Max Data Points Setting
When exporting charts, you can configure the Qrvey platform to override the value set in the Max Data Points field and always export all data. This override is configured using the Backend API. It affects the CSV, CSV Summary, Excel, and PDF export features.
Max Groups
This control applies to grouped tables (default 50) and expandable tables (default 10) and determines the maximum number of groups. The setting is there for performance reasons and to prevent accidental grouping of data fields with too many unique values that may result in an excessive number of groups.
- Default: 50 for Grouped Tables and 10 for Expandable Tables
- Applies to: Grouped Tables, Expandable Tables
Max Rows / Max Columns
These are fields in Crosstab Charts where you can set a maximum limit on the number of rows or columns you want to show. The maximum number of data points is 10,000 in total—this includes both rows and columns combined.
- Default: 500 (Rows), 50 (Columns)
- Applies to: Crosstab
Max Series
This field lets you increase or decrease a limit on the series you want to show in a single category in a multi-series chart, which is by default set to 50.
- Default: 50
- Applies to: Multi-Series Bar, Multi-Series Line, Multi-Series Symbol
Menu Actions
Table Charts offer some options in interaction mode (when the chart is saved and placed on the dashboard). The Edit and Multi-column Sort options are always available from the three-dot menu in the header of each column. The availability of the two other options, Sorting and Visualization, can be controlled from this section.
When Sorting is checked, it adds the sorting button () to the column header for all columns. When Visualization is checked, the command is added in the three-dot menu of numeric columns and allows users to decide whether they want values to be displayed as numeric or as bars.
- Default: On
- Applies to: Tables
Records per Group
This value controls the maximum number of rows that are retrieved for each group in expandable tables and defaults to 10.
- Default: 10
- Applies to: Expandable Table
Sort by
All charts offer sorting capability on their various data columns; however, the access point to the sorting options may vary. The Sort by option in the General configuration is available for a handful of charts—like the pie chart—that have a simple sorting use case by either the selected category or values column.
Default sorting depends on the selected chart and the data types of the selected columns. However, you can switch between sorting by the category column and value column by clicking on the ABC and 123 icons, respectively. You can also change the direction of sorting from ascending to descending and back by clicking on the sort direction icons on the right.
For more information, see Sorting.
- Default: Values column descending (Pie), Category column ascending (Heatmap)
- Applies to: Pie, Heatmap
Subtotals
This option only applies to Crosstab charts and adds subtotals for each column when more than one category has been added to Columns.
- Default: Off
- Applies to: Crosstab
Table Calculations
Various standard functions can be used to calculate values based on data within the chart. Each table calculation function results in a new column of data that can be plotted in the chart. An example of such a table calculation function is the “running total” of a value within any given group. Read more about configuring Table Calculations here.
- Default: –
- Applies to: Multi-Series Bar, Multi-Series Line, Multi-Series Symbol, Combo, Table (ungrouped)
Tooltips
This section enables you to add Tooltips based on any column to most chart types.
- Default: On
- Applies to: All charts other than Table, Crosstab, Expanded Table
Totals
Totals is an option for all table chart types and is described in detail in those articles.
The option allows for aggregations to be added to rows and columns in Crosstab charts and aggregations for columns in the other types of Table charts.
- Default: –
- Applies to: Table, Crosstab, Expanded Table