Question

Date Check as Filter

  • 20 February 2018
  • 1 reply
  • 67 views

I am trying to put date as filter in dashboard and apply it to certain looks. My condition will be like table date is >= input date.



is there any relational operator in looker I can use to achieve this?


1 reply

Userlevel 1

Hey @ayonsarkar,



I hope all is well! We have the ability to create a global filter for a dashboard. We can create this by selecting Edit on the dashboard, selecting Filters in the top left corner of the dashboard once we are in Edit mode, and selecting New Filter in the filters modal. In this modal, we can select the settings that coincide with the desired filter behavior that we want. For our example table date is >= input date , the modal would look something like:





So >= is the equivalent of is on or after in terms of our current example. The available relational operators will be in the Default Value dropdown menu. I hope this helps! Please let me know if you have any more questions or if I can clarify anything about this on my end!



Best,



Leticia

Reply