Solved: Need to create a field that returns a Yes/No based... - Page 2

towens-16505684 · 03-29-2023 07:15 AM

I have a table of Tasks with the description/info of the task as well as that date it was created.

What I need is a field that returns a yes or no if a task was created within the timeframe that the user specifies when filtering in the Explore. How could this be accomplished?

I’ve never used liquid parameters, but I’m thinking maybe that could help?

Dawid

Hi,

Yes, you’re on a right track!

First create a simple Filter of type:date

filter: date_filter {
  type: date
}

Then create a Yes/No dimension that is a result of the filter:

dimension: is_within_param {
  type: yesno
  sql: {% condition date_filter %} ${TABLE}.your_date_field {% endcondition %} ;;
}

Then you can use this field as an another filter or even attach it permanently in another explore sql_always_where, or in an NDT.

View solution in original post

Need to create a field that returns a Yes/No based on timeframe chosen by user