I'm trying to see if a project idea is feasible by using Dashboards or Experience Builder. I have a spreadsheet (that can be a database) containing different construction projects. The dataset looks like: CompanyAreaMetric ValueABC CoCA4F CorpCA2MomcorpNY8F CorpCA7MomcorpNY1 What I'd like to do: build several dropdowns allowing a user to select: * Company 1 (say, ABC Co) * Company 2 (say, F Corp) * An area (say, CA) And return an average of the metrics for Company 1 and Company 2 in the selected area. At this point, I just want to see if this is possible / feasible using AGO tools. Thanks a ton for your help!

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Return values based on SQL queries and dropdowns?

DrewPhillips3

I'm trying to see if a project idea is feasible by using Dashboards or Experience Builder.

I have a spreadsheet (that can be a database) containing different construction projects. The dataset looks like:

Company	Area	Metric Value
ABC Co	CA	4
F Corp	CA	2
Momcorp	NY	8
F Corp	CA	7
Momcorp	NY	1

What I'd like to do: build several dropdowns allowing a user to select:

Company 1 (say, ABC Co)
Company 2 (say, F Corp)
An area (say, CA)

And return an average of the metrics for Company 1 and Company 2 in the selected area.

At this point, I just want to see if this is possible / feasible using AGO tools.

Thanks a ton for your help!

Vind meer berichten getagd met

Accepted answers

JonathanMcDougall

@DrewPhillips3

Basically, yes (and I'm hope I'm close to being right when saying this).

I've created a rough, and I do mean rough, example for you.

I took your data above, created a table, brought it into ExpB, created simple views for each of the filters (so, just two views), created the filters referring Filter 1 to View 1 etc, and added Data Connected text boxes for the output, each text box containing the appropriate expression.

https://experience.arcgis.com/experience/438103e6c4c546338dd42aa516d27506/

As said, it's rough, but may help you with ideas.

All comments

DrewPhillips3

I'm going to reply to myself and say that I found the issue! In the text box pane, I was choosing the "Selected Features" option. I assumed that this meant that selected == filtered, which is not the case. I changed the checkbox to "Default" and it worked.

To have another section with another view doing the same thing for different queries, do I have to upload the data again? I'm having trouble ensuring that the queries result in different views.

image.png

GISQuickTip_ResultsWindow.pdf

DrewPhillips3

I'm getting close to figuring this out... From your incredibly helpful advice, I have 2 filters (for one company) that pass their queries to a table that shows selected values. These widgets live in a view. But I'm still struggling with getting the text box to show the dynamic values that I want. It seems like the settings I've chosen would work... but I can't figure it out! I must be missing something related to views...

image.png

architecting-the-arcgis-platform.pdf

JonathanMcDougall

@DrewPhillips3

I'll take some screenshots and post up here a wee bit later. I'm in the UK so it's time for dinner 🙂

Glad to be of help.

DrewPhillips3

That's amazing! You really went above and beyond.

How do you create a view, though? The big issue I kept running into was being unable to get text boxes to show data from JUST 1 filter set if that makes sense.

JonathanMcDougall

@DrewPhillips3

As said, it's rough, but may help you with ideas.

Doe mee aan het gesprek

Aangemelde leden kunnen berichten plaatsen, updates volgen en meer. Nieuw hier? Registreer een gratis account.

Snelle Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.