Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

MTBF implementation for Service Now

Hi All,   I am stuck in a situation where I have service Now (SNOW) data for P1,P2 and want to calculate MTBF based upon the assignment group.But confused about the situation when we have only one ...
General Comment
Interesting Links
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    7 years ago

    Hi,

     

    In my case the above solution did not work.I tried with another solution.

     

    I created a Row count column as below which groupe the data based upon the Assignment group and priority and gives the count of this .

     

    Row_counts = CALCULATE(COUNTROWS('INC Overview'),ALLEXCEPT('INC Overview','INC Overview'[Priority],'INC Overview'[Assignment group]))

     

    then I created another column let say Avg_MTBF which calculated the time between two failure of incidences and also cover those cases where we recieved only one incidence (in that case it will give the difference between today date and the day when it was occurred.)

     

    Avg_MTBF = If(([Row_counts]>1 && [2nd_highestvalue] <>BLANK()), DateDiff([2nd_highestvalue],[Created],DAY),
    IF([Row_counts]=1 && [2nd_highestvalue] =BLANK(),ABS(DateDiff(TODAY(),[Created],DAY)),0))

     

     

v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
7 years ago

Hi Anonymous,

 

Could you please mark the proper answers as solutions?

 

Best Regards,

Dale

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi,

     

    In my case the above solution did not work.I tried with another solution.

     

    I created a Row count column as below which groupe the data based upon the Assignment group and priority and gives the count of this .

     

    Row_counts = CALCULATE(COUNTROWS('INC Overview'),ALLEXCEPT('INC Overview','INC Overview'[Priority],'INC Overview'[Assignment group]))

     

    then I created another column let say Avg_MTBF which calculated the time between two failure of incidences and also cover those cases where we recieved only one incidence (in that case it will give the difference between today date and the day when it was occurred.)

     

    Avg_MTBF = If(([Row_counts]>1 && [2nd_highestvalue] <>BLANK()), DateDiff([2nd_highestvalue],[Created],DAY),
    IF([Row_counts]=1 && [2nd_highestvalue] =BLANK(),ABS(DateDiff(TODAY(),[Created],DAY)),0))

     

     

    • v-jiascu-msft's avatar
      v-jiascu-msft
      Microsoft Employee
      7 years ago

      Thank you very much for sharing with the community. Anonymous

       

      Best Regards,

      Dale