Urlparams syntax

Hello.
I'm trying to use urlparam on canvas on the "kibana_sample_data_ecommerce" index.
My param is "dy", and the value is "Tuesday".

When I use on markdown the syntax is:
image

My problem is when I try to use it on other visualitations, like dropdown filter or metric.
I'd like to use a urlparam in my query. For example, in a metric, I'd like to get the sum of the field "price" on Tuesdays.
Probably my syntax is wrong, if someone have some doc about urlparams I'll appreciated.

For dropdown vis:

It don't shows any data.

my elasticsearch query is:
essql query="SELECT day_of_week AS day FROM kibana_sample_data_ecommerce where day='{urlparam param=dy default=Monday}'"
| dropdownControl valueColumn="day" filterColumn="day"
| render

If I remove the where condition It works fine anyway:

And for metric vis:

It shows data, It must shows any value>0
But it shows 0.

The query preview also shows 0. So I think my syntax is wrong.
My query is:
"SELECT sum(products.price) AS price FROM kibana_sample_data_ecommerce where day_of_week='{urlparam "dy" default=Monday}' "

Can anyone help me with that or link some documentation about it?

Thanks. Luis.

Here is all I could find on urlparam
https://www.elastic.co/guide/en/kibana/current/canvas-function-reference.html#urlparam_fn


I could not get urlparam working in a where clause of an SQL statement.

Can you open an issue at https://github.com/elastic/kibana/issues/new?template=Bug_report.md?

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