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

Including blank values for a serial chart in Dashboard

AdrianWelsh

Hi, I am using the serial chart widget in a dashboard and while it is easy to bring in values of existing features, I want to show all in my domain, even if it is blank. That might not make sense.I'll try to include a screenshot.

In my two serial charts on the right, for the above one, I want to show the 'roadway design' and another bar, but that other bar needs to have zero (0) for its value. Same for the bottom chart - I want to add one more attribute with a zero value so users will know it's there. Is that possible?

It seems that I can add as many categories as I want but it the category has zero features, then it won't show. Am I missing a check box somewhere that says "show even if it has zero features"?

Thanks in advance. Tagging the dashboard mastermind Derek Law‌

Najděte více příspěvků označených jako

Accepted answers

All comments

CraigPrisland2

Thanks for the reply Adrian. I do have one additional question. I tried doing a test with some data add added the domains into a 'Blotter' field. These are non-spatial. I then used the 'Activity' field as my counting variable. This is the field that I have all my spatial data (my identifying data). However, my dashboard only seems to be using the 'Blotter' field and since I added each attribute in once, it is only displaying it as 1 in my chart. I cannot figure out what I am I doing wrong. Thanks again!

AdrianWelsh

Hi Craig,

In my non-spatial rows, the domains are still in the same field. All fields are valid data entry points so that you can put whatever and still have it behave with domain rules, if that makes sense. Each domain is on a new row. To illustrate, here is a screen shot of the bottom of my attribute table. The highlighted rows all have no geometry:

Let me know if you have more questions.

CraigPrisland2

Hi Adrian,

I am working through this same issue and am intrigued with your workflow. Could you please expand on where you entered your domains into the new (non-spatial) row? Are you entering all of your domain values into a single row or is each domain value in its own row?

Thanks,

Craig

AdrianWelsh

Alright y'all, I think I have solved my own problem with some creativity and without using JSON or other Arcade like coding.

In ArcGIS Pro, if I add an empty row at the bottom of my attribute table (without adding any geometry - by clicking "Click to add new row"):

I can populate that row with the values of my domain. Doing this, I can make every value show up in my attribute table, and then republish my map. Those values now exist without any polygon data.

Now, in order to make them show up in the Serial Chart on dashboards, I just tell it to do a count of my main identifying value (which for me is the "ownership number"):

And voila! I now have "zero" values for all the attributes I want to show in my serial chart!

I hope this helps some of y'all!

One thing to point out, I was using object_id as my counting variable. If I continued to use object_id, it would count all my records and I would not have zero values. It would look something like this:

KevinPiraino2

For anyone that is having a similar problem, I have found an additional minor workaround utilizing ArcGIS Arcade. As an FYI, this workaround builds a new table/featureset in Arcade and will remove any dynamic connectivity from the original data.

Create a new serial chart
Use the "Data expressions" section when choosing data
Build a new data expression
Access original data layer using "FeatureSetByPortalItem" function
Use "Filter" function to find records that match specific category criteria
Use "Count" function to create integer variable to count instances of records from step 5
Build JSON string of a blank featureset using the name of the categories and the count of records from step 6 to populate the JSON string.
Use JSON string from step 7 to create a new featureset using "FeatureSet" function
Build serial using new featureset

See attached images/code for the Arcade Expression and the configuration of the serial chart

ArcadeExpression.txt

SerialChart_config.png

lightning-talk-heath-kiefer.pptx

Esri Premium Support Program.pptx

Anonymous User

Hey Nate,

Sorry for the late reply. I am glad you were able to figure out your problem.

I implemented this solution directly to an indicator using the "advanced formatting" option. Deciding where to implement expressions to dashboards always depends on what function(s) you are trying to use and how you are trying to abstract your data. I was lucky and did not have to use any fancy expressions because indicators have advanced formatting built in. If your chosen data element does not have advanced formatting, you will have to program the data element from scratch using an expression written in Arcade.

It is important to note that "Arcade" is literally just javascript with an expanded library of functions. If one knows javascript, one basically already knows Arcade, it's just a matter of understanding and implementing the functions offered by the expanded library.

To hopefully help any users who may need assistance implementing DefaultValue, the exact code I used was this:

DefaultValue($datapoint["CUST_COUNT"], 'No Data')

As stated before, my indicator needed to display weekly customer counts. The data is uploaded by individuals/individual groups and thus there is noticeable margin of error at times. In the case of CUST_COUNT, this error would arise as a blank or "null" string entry in the .csv when there should be a zero integer.

DefaultValue works by checking a field of your choosing for null and blank entries and then returns a text string of your choosing upon encountering such an entry. It leaves "0" (zero integer) entries as is. All you need to do to implement the function is to insert the name of your field into square brackets with quotation marks as I did. After the comma, type what you want your dashboard element to display upon encountering a blank entry in quotation marks. It does not matter if you use single or double quotations for either/both inputs.

Hope this helps. Thanks Nate for your input!

-James

njennings

Hey James -

Did you use Arcade in a Web Map for the given layer style to allow for this or did you do it in the Bar Chart gadget on Ops Dashboard?

Figured it out.

Added the same function you did for the for the layer styling in the Web Map.
I also had to change the "null" label from "null" to "No Lamp Type" in my case.

I also had to choose a number field for my "count" statistic vs the "Lamp_Type" (string) field in my data.

Thanks for the post. This is lame that code is required for such things.

Thank you,

Nate

arade_expression.jpg

change_category_type_Null_to_No_Lamp_Type.jpg

change_statistic_to_number_field.jpg

5_Morgenstadt_Koeln.pdf

KundenVortrag_Hannover_Dorfentwicklung_Rheiderland_20160209.pdf

2_UseCase_Tourenplanung.pdf

AdrianWelsh

Thanks for the feedback. The idea is here:

https://community.esri.com/ideas/18658

small_halloween_mapmrker.png

DerekLaw

Hi Adrian,

Nice dashboard, thanks for sharing.

I've double checked with the Dev team and unfortunately, there isn't a workaround for what you want to render in the chart. Sorry. The charts in dashboard only show categories that have a non-zero value. Please submit an enhancement request on the ArcGIS Ideas site for ArcGIS Dashboards.

Hope this helps,

AdrianWelsh

Derek,

Thanks for the reply. This is the link for the web map:

https://www.arcgis.com/home/webmap/viewer.html?webmap=5fb6211052a5476c96d2dd412741563f

And this is the link for the dashboard:

ArcGIS Dashboards

The map is showing parcels in Utah that are going through the right of way process. They are signified by two categories, a "stage" and a "status" which are hierarchical. The map has two layers that are symbolized by these attributes - the parcels (called ownerships), which are larger land ares are symbolized by the stage (and only has like 5 colors). And then when you zoom in far enough, those turn off and the "takes" turn on which are symbolized by the "status" and has more than 5 colors (maybe like 15?). Both layers have basically the same fields as each other.

Anyways, the dashboard is getting a count of all the records that fall into a certain stage on one side and ideally, we wanted to show a bar graph (serial chart) of all the statuses on the other side, including zero values. Both these fields are in 'domains'.

I hope that makes sense.

Thanks!

DerekLaw

Hi Adrian,

If the attribute table does not have any data, then the serial chart can't display a "zero" value. Sorry.

Can you provide some more details/context on how the feature layer table is structured?

Připojte se k diskusi

Přihlášení členové mohou přispívat, sledovat aktualizace a další. Jste tu noví? Zaregistrujte si bezplatný účet.

Rychlé odkazy

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