When using Line Threshold Type, this setting will determine the placement of the entire threshold line.
When using Area Threshold Type, this setting will be one of two points that will determine the boundaries of the threshold area, the other being To-Value.
When using Change Threshold Type, From-Value (this setting) will be compared against To-Value. If To-Value is larger than From-Value, the threshold will indicate a positive change. Conversely, if To-Value is smaller than From-Value, it will be displayed as a negative change.
Select the value type that is used to determine the From-Value.
- Constant: This setting will reveal a From-Value field where you can manually enter a numerical value where you wish to place the threshold.
- First: From-Value will be placed at the first value in From-Series in order of the appearance on the chart.
- Last: From-Value will be placed at the last value in From-Series in the order of appearance on the chart.
- Minimum: From-Value will be placed at the smallest value in From-Series.
- Maximum: From-Value will be placed at the largest value in From-Series.
- Average: From-Value placement will be determined by calculating the mean value of From-Series.
- Median: From-Value placement will be determined by calculating the median (middle value) of From-Series.
- Percentile: Enter a percentage in the From-Percentage field and the visual will place From-Value at a point that is above x% of data points in the From-Series. (Example - if the series has 10 visible data points, entering 70% will place From-Value at a value that is higher than 7 of the data points.)
- Dynamic Threshold 1 or 2: From-value is defined dynamically using the Dynamic Threshold fields field or measure, instead of relying on fixed static values or default aggregation methods. Dynamic Threshold update automatically based on the data / measure context and can also be controlled by using parameters.