Sum in Pie Chart Not Working

245
3
10-19-2021 11:08 AM
Labels (1)
by Anonymous User
Not applicable

I am creating a fairly simple Pie Chart. I'm using the "Categories from Fields" Option because I have 4 fields that have either a 0 or 1.  I'm trying to create a chart that sums within each field.

When I "show data table" I see all the values as they should be, all "0" or "1".  But when I choose Sum for the statistics I get the helpful, "cannot access" data error.  If I choose any other statistic type, it works.  Is this sum sort of bug?  

 

0 Kudos
3 Replies
DIONYSIOSKERASIDIS
New Contributor III

Hi Ryan 

 

that is probably because you field is string type not a number. Sum will sum up number field types only.

0 Kudos
by Anonymous User
Not applicable

It's definitely a number field, hence being able to do all the other statistics.  Does it need to be a certain number type?  It's a double now.  

0 Kudos
DIONYSIOSKERASIDIS
New Contributor III

Hi Ryan 

 

apologies i didnt read your original post carefully. (obviously you cant even pick the field if its not number) One thing i did when i had little problems like that was to re share my service, overwrite the old one, it worked for me in the past.

0 Kudos