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; } } }

Community Analyst Reports Issue - Only able to work with three of the fields within my imported table

MichaelGeorge1

Hey guys, I’m having an issue building a report within ArcGIS Community Analyst and I was wondering if anyone could help me figure out what’s going on.

For some context I am using a layer with the following fields to build my report:
GIS_ID, StreetName, StreetSegment, FromStreet, ToStreet, PavementTypeLong, Length, Miles, Width, Owner, ClassCodeLong, SquareYards, BenefitValue, Repair Method, AdjustedRSR, Cost

Of these fields I am looking to build a report that only includes the following subset of fields:
Miles, SquareYards, Repair Method, AdjustedRSR, Cost

Within the Reports section of Community Analyst however I am only able to work with three fields within my table:

Length, SquareYards, Cost

(See attached screenshot)

Is there a reason that the platform is not showing all of my fields, and is there a way to fix this?

Commmunity_Analyst_Report.PNG

RonaldHaug_0-1723737244904.png

Trouver plus de publications taguées avec

Accepted answers

Fasil

Hi @MichaelGeorge1,

To see the "Map Layers" option in the data browser, you will need to add the layer to the map as you can see below.

In addition, the layer added must support feature query. For example above, notice I can click on one of the features and see the attributes list.

Thanks,

Fasil T.

All comments

Fasil

Hello @MichaelGeorge1 ,

From your screen shot, it looks like you are creating a custom data from your layer first and then use those variables to build your report.

As documented in the help doc for creating custom data, only numeric attributes are supported in this workflow. I recommend checking your layer and make sure the fields you want to use are all numeric.

If you need to use a combination of string and numeric fields, please use the Map Layers option by simply adding your layer to the map and selecting the variables from the data browser from this category.

The limitation with this approach is that you must run your report by selecting the features from the map where the attributes are coming from. Otherwise, you will get N/A values if you try to run the report on unrelated sites. I've documented some best practices in this blog that you might find helpful. The blog is written for infographics but section 2. Map Layers applies for building reports as well.

https://community.esri.com/t5/arcgis-business-analyst-blog/best-practices-when-sharing-and-running/ba-p/1062670

I hope this helps.

Fasil T.

MichaelGeorge1

Hello Fasil,

Thank you for this detailed reply and these useful tips. I read through your blog and am confused about how to use the "Map Layers" option. I am trying to build a new report and I do not see the "Map Layers" icon within the Select Variables tab within the report builder. Attached is a screenshot of what I am seeing on my end.

Do I need to be using a specific report template in order to see the "Map Layers" option appear?

Community_Analyst_missing_map_layers.PNG

Fasil

Hi @MichaelGeorge1,

To see the "Map Layers" option in the data browser, you will need to add the layer to the map as you can see below.

In addition, the layer added must support feature query. For example above, notice I can click on one of the features and see the attributes list.

Thanks,

Fasil T.

Rejoindre la conversation

Les membres connectés peuvent publier, suivre les mises à jour, et plus encore. Nouveau ici ? Inscrivez-vous gratuitement.

Se connecter
S'inscrire

Liens rapides

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