Canvas Issue - math

[PaulaCM (Paula)]

Hey! I don't know if someone got this issue or knows how to help:

I am doing a SQL query which is working fine:
// SELECT COUNT(DISTINCT "idVisit") FROM "test"

but when displaying an error appears

"Whoops! Expression failed with the message:
[math] > Unknown variable: country"

I don't know why this error appears (country is another variable in the dataset, but not one I'm interested in showing now) since this is not a variable I'm using in the SQL query.

Any help is appreciated!
Paula

[jsanz (Jorge Sanz)]

You need to remove and add the Measure property. It's easier to understand if you enable the Expression editor.

I think this is a regression I will open an issue to confirm with my colleagues.

[jsanz (Jorge Sanz)]

Reported at Canvas: measure value not updating when changing from demo data · Issue #127482 · elastic/kibana · GitHub