XTdb

[George Handley]

Hi Henk,

I don’t know what you’re doing this time, but I've had some success out of the box applying some basic stat 101 logic to these types of comparison problems.

You say it happens infrequently. Is it just a high phenomenon or both high and low?

Can you assign a percentage of dailey or weekly runtime spikes occur?

What type of accuracy are you expecting? Is 95% accuracy acceptable? You may need greater accuracy. I don’t know.

If you keep your logs like I do, by studying your own data over a period of time (15-30 minutes of reserch) you will hopefully confirm strong confidence in just knocking out the top and bottom 3 readings, before you expect to arrive at an answer. There’s a staple math reference stat book filled with tables of all sorts of things stat standard deviations etc. to expect when you fill in the other blank vars. Yes it is a quick and dirty and different way to do it but it works surprisingly well for me. 

Good luck,

George



> On Oct 14, 2022, at 10:31 PM, Dave Fleck <dfleck at pacifier.com <mailto:dfleck at pacifier.com>> wrote:
> 
> In XTdb go to the Database menu and choose Show Database Window. Double click on the unit you want to filter. Choose the Filter button on the lower right of the Database Unit Detail dialog. Set a Min and Max and all values outside of those will be deleted.
> 
> Cheers
> 
> Dave
> 
>> On Oct 14, 2022, at 10:46 AM, Hendrik van Eeden <hvaneeden at comcast.net <mailto:hvaneeden at comcast.net>> wrote:
>> 
>> Hello List,
>> 
>> I am graphing several temperatures and am runic into a problem where on occasion, one temp goes way high out of range.  That drives  all the other temps to straight line at the zero X-axis.  I have the box checked that limits the value to a range, but that does not seem to work.
>> What I want to do is delete the erroneous values, but I cannot figure it out.
>> Is there a way to do that?
>> 
>> Henk
>> 
>> _______________________________________________
>> XTensionList mailing list
>> XTensionList at machomeautomation.com <mailto:XTensionList at machomeautomation.com>
>> http://mail.machomeautomation.com/mailman/listinfo/xtensionlist <http://mail.machomeautomation.com/mailman/listinfo/xtensionlist>
> 
> ----------
> “So heavy is the chain of wedlock that it needs two to carry it, and sometimes three.” -- Alexandre Dumas
> 
> 
> 
> 
> _______________________________________________
> XTensionList mailing list
> XTensionList at machomeautomation.com <mailto:XTensionList at machomeautomation.com>
> http://mail.machomeautomation.com/mailman/listinfo/xtensionlist

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.machomeautomation.com/pipermail/xtensionlist/attachments/20221015/57772f66/attachment.html>