I couldn't find a clean and easy way to do this. In fact, I couldn't find a messy and hard way to do this.
But then I had a thought - those do happen from time to time - and might have a way to get this done.
A few weeks ago I saw an app released that integrates R into Splunk. R is a ... well, don't take it from me, follow the link I provided to the Splunk app and read up on it yourself.
R can do practically anything. Well, anything statistical. A quick search turned up pages like this page which show you a function that can be used to find where a time series crosses the X axis.
Are there others ways to do this using R? Probably. Do I have those magic answers? Nope. Not even close. Perhaps, though, if you ask real nicely, you may be able to get help from the tool's author (listed on the Docs page of the app) or at least some pointers.
For what its worth, some playing around may get you the answer you are looking for anyway. It might "just work" mostly like you'd expect. (I'm not holding my breath, but that would be brilliant if it did!)
So, while I'd be overjoyed if there was a clean easy way I just overlooked in Splunk to do this, I hope that at least this may give you a glimmer of hope. If you find an answer, could we ask you post it in here so that others who may want this same sort of functionality will be able to find it? Thanks!
... View more