we need to use cascading parameters to achieve that.
Thank you for your quick response.
Can you go a little bit more into detail what I have to do?
But good to know that there might be a way to solve the issue.
you can leverage custom sql technique
select distinct a.*, ifnull(a.date1,a.date2) as enhanced_filter
from table1 a
join (select max(date2) as max_date,min(date1) as min_date from table1) b
on (a.date1 between min_date and max_date) or (a.date2 between min_date and max_date)
now use the enhanced_filter as a regular date filter where start and to date can be given...
Thank you! I still don't really know how to do it.
Do you think you could attach the workbook where you have solved the problem?
My problem is, that I am not yet very familiar with the terms and functions that you referred to.
And Tharashasank Davuluru, I had already looked at this "How To". But because it is now about date parameters, I didn't manage to transfer it to my problem.
Attached is the workbook, essentially i have combined the distinct values
of start and end dates of 2 different columns in to one custom column and
used that as a filter so that start and end date can be used.
On Wed, Mar 9, 2016 at 2:26 AM, Adina Markowz <firstname.lastname@example.org>
Dynamic Date Parameters.twbx 1.2 MB
The above link helps how to get the data for specified period, you can enhance that logic for your requirement.
(Fixed :max(From parameter))
I am replying from Android, there is no curely parenthesis option so follow exact syntax.