Kibana table sum of count and timeseries count for given host

[PRASHANT_MEHTA]

Hello All,

I want to display above two visuals based on below table.As for now above two visuals are wrong,but desired in same style.
Whenever there is an error it should display the translator name and total count of error for given translator,same should be shown through time series.For time series it required number metric and dont work on string.
The "error" filed is a string value.(Above two visuals are to be created based on error filed)
Buckets aggregation is done on a filed translator_taskid i.e unique.

Any suggestion would be helpful.

Many thanks

[Marta_Bondyra]

For the first visual:

1. let's assume that the Cancelled is Error field and Carrier is Translator field. You can achieve the visualization by setting a filter for the whole visualization (Error: true or whatever string it is) and create something like: