What is the validation rule to use?
Validation Rules | Description/Usage |
column_name | In the pie chart, specifies the column to display |
x | In the line and bar charts, specifies the X value |
y | In the line and bar charts, specifies the Y value |
min | In the line and bar charts, specifies the minimum value to display |
max | In the line and bar charts, specifies the maximum value to display |
target | In the line and bar charts, specifies the target value to display |
Why use this validation rule?
With this validation rule, you will be able to:
To set up specific targets for the charts, as well as optional minimum, maximum and target values
How to use this validation rule?
In a 
pie chart
This visual only requires a column_name to display statistics.
In the validation rule cell, the requirement is to put this column_name between parentheses.
Example: (column_name)
In a 
line chart
This visual requires the use of x and y in order to display statistics.
Optionally, you may add a min, max and/or target as limits to add more insight to the visual. These limits can come from either a field outside of a table or a column within the same table as the x and y values.
Visually, the min, max and target will be a broken line to
In the validation rule cell, the requirement is to put the required values, and optionally the limits, between parentheses.
Examples:
(x: column_nameA y: column_nameB)
(x: column_nameA y: column_nameB min: min_field max: max_field)
(x: column_nameA y: column_nameB min: min_field max: max_field target: target_field)
(x: column_nameA y: column_nameB target: target_field)
(x: column_nameA y: column_nameB min: min_field target: target_field)
In a 
bar chart
This visual requires the use of x and y in order to display statistics.
Optionally, you may add a min, max and/or target as limits to add more insight to the visual. These limits can come from either a field outside of a table or a column within the same table as the x and y values.
Visually, the min, max and target will be a broken line to
In the validation rule cell, the requirement is to put the required values, and optionally the limits, between parentheses.
Examples:
(x: column_nameA y: column_nameB)
(x: column_nameA y: column_nameB min: min_field max: max_field)
(x: column_nameA y: column_nameB min: min_field max: max_field target: target_field)
(x: column_nameA y: column_nameB target: target_field)
(x: column_nameA y: column_nameB min: min_field target: target_field)