topic Re: ArcGIS Hub Summary Statistic filter in ArcGIS Hub Questions

ArcGIS Hub Summary Statistic filter

ZoltanKovacs — Thu, 16 Apr 2020 11:50:27 GMT

Hi all,

I'm using Summary Statistics on my Hub page and would like to exclude a specific value (these values are coming from a domain list) using Filter by Attribute. There isn't much documentation on Filtering, so I was wondering if anyone has managed to set it up to exclude values? I've got like 20 different values in my domain (and it will expand further), so adding the other 19 values to the filter is not my ideal world...

I've tried the following so far:

<> Milepost

!= Milepost

NOT Milepost

NOT IN (Milepost)

These don't seem to work as I get 0 (zero) as result instead of 1582 (the correct count number without 'Milepost'). Any ideas on how to get this working would be very much appreciated.

Zoltan

Re: ArcGIS Hub Summary Statistic filter

Anonymous User — Thu, 16 Apr 2020 12:06:11 GMT

We don't yet support advanced querying. If you need a specific slice of data, best workaround I can offer is creating a feature service view that is filtered how you want....or embed a 1 widget ops dashboard (this is overkill--and watch your count of embeds on your site as it can harm performance)

This one is on the list to improve! Apologies it isn't as fully featured as it should be.

Re: ArcGIS Hub Summary Statistic filter

ZoltanKovacs — Thu, 16 Apr 2020 12:42:29 GMT

Hi Graham,

Thanks for the speedy reply. I haven't thought about FL Views, but I just gave it a go. Unfortunately the Summary Statistics seems to ignore the filter that is set and saved in the View and it still gives me the incorrect number - all counts including Mileposts...

Any thoughts?

Re: ArcGIS Hub Summary Statistic filter

Anonymous User — Thu, 16 Apr 2020 13:30:16 GMT

Can you send me the data item you're trying to use? If it's private do you mind sharing it to me in a group? My online username is ghudgins5

Re: ArcGIS Hub Summary Statistic filter

ZoltanKovacs — Thu, 16 Apr 2020 13:42:18 GMT

Hi Graham,

Unfortunately I cannot as this is a confidential project. However, I could share my screen to troubleshoot if that helps?

Re: ArcGIS Hub Summary Statistic filter

ZoltanKovacs — Thu, 16 Apr 2020 14:07:01 GMT

Graham,

I can replicate the same with different (test) data. I've just invited you to that group so you can have a look at the FL and the View too. Let me know you thoughts, but it may be (another) Hub bug.

Re: ArcGIS Hub Summary Statistic filter

Anonymous User — Thu, 16 Apr 2020 14:32:00 GMT

shoot you're right. that doesn't work as a solution here. I'm not able to get the issue you're having with filtering exact matches....i'll look into why the summary stat card isn't honoring view layers

Re: ArcGIS Hub Summary Statistic filter

ZoltanKovacs — Thu, 16 Apr 2020 14:40:40 GMT

That would be great, please let me know what you found. On top of that, the summary stats card doesn't allow you to add the same field with different values to the filter either, so I'm pretty much stuck here...

Re: ArcGIS Hub Summary Statistic filter

ZoltanKovacs — Tue, 21 Apr 2020 08:49:39 GMT

Hi Graham,

Did you have time to look into this yet? If not, please let me know and I'll raise it with Support. Many thanks!

Re: ArcGIS Hub Summary Statistic filter

Anonymous User — Tue, 21 Apr 2020 12:46:22 GMT

we're still working on it! feel free to log a case - we can get them hooked up on our side once it's logged.

Re: ArcGIS Hub Summary Statistic filter

ZoltanKovacs — Tue, 21 Apr 2020 13:02:31 GMT

Thank you, will do!

Re: ArcGIS Hub Summary Statistic filter

ZoltanKovacs — Fri, 24 Apr 2020 10:47:07 GMT

Anyone else running into this issue can refer to the below enhancement and bug logged by Support:

ENH-000130335: Customer would like a functionality of performing advanced query on filter by attribute in Summary Statistic Card of ArcGIS Hub.
BUG-000130340: Summary Statistic Card of ArcGIS Hub not honoring the filter set in the view layer.

Hopefully the bug gets fixed soon.

Re: ArcGIS Hub Summary Statistic filter

ZoltanKovacs — Tue, 21 Jul 2020 07:27:34 GMT

Hi Graham,

Do you have any update on when this is going to get fixed? Many thanks in advance.

Zoltan

Re: ArcGIS Hub Summary Statistic filter

Anonymous User — Tue, 21 Jul 2020 12:35:18 GMT

On the view front I apologize for not following up. There are actually two ways to define a view...one is secured at the service level and one is cosmetic (in that the item has the filter but the data is still showing all of the underlying data).

If you define your view layer at the service level (see screenshot), then the summary stat card honors the results:

If you define a view here, we still have the bug:

The bug is tricky because we have to do some appending of the "extra filter" to the filters in various features across the app. we're working on dataset pages first but it'll be some time before we can address.

Re: ArcGIS Hub Summary Statistic filter

ZoltanKovacs — Tue, 21 Jul 2020 12:59:33 GMT

Hi Graham,

That's very useful, many thanks!

Re: ArcGIS Hub Summary Statistic filter

NataliyaLys — Wed, 07 Oct 2020 16:24:16 GMT

Has this enhancement (

ENH-000130335: Customer would like a functionality of performing advanced query on filter by attribute in Summary Statistic Card of ArcGIS Hub.

) been logged in as an idea. If so I would like to add my vote to it. Please provide a link.

Thanks

Re: ArcGIS Hub Summary Statistic filter

NataliyaLys — Wed, 07 Oct 2020 16:55:57 GMT

Zoltan Kovacs‌ In your screenshot you have an option to 'Set View Definition' with additional drop down options? I don't have that option, how do I get to that?

Re: ArcGIS Hub Summary Statistic filter

ZoltanKovacs — Thu, 08 Oct 2020 07:18:57 GMT

Enhancements logged by Esri Support get the "ENH" number, thus are logged in Esri's system directly and not on the Ideas site. You can add your organisation to the list of affected customers if you email Esri Support and reference the above enhancement.

Re: ArcGIS Hub Summary Statistic filter

ZoltanKovacs — Thu, 08 Oct 2020 07:32:11 GMT

That's Graham's screenshot by the way. I had a look and it's not available for me either. The Help still refers the same method as in Graham's reply above, ~~so I assume it's a bug in AGOL? May be worth raising it with with Esri Support.~~

Update: It has been changed slightly since the screenshot was taken. You need to go to the item's page first, click on Create View Layer then you'll have the Set View Definition option available as in the screenshot above. I hope this helps.

Re: ArcGIS Hub Summary Statistic filter

LACountyCIO — Wed, 20 Dec 2023 23:50:16 GMT

Is there a timeline for advanced querying? It is limiting to not even have an "is not null" / "OR" options on this card.