Pie Chart Operations Dashboard

[Miguel-Fernandez]

Hello all,

I am working on creating my first dashboard in AGOL and I'm wanting to filter my data to create three slices. I have a field called avg_daily_boardings associated with our system's bus stops and I'm hoping to use three filters:

avg_daily_boardings   equal   0

avg_daily_boardings   between   0.01 and 4.99

avg_daily_boardings   greater than or equal to   5

The end result I want is three slices that show how many bus stops are in each category. Is this possible?

[AdrianWelsh]

Miguel,

You should be able to do this. It's a simple filter that you would create for each of those categories within Ops Dash. Have you tried it yet?

Here is an article on how to filter your data

Filter data—Operations Dashboard for ArcGIS | ArcGIS 

tagging:

Operations Dashboard for ArcGIS‌

[Miguel-Fernandez]

I think I might have to do what Katherine suggested. When I try to use a filter for a range of values, I get a slice for each value, see attached image. 

[Katie_Clark]

Hmmm...my first thought would be to create a new field in the feature layer and use the field calculator to do something like assign a value of 1 if avg_daily_boardings = 0, a value of 2 if avg_daily_boardings   between   0.01 and 4.99, etc. Then create the pie chart based on this new field and change the labels under the "Slices" tab when configuring the dashboard to make the pie chart look like how you want the end users to see it.

I'm new to Ops Dashboard as well, so maybe someone else has a more efficient approach?

[AdrianWelsh]

Hmm, after looking at it more, it doesn't seem to be as easy as just filtering the data. I think I would be against a new data field just for the sake of showing the same data. I wonder if you could make a custom expression in ArcGIS Arcade and then just display that arcade expression field. That might work better since you wouldn't have to create a new field:

Use Arcade Expressions to Map Your Ideas 

[Miguel-Fernandez]

Okay, I'll have to give that a try in the morning. Thanks for your help.

[Miguel-Fernandez · Accepted solution]

I ended up making a new field called Shelter Requirements because that's what I was trying to show with those values. I used a When() statement to calculate the values for the new field and it gave me what I wanted. Thanks for all the help!