Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I will want to display the average of my MTBF (column 1) of the name (Name column) of the non-empty rows of the sector_mtbf column
How to proceed
thank you
LOAD Name,avg(MTBF) Resident test where not match(sector_mtbf,'-') Group by Name ;