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?
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.