Dashboard count inside field

1385
13
11-12-2018 05:41 AM
EricS
by
Occasional Contributor

I need to add all the numbers in one field to get a total.  I dont see where I can do that.  It only does an occurrence count. 

example

interactions 

4

2

6

Need my dashboard count to show 12 for adding all the numbers from field interactions not that there were 3 occurrences

0 Kudos
13 Replies
MitchHolley1
MVP Regular Contributor

How are you trying to display this count?  In a chart?  In a gauge?  Please elaborate on the question and give as much detail as possible.

0 Kudos
EricS
by
Occasional Contributor

I am using an indicator

0 Kudos
MitchHolley1
MVP Regular Contributor

Use the 'Sum' statistic method.

0 Kudos
EricS
by
Occasional Contributor

When I select SUM I get a "No data" on my indicator

0 Kudos
MichaelVolz
Esteemed Contributor

Is the data field that you are trying to summarize Numeric?

0 Kudos
EricS
by
Occasional Contributor

yes it is

0 Kudos
EricS
by
Occasional Contributor

Hi Michael

Is there a way to get the sum of the numbers inside the field?

0 Kudos
MichaelVolz
Esteemed Contributor

Did you try using Developer Tools in the web browser to see if any errors were being thrown?

I asked if it was numeric as you can store numbers in a text field, so it would appear on the surface to be a numeric field.

What kind of numeric field are you using (short integer, long integer, float)?

0 Kudos
EricS
by
Occasional Contributor

I am using long integer

0 Kudos