xAccessor offset for timeseries data

[nickofthyme]

Is your feature request related to a problem? Please describe.
In timelion and APM, there are use cases where we want to display two timeseries with a given offset (i.e. a day, a week). Having a way to facilitate this kind of chart would be nice.

Describe the solution you'd like
An offset value on the series, some thing like xOffset, which will factor in this offset when rendering the geometry but use the original value for tooltip and interactions.

I don't know if this should be should be for non-time charts

Describe alternatives you've considered
Creating two series with the offset series matching the x values of the non-offset series. Then for the tooltip and interactions, inverting the offset to get the true value. This is less than ideal as this requires consumer to duplicate offset logic in many places.

Kibana Cross Issues
elastic/kibana#81147

elastic/kibana#98781 - time shift pr in Lens

Checklist

• this request is checked against already exist requests
• every related Kibana issue is listed under Kibana Cross Issues list
• kibana cross issue tag is associated to the issue if any kibana cross issue is present

[monfera]

It's in the class of lagging indicators, of which a specific time offset is only one case. There are other ones eg.

• period difference (called "derivation" in Kibana)
• windowed moving average
• EWMA

Also, other indicators may include not just lookback but also lookahead, eg.

• LOESS or LOWESS smoothing
• radial basis function network (RBNF)

It'd be best to figure out the common approach and implement the solution within such an extensible indicator architecture

[nickofthyme]

@monfera any ideas on what the api would look like for this?

[markov00]

The correlated issues are implemented/fixed in Kibana.
The custom solution for now is to pass a shifted dataset and use a custom tooltip to display the shifted time stamp.