Hi I am trying to get a histogram chart on Tableau to work and am coming up with an aggregation error. I've searched through the forum and haven't found the answer. Sorry if this has already been posted.
I would like the histogram to show a total count of Total Purchase by Brand. For example, I would like the chart to show me how many times 98 units of Tylenol were purchased. Followed by how many times 76 units of Tylenol were purchased and so on for each Brand.
When creating the histogram, the units sum up with the totals found from the previous Brand. For example, if the histogram started with Tylenol, followed by Generic, Tylenol would have a count of 2 for Total Purchased equaling 98. Generic would then have a count of 3 (when it should be 1) for Total Purchased equaling 98.