Select to view content in your preferred language

How to count the parcels and show on the map in EB (AGO)?

254
5
4 weeks ago
Labels (1)
Almaz_Naizghi
Emerging Contributor

Hello,

I am new to Experience Builder (EB) and would like to learn more stuff.

There is ongoing survey that I manage, and the canvassers have been visiting the parcels several times. So, I would like to show a list of parcels and a count (number of visits) for each parcel. The feature layer has thousands of records. I am creating a monitoring dashboard in EB and how can I do like the screenshot below? But not only the top 10; I need to show all parcels which have 2 or more visits in descending order. My second question also when I click the parcel from the list, how can I show it zoom in on the map?

Almaz_Naizghi_0-1757342717223.png

Thanks in advance!

 

0 Kudos
5 Replies
JeffreyThompson2
MVP Frequent Contributor

Let's set up a Data View, display it in a List or Table Widget, and set up an Action.

  1. Set up a Data View.
    1. Click the three circles in the left side panel.
    2. Find your data in the list of data sources. You may need to click on the name of your map first.JeffreyThompson2_0-1757345519504.png
    3. Select Create A View.
    4. Now Add a Filter where Count Is At Least 2.
    5. Go to the Sort Tab and press Add A Sort Field.
    6. Sort by Count and click the bar graph thing to make it Descending.JeffreyThompson2_1-1757345779107.png
    7. Apply Changes.
  2. Display it.
    1. Add a List or Table Widget. It's up to you to decide what fits better for your data.
    2. Select your data and use the dropdown menu to select the Data View you just made.JeffreyThompson2_2-1757345940413.png
  3. Set up an Action.
    1. Go to the Action Tab and select Add A Trigger.
    2. Select Record Selection Changes > Map > Zoom To.JeffreyThompson2_3-1757346052891.png
GIS Developer
City of Arlington, Texas
0 Kudos
Almaz_Naizghi
Emerging Contributor

Thank you for your time to put this detail step by step process!

I followed your instructions, and it seems to work for me. The only question I still do have is how to make the higher visits in a descending order in the list for the number of visits? Below is what I have got currently.

Almaz_Naizghi_0-1757362554041.png

I think I missed the following step, and I don’t know how to do it.

“4. Now Add a Filter where Count Is At Least 2.”

Below is what I see in the filter option:

Almaz_Naizghi_1-1757362617975.png

Thank you so much!

 

 

0 Kudos
JeffreyThompson2
MVP Frequent Contributor

JeffreyThompson2_0-1757363359746.png

Did you do the Sort on the Sort Tab?

GIS Developer
City of Arlington, Texas
0 Kudos
Almaz_Naizghi
Emerging Contributor

Yes I did, as you can see my results in the list for the parcels are in descending order. My only issue is the count for the number of visits. 

Below is my dynamic content: 

Almaz_Naizghi_1-1757364009768.png

And, here is my expression 3.

Almaz_Naizghi_2-1757364358128.png

 

 

0 Kudos
JeffreyThompson2
MVP Frequent Contributor

It looks like you do not have a field in your data that contains the count. Maybe there is a way to make this all work without one, but it's going to make things much easier if you redesign your data to include a count value.

GIS Developer
City of Arlington, Texas