Skip to main content
All CollectionsHow-to Articles
How do I set a Threshold in a Report?
How do I set a Threshold in a Report?

Conditional formatting in SPS Analytics

Written by Emily Robbins
Updated over a week ago

A Threshold is a feature that allows you to apply a format to a range of cells, in a dashboard grid or a report, based on certain criteria.

To set a Threshold in a report, start by right clicking on the column header of the attribute or metric to which the threshold will be applied, and select Advanced under Thresholds.  The Advanced Thresholds Editor allows you to make advanced formatting edits, and add multiple conditions to the Threshold.

In the Advanced Thresholds Editor, the right clicked metric or attribute to which the thresholding will be applied shows in the upper left.  In the Filter On drop-down, choose the desired metric for the condition.  Next, use the drop-down to adjust the conditional statement, and add a value.  Set the Threshold by clicking Apply next to the value box.

After setting the Threshold Condition, double click on the Format Preview box to open formatting options.  

Make your desired formatting changes in the Format Editor box, such as font color or fill changes, and set selections by clicking OK. In the Advanced Thresholds Editor, ensure that the Format Metric and Subtotals Icon is selected, and complete the Threshold by clicking OK.

TIP: Remember to Create a Personal View or Save As to view the Report with Thresholds set in the future!

⛑️ SPS Analytics Support

If you have any additional questions regarding Analytics Report changes, please reach out to our Analytics Support team at the contact information below:

☎️ 888-739-3232, Option 2

Did this answer your question?