Kibana version: 7.12
Describe the bug:
When using 3 out of the 4 new calculation functions (counter rate, differences, and moving average) in a datatable, the value sorting seems to not properly work:

Cumulative sum works ok as it does not have null values.
Steps to reproduce:
- Use the logs sample data
- Open the Lens editor and pick the Datatable visualization
- Add
@timestamp to the Break down by section
- Configure a
Moving Average of Percentile as Metric
- Sort the
Moving Average column (either ascending or descending)
-- values float in the table without being pushed down.
Expected behavior:
Sorting should work as other operations where -- values are pushed down at the bottom (or considered as minimum value, either way is ok) and the remaining numeric values gets sorted accordingly.
Kibana version: 7.12
Describe the bug:
When using 3 out of the 4 new calculation functions (counter rate, differences, and moving average) in a datatable, the value sorting seems to not properly work:
Cumulative sum works ok as it does not have null values.
Steps to reproduce:
@timestampto theBreak down bysectionMoving Average of PercentileasMetricMoving Averagecolumn (either ascending or descending)--values float in the table without being pushed down.Expected behavior:
Sorting should work as other operations where
--values are pushed down at the bottom (or considered as minimum value, either way is ok) and the remaining numeric values gets sorted accordingly.