Hi
is it possible to use any drop down list like functionality on time series graph to hold the series of question.
Filter is available. But i am specifically looking for dropdown if possible.
Hi
is it possible to use any drop down list like functionality on time series graph to hold the series of question.
Filter is available. But i am specifically looking for dropdown if possible.
Hi @Prajakta2021
Yes, depending on the data source and with a bit of workarounds - see comments in these issues and upvote by clicking on the first post
https://github.com/metabase/metabase/issues/5346
https://github.com/metabase/metabase/issues/6583
https://github.com/metabase/metabase/issues/9875
Thanks That Helped.
Got additional question on it. I have created filter on sample dashboard as shown in image. But when i am trying to use dropdown list value. It gives me error(another image)
issue is happening with my other dataset. Where i am using one text column having more than 500 value to display in dashboard. i have created query like below
select * from SampleDataset.PRODUCTS
where {{id}}
if i havent use dataset name it dosent give me values. my dataset is coming from bigquery.
@Prajakta2021 You have to define the dataset in the FROM-clause:
https://www.metabase.com/docs/latest/users-guide/13-sql-parameters.html#the-field-filter-variable-type
Tried above already.
I have created query which gives me output with no value in filder. as soon as i select something from dropdown it gives me error.
This is the error i am getting
Unrecognized name: DatasetName.TableName
at [3:10]
@Prajakta2021 Please read this article carefully:
https://www.metabase.com/learn/building-analytics/sql-templates/field-filters.html
Make sure that the Field Filter that you reference in the sidebar is included in your FROM or JOIN clause.
Thanks for details. Issue resolved.