[[AND {{dateRange}}]] Consider this as a fieldFilter of metabase
-> I need dateRange as montly/Quaterly How we can create a branch kinda thing so that we can choose among them
Welcome to Metabase.
Field filters take their values from a predefined list. Confirm if you already have a predefined list of filters.
Here in date Range i need option of quarterly/weekly/custom/monthly how we can achieve
Like manually we should not set the range for monthly/weekly/quarterly if we press quarterly it should automictically set it. I need all the options in the drop down. Can we achieve it??
Hi @manojnoochila
When you mean Weekly / Quarterly / Monthly, does it mean you want some form of aggregation?
Yeah
The problem is i am building for one of our internal team. They may filter the data based on weekly/monthly or Quarterly. So i thought if those options were in the drop-down it would be helpful for them. Instead of manually selecting the date range. That's the problem i am solving
Can i get any response??
How we can have montly,weekly,quartely and yearly filters in one option
Hi @manojnoochila ,
Apologies for the late response. I must have missed the notification.
As I mentioned earlier, monthly, weekly, or yearly will indicate a form of aggregation. There is a way to accomplish this using SQL, where the data is shown per week.
Here is sample I am talking about
Cool thank you
Also i have couple of doubts
-> I have field filters in metabase dashboard which have some default values. Also these field filters are linked filters to some other filters. So is there any way if i change a variable then the dependent variable's default value should change. How we can achieve it in metabase.
->Can we create dynamic sizeing for the charts in metabase.
For eg-> i have written sql query and has a limit as a dynamic field filter. Now is there some way if i select more rows the graph adjust's itself.
->Is there treeMap visualisation in metabase?.
AFAIK, no Tree Map Visualization yet. There is an open issue about it: Visualization: Treemap · Issue #3189 · metabase/metabase · GitHub
For the field filters, I would say as long as a relationship exist between the filters and the it's reactive, then the field filters will work.
For example, if I have a column that is linked to another table via a foreign key, a change in data in the parent table will also affect the filter in the child table.
Regarding Field Filter doubt
What is reactive that you mentioned above in the previous thread?.
For the field filters if i have selected default value then it should automatically change right ??
whenever it's linked filter changes. But It is not working. What to do