Bounce Back Rate

Step 1: In the Date Range of the data source, select 'Status was in' and specify "In Progress." For this analysis, we're focusing on data from the past 120 days within our demo project.

Step 2: Navigate to the Formula Metric tab and add a name for the formula metric.

Step 3: Add two formula parameters:

• P1: Basic metric 'Number of issues.'

• P2: Conditional metric 'Cycles in status' - status "In Progress," using the condition if(P > 1, 1, 0). This expression will filter only issues that have been in the 'In Progress' status more than once.

Step 4: Enter the formula equation (P2 / P1) * 100 to calculate the formula metric.

Step 5: For the Display By option, select the date field 'Last date in status' and choose the status "In Progress." In this case, we've enabled the Exclude Empty feature.

Step 6: Activate the Target feature and set the type to Fixed.

Step 7: Select Full Metric for the date target result and input the target value, which in this case is 20.

Open

Step 8: Specify that exceeding the target value is considered "Bad," making it a maximum threshold.