The Target formatting option in the Solid Gauge chart allows you to change the look and feel of the Target value.
The table given below describes different fields present for Target formatting.
Field | Description | Remark |
---|---|---|
Text | It allows you to change the appearance of the data label Text. |
|
Display Unit | It allows you to select the multiples of units in which the variable is measured. | You can select any of the following units
Default indicates that the unit is assigned automatically by parsing the range of the data. That is, Thousands/Millions/Billions/Trillions is automatically assigned based on the data. |
To use the Target formatting options in a Solid Gauge chart, first plot the widget.
Now,
The resultant widget is shown below.
The Target formatting option is available in Sparkline chart.
By default, the Target formatting options are not visible. Turn the toggle button ON ( ) to use the Target formatting options.
User can define a threshold to be set for color formatting of the horizontal spark lines for each row. Either using an aggregated dataset column value (e.g. Total Cost(sum)) or by entering a number manually (e.g. 10000). The user can then set the different colors for points above and below the selected threshold.
The table given below describes different fields present on Target formatting.
Field | Description | Remark |
---|---|---|
Input Value | It allows you to enter the threshold value manually. | At a given time, only one can be selected - either Input value or Dataset value. |
Dataset | It allows you to select measure from the dataset as threshold value. | At a given time, only one can be selected - either Input value or Dataset value. |
Threshold Value | This acts as the determining point for rest of the values. | — |
Above Target Color | It allows you to select the color to use for the values that are above the threshold level. | — |
Below Target Color | It allows you to select the color to use for the values that are below the threshold level. | — |
To use Target formatting options, first plot a Sparkline Chart using the dimensions and measures from the dataset. For example, we plot a Sparkline Chart of the Income against Gender and Axis is Married.
The figure given below shows an original image of the Sparkline Chart. By default, Target is off.
Now,
The resultant widget is shown below.