Sum in Pie Chart Not Working

Question

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 · Answer

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.

Anonymous User · Answer

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 · Answer

Hi Ryan

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