Sum in Pie Chart Not Working

[Anonymous User]

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?  

 

[DIONYSIOSKERASIDIS]

Hi Ryan 

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

[Anonymous User]

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.  

[DIONYSIOSKERASIDIS]

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.