topic Re: Filter Widget - Filter Date Only Field by Quarter in ArcGIS Experience Builder Questions

Filter Widget - Filter Date Only Field by Quarter

Teresa_Blader — Thu, 05 Feb 2026 18:53:20 GMT

Is there any way to set up a Quarter Filter in Experience Builder in either the Filter or Query widget?

Rules: no data expressions with a new featur layer - I need to still edit the original table in ExB, and I don't want to add a quarter field behind the scenes or something. No developer edition. And without having to create like a unique quarter year combo like Q1 2026, Q2 2026 because there are 6 years of data and that would be 24 filter buttons.

This doesn't seem possible. The only thing I saw was [Date is in "this quarter"]. But no other options besides "this quarter" or "this year" etc.

Goal: Group Filter that applies to a date only field in a few tables, where users can pick the quarter and the year

I did this for a summary table with a data expression feature layer in ExB and added Q1, Q2, to fields - but I want to have buttons like this to filter by quarter without doing a data expression. This is the kind of stuff that is SOOO easy in Excel but SO HARD in ArcGIS. 😭

Re: Filter Widget - Filter Date Only Field by Quarter

Neal_t_k — Thu, 05 Feb 2026 19:16:08 GMT

Can you just build your SQL for the filters to have conditions for all six years with an "or"? This way the it will filter anything in Q1 for example and then your year will be filter by the year filter.

Re: Filter Widget - Filter Date Only Field by Quarter

Teresa_Blader — Thu, 05 Feb 2026 20:10:59 GMT

Thanks! I didn't think of that. That has potential (though it is PAINFUL to create) and not an option for group filters 😭 I have two tables I need to filter with the "Q1" button

There doesn't seem to be a way to add multiple clauses to a set of group filters... or am i missing something??

Re: Filter Widget - Filter Date Only Field by Quarter

Neal_t_k — Thu, 05 Feb 2026 20:33:43 GMT

@Teresa_Blader its been a bit, but I think you have to set it up as a group filter.

Edit: Which might mean redoing the SQL.

Edit 2: Appears multiple SQLs aren't support in group filters...

Re: Filter Widget - Filter Date Only Field by Quarter

Teresa_Blader — Thu, 05 Feb 2026 20:23:56 GMT

I'm pretty comfortable with the group filter... but there's no multiple clauses option once into the SQL expression box. 😭

Re: Filter Widget - Filter Date Only Field by Quarter

Neal_t_k — Thu, 05 Feb 2026 20:39:18 GMT

@Teresa_Blader I just saw that as well, see my "Edit 2" in the post above. That's all I have, besides the stuff you said you don't want to do.

Re: Filter Widget - Filter Date Only Field by Quarter

NicoleJohnson — Fri, 06 Feb 2026 13:50:38 GMT

@Teresa_Blader, if you're only interacting with this data in tables (and not a map), you could add the data via Arcade and make your quarter field there. The field would exist "virtually" and not be something you have to update. I believe this capability is only available in ArcGIS Online right now, maybe Enterprise 12.0 but I'm not 100% sure.

Here's an example with the Living Atlas wildfire current incidents layer.

(To add data via Arcade, go to the Data tab, click Add data, and the option will be at the bottom.)

var p = Portal('https://www.arcgis.com') // Get wildfires layer var fs = FeatureSetByPortalItem(p, 'd957997ccee7408287a963600a77f61f', 0, ['FireDiscoveryDateTime'], false) // Set up a dictionary to hold the new "quarter" field var newDict = {fields: [ {name: 'FireDiscoveryDateTime', alias: 'Fire Discovery Date Time', type: 'esriFieldTypeDate'}, {name: 'Quarter', alias: 'Quarter', type: 'esriFieldTypeString'}, {name: 'Year', alias: 'Year', type: 'esriFieldTypeSmallInteger'} ], geometryType: '', features: [] } // Go through the wildfires data and determine quarter for (var i in fs){ var fireMonth = Month(i.FireDiscoveryDateTime) var fireQuarter var fireYear = Year(i.FireDiscoveryDateTime) When( (fireMonth == 0 || fireMonth == 1 || fireMonth == 2), fireQuarter = "Q1", (fireMonth == 3 || fireMonth == 4 || fireMonth == 5), fireQuarter = "Q2", (fireMonth == 6 || fireMonth == 7 || fireMonth == 8), fireQuarter = "Q3", (fireMonth == 9 || fireMonth == 10 || fireMonth == 11), fireQuarter = "Q4", "") Push(newDict['features'], {attributes: {FireDiscoveryDateTime: i.FireDiscoveryDateTime, Quarter: fireQuarter, Year: fireYear}}) } // Create a featureset from the now-filled dictionary var new_fs = FeatureSet(newDict) return new_fs

(you'll want to format your years better, I'm just being lazy)

Re: Filter Widget - Filter Date Only Field by Quarter

Teresa_Blader — Fri, 06 Feb 2026 16:56:43 GMT

Thanks for responding!! I've done that for some other tables in ExB, but I need these two tables to be
1. hooked to the map
2. editable in the table
So it can't be an Arcade feature layer. 😭

You can't do editing in the table there correct with the arcade data expression layer, right?? I couldn't get it to enable editing - the check box is greyed out.

From my arcade data expression layer... which is exactly what I want for non-arcade layers:

The only thing I've come up with for still being able to edit:

But the queries are so chaotic:

Re: Filter Widget - Filter Date Only Field by Quarter

NicoleJohnson — Fri, 06 Feb 2026 17:09:50 GMT

Oh no! Sorry about that. Yeah, I don't think an Arcade layer is going to work for you then.

Re: Filter Widget - Filter Date Only Field by Quarter

Neal_t_k — Fri, 06 Feb 2026 18:04:14 GMT

@Teresa_Blader I had one more thought: You could try the select widget on one table and then a layer action on the second table. Playing around a little bit I was able to select on two tables that way, but couldn't get the layer action filter to work quite right as you describe, but not using your data so you may have some luck with that, worth a shot to look at.

Re: Filter Widget - Filter Date Only Field by Quarter

JeffreyThompson2 — Fri, 06 Feb 2026 18:11:52 GMT

The next ArcGIS Online update should be sometime this month and it includes a Date Filter Widget. So maybe a built-in solution is coming soon?
https://community.esri.com/t5/arcgis-experience-builder-blog/arcgis-experience-builder-2026-roadmap/bc-p/1682677#M1167

Re: Filter Widget - Filter Date Only Field by Quarter

Teresa_Blader — Fri, 06 Feb 2026 19:06:29 GMT

Well that's exciting! I'm also waiting on the copy and paste so maybe quarter 1 will be a home run for both!

🤞

Re: Filter Widget - Filter Date Only Field by Quarter

Neal_t_k — Fri, 06 Feb 2026 21:15:37 GMT

@Teresa_Blader ...One more thought: Have 5 sets of tables each on a separate page, 1 everything, 2 filtered to all Q1, 3 filtered all Q2 etc. Then have your set of buttons switch to the pages with the corresponding quarter tables.

Re: Filter Widget - Filter Date Only Field by Quarter

Teresa_Blader — Fri, 06 Feb 2026 21:20:06 GMT

Oh sure, that'd feel probably similar to an excel sheet with each quarter on a new sheet like they had before ExB

Re: Filter Widget - Filter Date Only Field by Quarter

Neal_t_k — Fri, 06 Feb 2026 21:43:45 GMT

I think you could set it up with buttons and could approximate the feel of a filter.

Re: Filter Widget - Filter Date Only Field by Quarter

Teresa_Blader — Fri, 27 Feb 2026 20:20:45 GMT

It looks like the new date filter isn't really as expansive but is mostly just a calendar selector. Which is nice, but it didn't expand any of the date options in the current filter, so still no simple way to set up quarter filters. Shucks.