Advanced configuration
Editing advanced configuration
Some configuration options are not available in the user interface. These can be set by opening the advanced configuration panel.
Opening the configuration panel and making some changes looks like this.
Slice configuration options
Here are the available slice configuration options
noDataMessage
A html message to display when no data has been returned to this slice. Invalid html will be stripped from this message.
A string containing valid html.
All slices
minSelections
The minimum number of data selections that must be selected in this slice. These selections will happen automatically. Setting these values in advanced configuration gives you more flexibility than the Selections chooser allows.
Integer
All slices
maxSelections
The maximum number of data selections possible. Setting these values in advanced configuration gives you more flexibility than the Selections chooser allows.
Integer
All slices
minZoom
The minimum zoom level that the map can zoom to.
Integer
Map
maxZoom
The maximum zoom level that the map can zoom to.
Integer
Map
numberOfRows
The number of rows to show in the leaderboard.
Integer
Leaderboard
includeAppSlugs
The slugs of apps that a user can link to. Users will only see apps that they have permission to see.
A list of strings containing valid app slugs.
Navigator
Data configuration options
Data configuration lets you control what data shows up in the slice. These configuration options will affect the SQL queries run by the slice and how those queries are validated and cached.
include_automatic_filter_keys
A list of strings containing the automatic filters that are allowed. Filters not on this list will be ignored.
A list of strings
All slices
exclude_automatic_filter_keys
A list of strings containing automatic filters to ignore.
A list of strings
All slices
automatic_filters
A dictionary containing automatic filter keys and values that will be applied to this slice. Using filter_expression is preferred.
A dictionary
All slices
filter_expression
One or more expressions that customize what you see in this slice. The expressions must evaluate to a boolean value.
A string, or a list of strings containing valid boolean expressions
All slices
order_by_expression
One or more expressions that control the display order of data you see in this slice.
A string or list of strings containing valid expressions.
All slices
apply_automatic_filters
Should data permissions and user selection filtering be applied to this slice. Default is true.
true, false, default is true
All slices
strict_automatic_filters
Is every key in data permissions required to exist in the data source used by this slice.
true, false, default is true
All slices
cache_region
Controls how long SQL query results are cached for. Every database connection has a default cache_region that is set by Juicebox support.
String, must be one of "1-second", "2-hours", "1-day", "1-year"
All slices
Comparison configuration options
The measure chooser slice supports comparisons. The comparison is based on the data shown in the chooser, but this can be adjusted. Here's what a measure chooser with comparisons can look like:
Here are the options you can add. Note that they all start with "comparison_".
comparison_exists
Ensures a comparison is added even if no other comparison values have been set
Boolean, true or false
Chooser
comparison_label
What to call the comparison value
String
Chooser
comparison_metrics
A list of values OR a list of metric ids to display as the comparison. The list must be the same length as the number of metrics in the chooser. The lists will be matched to the metrics in the chooser.
A list of numbers OR a list of strings that are metric ids.
Chooser
comparison_apply_automatic_filters
Should automatic filtering from slices above be applied to this comparison.
Boolean, true or false
Chooser
comparison_exclude_automatic_filter_keys
A list of strings containing the automatic filters that are allowed. Filters on this list will be ignored.
A list of strings
Chooser
comparison_include_automatic_filter_keys
A list of strings containing the automatic filters that are allowed.
A list of strings
Chooser
comparison_strict_automatic_filters
Is every key in data permissions required to exist in the data source used by this slice.
Boolean, true or false.
Chooser
comparison_filter_expression
One or more expressions that customize what you see in this slice. The expressions must evaluate to a boolean value.
A string, or a list of strings containing valid boolean expressions
Chooser
comparison_cache_region
Controls how long SQL query results are cached for. Every database connection has a default cache_region that is set by Juicebox support.
String, must be one of "1-second", "2-hours", "1-day", "1-year"
Chooser
Last updated
Was this helpful?