Sum fields for histogram

Q&A
,
1

I have a dataset that is structured like this:

image

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

image

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:

image

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?

2

Hi @jtroxel,
Welcome to the QuickSight community!
Currently, it is not possible to create a Histogram visual type for this.

Thanks and regards,
Biswajit Dash

1 Like
3

@Biswajit_1993 my mind is blown once again! thank you!

4

@Biswajit_1993 just closing the loop on this, i was able to generate the desired histogram by removing the sum() function from my calculated field and simply writing it out as a plain expression:

{Category1} + {Category2} + {Category3} + {Category4} + {Category5} + {Category6} + {Category7}

1 Like