Sum for text values in Summary widget?

5157
5
Jump to solution
11-04-2014 03:46 AM
RachelS
Occasional Contributor III

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

1 Solution

Accepted Solutions
StephenCox
New Contributor II

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.

View solution in original post

5 Replies
StephenCox
New Contributor II

I have the same issue!

StephenCox
New Contributor II

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.

RachelS
Occasional Contributor III

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

0 Kudos
MantasButrimavičius1
Occasional Contributor II

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

MantasButrimavičius1
Occasional Contributor II

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.

0 Kudos