idea Time filter for date range Insights in ArcGIS Insights Ideas

Time filter for date range Insights

pahli — Tue, 16 Jul 2024 16:53:03 GMT

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.

Re: Time filter for date range Insights

AkshayHarshe — Fri, 19 Jul 2024 15:05:53 GMT

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.

Re: Time filter for date range Insights

pahli — Fri, 02 Aug 2024 06:42:31 GMT

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..

Re: Time filter for date range Insights

AkshayHarshe — Thu, 22 Aug 2024 20:35:34 GMT

@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.

Re: Time filter for date range Insights

pahli — Mon, 02 Sep 2024 14:58:45 GMT

Hi @AkshayHarshe ,

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

Re: Time filter for date range Insights

AkshayHarshe — Wed, 04 Sep 2024 14:25:40 GMT

@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.

Re: Time filter for date range Insights

pahli — Thu, 05 Sep 2024 13:22:09 GMT

@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.