[FEATURE REQUEST] Datatable visualization - filter for metric

[tallavi]

Hi,

Awesome product!

In continuation to this discussion: https://discuss.elastic.co/t/datatable-two-counts-with-different-filters/140337, I'd like to propose to have the ability to put a filter on the metric in datatable visualizations.

Use case:

Let's say I have these documents:

service1 INFO "log line 1"
service1 INFO "log line 2"
service1 ERROR "error 1"
service2 INFO "log line 1"

I could have two count metrics: one called "Errors" with 'level:"ERROR"' as the filter, and one Called "Total" with "*" as the filter (the default), and then the table will look like this:

service Total Errors
service1 3 1
service2 1 -

Currently I believe that it's not possible to make such a table.

Thanks!

Tal

[timroes]

Duplicate of #16672