Dynamically select date filter offset

Hi Michal,

Thanks for reaching out. This is indeed possible. What you'll want to do is:

1. Drag your Date filter in twice.

2. Click Advanced Settings under the Filters section

3. Configure the filters like so:

Leaving first date field as User Prompt and setting operator as 'Less than or equal to', then configuring second fields' operator as 'Link to Filter'

4. Configure 'Link to Filter' options:

Here's an example where you can see the 3 results from 5 days in our Tutorial Data and that the SQL query is correct:

I dynamically chose the date you see in the date picker and it's returning values from 26/10 through 31/10.

Please let me know how goes and if you have any other questions on this.

Regards,

Mike

Hi Mike,

Thank you for your answer, but we would like that the offset will be dynamic.

we would like that the user will be able to choose the offset in the main report - "User prompt".

is it possible?

Thank you,

Michal

Hi Michal,

Ah, I thought you meant dynamically choosing the date via User Prompt filtering for a configured offset, I didn't realize you were looking for the Offset value itself to be dynamic. This is not possible. I do think it a pretty cool idea though and would be happy to submit an Idea ticket on your behalf and submit an enhancement request to the dev team for further consideration. Would you like me to go ahead and do that?

Regards,

Mike

Yes, i will love to.

Thank you,

Michal

Hi Michal,

For those coming across this Idea item, to put this most succinctly, the idea is to be able to configure the Dynamic Date dynamically:

As of now this has to be hardcoded in the Filters' Advanced Settings section.

I've gone ahead and submitted an enhancement request for this. Any potential updates regarding this will be posted here.

Regards,

Mike