topic Re: Predefined Filter on Date field sorts Months wrong in ArcGIS Insights Questions

Predefined Filter on Date field sorts Months wrong

PaulCone2 — Thu, 03 Nov 2022 22:16:33 GMT

I have had a Predefined Filter on some pages for Filter by Month on a Date field. I noticed recently after upgrading to 2022.2 that the months are sorted wrong. I've removed the filter and added it back but they still sort wrong and even adding them one by one sorts them wrong. This looks like a bug was introduced with the Other Updates in 2022.2

PaulCone2_0-1667513678189.png

PaulCone2_1-1667513713278.png

PaulCone2_2-1667513739764.png

Re: Predefined Filter on Date field sorts Months wrong

Ian_Muehlenhaus — Fri, 04 Nov 2022 13:45:49 GMT

Hi @PaulCone2 ,

Thanks for your message and letting us know. I will make sure the dev team knows about this.

It appears it is defaulting to alphabetical order, which is correct for string data, but this is a Date field, so this is not definitely not ideal.

Sorry for the issue and thanks for letting us know!

Ian

Re: Predefined Filter on Date field sorts Months wrong

Scott_Aulen — Mon, 14 Nov 2022 19:30:30 GMT

@PaulCone2,

We're actively looking at a number of enhancements to our filters and this is one of them.

Did you say that this worked for you previously? I checked on 2022.1 and the behavior was the same and to my knowledge this has always worked as it currently does.

We definitely appreciate the feedback as it helps us prioritize development.

Re: Predefined Filter on Date field sorts Months wrong

PaulCone2 — Mon, 14 Nov 2022 19:50:39 GMT

It did, but we were running 2020.3.

Re: Predefined Filter on Date field sorts Months wrong

PaulCone2 — Mon, 14 Nov 2022 20:00:30 GMT

Also 2021.3.

Re: Predefined Filter on Date field sorts Months wrong

PaulCone2 — Tue, 10 Jan 2023 15:24:51 GMT

Was hoping this was fixed in 2022.3, but it's not.

Re: Predefined Filter on Date field sorts Months wrong

Ian_Muehlenhaus — Tue, 10 Jan 2023 16:11:42 GMT

Sorry we were unable to incorporate this enhancement in the latest release.

It always bums the Insights Team out when we hear a user is disappointed with how Insights does something. But I’m glad you let us know, because it also inspires our team to make the product even better.

Thanks for reminding us how important this feature is for your workflows.

I can’t change how Insights is right now but…

I can assure you that we are actively working on enhancing filters in ArcGIS Insights. (Key word: actively.) The future of Insights filtering is looking bright!

Thank you for using ArcGIS Insights and for reaching out on Esri Community to let us know how we can make Insights better for you.

Best,

Ian

Re: Predefined Filter on Date field sorts Months wrong

Eric_Castonguay — Thu, 27 Apr 2023 12:52:54 GMT

I was hoping I could use a work around with numbers and the month but it still uses string sorting which places 10, 11, and 12 ahead of 2, 3, and so on.

Eric_Castonguay_0-1682599641079.png

By adding a double hyphen to January through September this gets the list in the correct order, though it looks a bit messy.

Eric_Castonguay_1-1682599806121.png

I had to use the double hyphen since I include a single hyphen on my "All Months" category (advanced filter (Month <> "X"). Without this included you can use a leading month number and include a special character on 1-9.