Kibana canvas metrics font not working

Hello,
I'm trying to create very simple metrics in canvas.
I correctly set the data source et the SQL (data preview is showing the correct data).
But whenever I try to add font in the expression, the value becomes '0' or '?'.
Anyone can send me very simple font so I can try to use it ?

My expression is like this :
filters "one" "two"
| essql query="SELECT count(*) FROM "messages""
| metric "Count"
metricFont={font family="'Open Sans', Helvetica, Arial, sans-serif" size=96 align="center" color="#000000" weight="normal"}
labelFont={font family="'Open Sans', Helvetica, Arial, sans-serif" size=10 align="center" color="#000000" weight="normal"}

Maybe the issue is in the name of the column in your output?

I created a metric from kibana flights sample without issues, changing fonts and even adding a small margin with a custom CSS. See the SELECT count(*) as row_count

kibana
| selectFilter
| essql query="SELECT count(*) as row_count FROM \"kibana_sample_data_flights\""
| math "row_count"
| metric 
  metricFont={font align="center" color="#000000" family="'Lucida Grande', 'Lucida Sans Unicode', Lucida, Verdana, Helvetica, Arial, sans-serif" italic=false size=48 underline=false weight="normal"} 
  labelFont={font align="center" color="#000000" family="'Hoefler Text', Garamond, Georgia, 'Times New Roman', Times, serif" italic=false size=14 underline=false weight="normal"} metricFormat="0,0.[000]" "Rows count"
| render css=".canvasRenderEl
.canvasMetric__metric {
  margin-bottom: 15px;
}"

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.