Forum Discussion
Solved
Help with column analysis
I have a table with dispatch data and I need to find the smallest time element when multiple units are on the same call. If the Incident Number is the same, return the smallest Dispatch to Clear Tim...
you can try this
Column = minx(FILTER(Sheet1,Sheet1[Incident Number]=EARLIER(Sheet1[Incident Number])&&Sheet1[Frontline Unit]=1&&Sheet1[Multi U]>1),Sheet1[Dispatch To Clear (seconds)])+0pls see the attachment below
Ryan,
Thanks, that did get the correct output.
you are welcome