I'm currently using a dashboard with 2 simple date filters that represent the start and end of date filtering of all the queries of my dhasboard that are actually SQL request (not questions).
In my queries I do something like "where record_date between filter1 and filter2"
Is there a way to use these 2 dates for a question (and not a SQL Query)? Because if in my dashboard i link the 2 filters on my date column of my question, obviously the filters are run like "where record_date=filter1 and record_date=filter2", not "between"
As I said we're using 2 simple dates because few queries force us to use them. Indeed with a Date Range (All option), it would fix the problem
@Mor0xx But you are asking if you can use two filters on GUI questions similar to SQL questions, the answer is no, since you don't have a same control in GUI questions, so it expects you to use a single filter with range instead.
Similar, you can create Field Filters in SQL questions (in most cases), which allows you to use a single filter on the dashboard with a range:
Isn't there a way to create a custom filter that uses variables eventually?
I've tried to use a question on a saved question that uses filters, and unfortunatly these filters are not usable in the question
Thanks for your replies anyway
@Mor0xx You cannot currently parse parameters to nested questions.
If you are using SQL questions, then you can use simple variables or Field Filters:
If you are using GUI questions, then everything is done automatically for you and you just connect the dashboard filters to the columns returned in the question.