Cluster trend overview


Refers to the average percentage daily increase or decrease in number of incidents created within a cluster.

Example:

You have 100 tickets that are divided into 3 clusters and the look back period is biweekly. The clusters are formed in this manner:

  • Cluster 1: 30 tickets
  • Cluster 2: 45 tickets
  • Cluster 3: 25 tickets

Calculation for each cluster

To determine the average daily trend inside every cluster, the calculation is done in the following manner:

(Difference in the number of tickets created as compared to the previous day/Total tickets created on the previous day) *100

Day

Tickets created per day

Difference in the number of tickets created as compared to the previous day

Percentage increase or decrease w.r.t tickets on previous day

Day 1

3

-

-

Day 2

0

-3

(-3 / 3 ) * 100 = -100%

Day 3

5

+5

(+5 / 5 ) * 100 = +100%

Day 4

7

+2

(+2 / 5) * 100 = 40%

Day 5

2

-5

(-5 / 7 ) * 100 = -71.42%

The average percentage change in daily ticket creation for a cluster is then calculated in this manner:

Total percentage / (number of days - 1)

In this case, -100 + 100 + 40 – 71.42 / 5-1 = -31.42 / 4  = -7.85%.

Important

If the total number of tickets created on the previous day is 0, to avoid dividing by zero error, the net effect is adjusted to be +100%. This is done on similar lines when the total number of tickets created on the current day is 0, its net effect is -100%.  
Example:
From day 2 to 3, we have 0 tickets created on the previous day, and 5 tickets created on the current day. Hence, the net effect is +100%.
From day 1 to 2, we have 3 tickets created on the previous day and 0 tickets created on the current day. Hence, the net effect is -100%.

This approach provides a clear indication that there has been a 100% increase relatively in incidents from the initial state to the final state, which can be useful for understanding the overall trend.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*