[Lens] Ability to display time series comparisons with Lens

[sorenlouv]

APM introduced time series comparisons in 7.13 (#81147). This allows the end user to easily compare the selected time range with the previous day or the previous week (more interval to come in the future).

The APM team wants to replace their custom visualisations with Lens to make it easier for users to make modifications and embed visualisations in dashboards etc. However, the lack of proper time series comparisons has proven to be a blocker for migrating to Lens (#152139, #145986).
While Lens does have a concept of "time shifts" this requires the user to make modifications to the visualisation.

This issue should serve as a way to track the progress of supporting time series comparisons in Lens similar to what APM has

[elasticmachine]

Pinging @elastic/apm-ui (Team:APM)

[ogupte]

We do a lot of optimizations with useFetcher, in serverless, is migrating to Lens going to incur a big performance cost?

[ogupte]

Is it possible to create a Lens configuration object from APM UI and link to it from our own charts?