Time filter for date range Insights

[pahli]

We have a table with historical data where each row has 2 date fields for begin_date and end_date. These two date fields represent the date range during which the records are valid. To find all data that are valid at a specific date only records whose begin_date is before the specific date and whose end_date is after it may be selected.

Unfortunately in Insights it is not possible to configure a time filter to get all datasets that are valid at a specific date.

It would be very helpful and would significantly reduce the amount of data to be analyzed in Insights if the time filter widget would support this query.

[AkshayHarshe]

Hi @pahli 

The time filter is desined to create filter a date range. What you need is a an advanced filter operation.

You can use Advanced filter on Dataset, Cards or with Filter widget to create something like DATEDIF(Start_Date ,DATEVALUE("MM-DD-YYYY"), "D") < 0 AND DATEDIF(End_date,DATEVALUE("MM-DD-YYYY"), "D") > 0 to get the records that you want.

Also, the filter widget (formerly predefined filter) is desined to work on a single dataset and downstream cards created from them. You will need to create one for each dataset. 

[pahli]

Hi @AkshayHarshe ,

thank you very much for the comment and your suggested solution.

Unfortunately advanced filter can only be modified by the creator of the workbook. In our project, users should be able to select different points in time to compare the results. That's why we wanted to use a widget so that users can interact..

[AkshayHarshe]

@pahli 

Will the Advance filter inside filter widget work for you? Or do you need your viewers to change the advanced filter? Unfortunatly that is not possble and by design.

[pahli]

Hi @AkshayHarshe ,

advance filter didn't work for us. The viewers should be able to change the date value.

[AkshayHarshe]

@pahli sorry to hear that, I don't have any other workarounds at the time.  This is fairly a niche scenario, that said, I will bring this up to our team and ask if there is something that can be done. 

[pahli]

@AkshayHarshe thank you for your hints. Currently we are using a DB-View to create datasets for each day or month, but it generates very large datasets.