Percentages without mapColumn

[shaunmcgough]

Canvas could benefit from allowing a user to easily obtain a percentage by comparing two fields. Right now, you have to use mapColumn to do this, such as:

filters
| essql
query="SELECT count(distinct foo_uuid) as foo_total FROM "bar" WHERE count > 0"
| mapColumn name="foos"
expression={filters | essql query="SELECT count(distinct foo_uuid) as foo FROM "bar" WHERE count > 3" | math "foo"}
| math "foo/foo_total"
| formatNumber "0,.0%"
| metric ""
metricFont={font family="'Open Sans', Helvetica, Arial, sans-serif" size=36 align="center" color="#000000" weight="normal" underline=false italic=false}
labelFont={font size=14 family="'Open Sans', Helvetica, Arial, sans-serif" color="#000000" align="center"}
| render

[elasticmachine]

Pinging @elastic/kibana-canvas

[wylieconlon]

This is closely related to #28265 #36193 #20515

[Heenawter]

Closing for now - there is a workaround for this feature (using mapColumn, as mentioned), and adding extra expressions and/or UI for this does not currently fit in to our Canvas roadmap. We can reopen if our priorities change 👍