number of days that the machine stopped

[MachisukiJ]

hello to y'all, i want to know if there's a way to actually show the number of days that something stopped working, for an example, i have 50 machines, i want to make an column that shows how many days it was not working like for 1 day and a half the process needed to stop bc the machine broke, or, another machine stopped during two days, is there a way to do it ? i also want to do another column that will show the quantity of times that it broke till that moment, an top 5 with the machines that have more issues.

since now thanks !!!

[mahenkj2]

Hi @MachisukiJ 

You can create a Date table, relate it with fact table where you add date of stoppage or run and stoppage. Then it is possible to report how many days a machine was up or down, calculate machine utilization etc.

Hope it helps!