topic Re: Sum for text values in Summary widget? in ArcGIS Dashboards Questions

Sum for text values in Summary widget?

RachelS — Tue, 04 Nov 2014 11:46:57 GMT

I have hundreds of text values categorised e.g. Car, Boat, Lorry, Motorbike etc.

I want users to be able to see a sum of these e.g. 65 cars, 98 Boats, 34 lorries, 150 motorbikes.

But the value field in the Summary widget only allows numeric values.

It is the same for barchart, histogram, pie chart, they all require numeric values.

Is there any way to summarise text values?

Thanks

Rachel

Re: Sum for text values in Summary widget?

StephenCox — Wed, 05 Nov 2014 14:17:17 GMT

I have the same issue!

Re: Sum for text values in Summary widget?

StephenCox — Wed, 05 Nov 2014 18:16:52 GMT

Rachel,

Try the Bar Chart Widget.

You can "Display feature counts as bars" under Display Type.

The Value Field can be set as a Text.

Re: Sum for text values in Summary widget?

RachelS — Thu, 06 Nov 2014 10:18:32 GMT

Perfect Stephen,

That worked out great.

You don't by any chance know how to get a relational table as a bar chart?

Thanks

Rachel

Re: Sum for text values in Summary widget?

MantasButrimavičius1 — Tue, 08 Mar 2016 09:46:03 GMT

Unfortunately, relational tables are still not available in Operations Dashboard. Cannot wait for it to be available!

Re: Sum for text values in Summary widget?

MantasButrimavičius1 — Tue, 08 Mar 2016 09:54:32 GMT

Stephen,

How about coded values with domains? Is there a way to use them as numeric values?

I also have a similar problem then I try to summarize information. For instance, I have field "Status" that can be populated with 0 (domain "is working") and 1 (domain "is not working"). I would like to count all records and records that only represents records with "is working" values.

So, the main problem is, that summary widget can only count all records in one field but it cannot separate these values to categories.