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:
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.