I have a dataset that is structured like this:

I need to tally the number of each category that has a value of 1 for each row like this:

i want to then plot the “Totals” field as a histogram to see the frequency distribution of total categories across all “Companies”.

My calculated field is structured exactly how you would calculate this in excel and i can verify that the column data types are all integers:

sum({Category1} + {Category2} + {Category3} + {Category4} + {Category5} + {Category6} + {Category7})

However, when i try to plot this calculated field as a histogram, i get the following error:

I am not using SQL and this is a static, csv dataset so this error is especially confusing.

Does anyone know what the issue may be?