Canvas - percentage of docs having specific value in a field (row by row)

[tims (Tim Schnell)]

Hey @Jim_Boutcher,

Here's an example of calculating percentages in Canvas, let me know if this helps.

Kibana Canvas , Calculate percentage using to aggregations

This is a little complex, but I believe what you want is possible in Canvas. Essentially you need to query your index twice in the same expression to get the two different counts, and it also utilizes filter groups which was introduced in Kibana 7.2.0. I assume you wanted both counts to be filtered by the same time filter to filter your date field. Here's the example using the ecommerce sample data set: [Jul-18-2019%2015-16-52] Time filter on order_date: timefilterControl compact=true column…