I use a fill null in the comparative query as it picks errors, and I added _time for investigative purposes.
I have scrubbed the historic list csv to discard data that is unusual or not a normal reference point.
Does anyone know of a better way to do this??? and get the results that I am after...
I appreciate any suggestions to improve or make more efficient.