Handle Spike or overflow value in dataset

Ignition
7

This is looking like a totalizer value. I'd say the median would be the one to use here. Using statsutils' quantiles, you should be able to filter out spikes in both directions.

Statistics Extensions for Ignition

data = dataset.getColumnAsList(dataset.getColumnIndex('value'))

s = shared.statsutils.Stats(data)

print s.get_quantile(.25)
print s.get_quantile(.75)