Looker Connect Training

Help Center

Documentation

Community

Cloud Certifications

Question

Custom Filters on Dashboard Level

J
Userlevel 1

Hello,



We have a few dashboards with well over 20 tiles each and typically each month we have to change the filters for each tile. The complexity comes into play because each tile needs a custom filter applied (var1 = ‘x’ or (var 2 = ‘y’ and var 3 = ‘z’) or var 4 = ‘u’).



I was hoping that I can implement this filter at the dashboard level rather than the individual tiles level. I’ve tried looking online and it doesn’t appear that this has been asked or considered so I was wondering if this is a feature that I am just not seeing or if there is any work around other than going into all 20 tiles and updating the custom filter there.



Thanks,

11 replies

molly.lippsett
Rank
Userlevel 4

Hi @JLiou



While there is currently no option for custom filters on the dashboard level, I can definitely pass your feedback to our product team that that would be a useful feature!



In the meantime, you may be able to workaround this by creating a yesno type dimension for your tiles with your custom filter statement in the sql: parameter, something like:



 dimension: customfilter {


    type: yesno


    sql: (var1 = 'x' or (var 2 = 'y' and var 3 = 'z') or var 4 = 'u')   ;;


  }


Then you could filter for Yes values in that dimension on the dashboard level.

J
Userlevel 1

Hi @molly.lippsett,



Thanks for the info, I will take that approach.

M

Hi Molly, has this feature been added to the roadmap anywhere? I’m trying to use metadata to identify field-level dependencies and I need a filter that says “Query Text contains([table name]) AND contains([field name])”, but there’s no way to do an AND filter without a custom filter…

A
Rank
Userlevel 2

Hi @mvmichelman This feature hasn’t been added yet but I’d be happy to pass on some additional feedback to our product team.



As Molly suggested, we could work around this by creating a yesno type dimension with the condition in the sql and filter on that on the dashboard level.



Cheers,


Adina

Holger_Tamm

I am also looking for the ability to have OR logic at the dashboard level. I was able to solve it at the Look level with a custom filter but would like to apply the same on the dashboard. We basically have a yes/no value whether our customers have subscribed to a product and we have 5 products. Currently, I can only get the dashboard to show if a customer has all the products .on the dashboard but I can do if they have any. On the Look with this custom filter I use:(${subscription.e13n_access} = yes OR ${subscription.mobile_access} = yes OR ${subscription.ott_access} = yes OR ${subscription.p13n_access} = yes OR ${subscription.ss_access} = yes )


Ideas are welcome.

brecht
Rank
Userlevel 4
Badge

I think your best bet is to create a dimension with this logic and filter on that dimension. Assuming all those fields are boolean/yesno’s, this would work just fine:



  dimension: has_product {


    type: yesno


    sql: ${subscription.e13n_access} OR 


    	 ${subscription.mobile_access} OR 


    	 ${subscription.ott_access} OR 


    	 ${subscription.p13n_access} OR 


    	 ${subscription.ss_access} ;;


  }


On the dashboard apply a filter on the dimension to filter on ‘yes’.

Abraham_Chen

Huge Plus 1 to this feedback. We have a similar issue and a yesno filter won’t solve it

JessicaVDK
Userlevel 1

I’d like to raise this point again as well. Are there any plans yet for this feature?

We have a situation in which we have a very specific use case for a dashboard that require custom filters, but it’s not widely used enough to add it to the LookML. It would be amazing if we could just select the custom dimension created in any of the tiles as a filter on the dashboard level. 

jac7k

I’d like to raise this point again as well. Are there any plans yet for this feature?

We have a situation in which we have a very specific use case for a dashboard that require custom filters, but it’s not widely used enough to add it to the LookML. It would be amazing if we could just select the custom dimension created in any of the tiles as a filter on the dashboard level. 

Same here.

Fortunately it isn’t a dealbreaker for me in the immediate present, but it would be great functionality to include for when my company has a long list of priorities that supersede updating custom labels.

Andreas_Granstrom

Just want to plus one this one. Would be great to be able to use dashboard-level filters that can filter custom fields inside the tiles. 

J

It would be really helpful for this feature to be added.  Creating boolean logic in LookML can be inconvenient, as custom filters are often one-off use.  

Reply


Terms of Service