[Meta][Lens] Calculations and advanced queries

[timroes]

This meta issue tracks advanced editing features in Lens. Those are features targeted for more advanced users or use-cases.

Issues

• Time offset comparisons [Lens] Compare against time offsets #68458
• Month over month calculation Month over month calculation in visualizations #35043
• Compare against time offset [esaggs] Compare against time offset like timelion #71287
• Cumulative sum [Lens] Add cumulative sum aggregation #61776
• Moving average [Lens] Add moving average aggregation #61777
• Derivative [Lens] Add derivative function #61775
• Event rate [Lens] Discuss types of rates #62375
• Positive growth rate [lens] Add "counter rate" for monotonically increasing numbers #46627
• Simple ratio calculation [Lens] Add simple ratio calculation, similar to filter ratio #42385
• Filterable metrics [Lens] Filters for each number metric (part of filter ratio) #67228 Allow filtering of individual metrics #16672
• Architectural requirements [Lens] Architectural requirements for calculations #68460
• Math using tinymath [Lens] Math using TinyMath #68969
• User experience for composing calculations/aggregations [Lens] User experience of composing aggregations and calculations #69215

[elasticmachine]

Pinging @elastic/kibana-app (Team:KibanaApp)

[flash1293]

Wrapped this into #57708