I have a Metric element on Kibana Canvas with the following expression syntax:
filters group="default"
| essql
query="SELECT COUNT(*) as count FROM \"index1*\" "
| markdown "
{{#each rows}}{{count}}{{/each}}
"
font={font size=36 align="center"}
| render containerStyle={containerStyle}
Would it be possible to add a 2nd query and use if logic in the markdown syntax, for example use another query
"SELECT COUNT(*) as count FROM \"index2*\" "
and only display the markdown if count from index2 is greater than 0?