Forum Discussion
Right First Time Report
Hi, I'm trying to make a report which will look at data on the failures we've had with a group of assets and report back when the following situation happens: The asset fails, it goes into the w...
Anonymous , Create two new column and check if they work for you
Next Date =
var _dt = [Date of work start]
return
minx(filter(Table, [Assets] = earlier([Assets]) && [Date of work start] >_dt && [Date of work start] <=_dt +10),[Date of work start])Date diff =
datediff([Date of work start],[Next Date],day)
amitchandak
Super User
Super UserAnonymous , Create two new column and check if they work for you
Next Date =
var _dt = [Date of work start]
return
minx(filter(Table, [Assets] = earlier([Assets]) && [Date of work start] >_dt && [Date of work start] <=_dt +10),[Date of work start])
Date diff =
datediff([Date of work start],[Next Date],day)
Thanks amitchandak just what I needed.