I believe the measure you need to add is 'Number of Records' in order for it to give you a '1' where you currently have 'ABC' in your table. Once you do this, you can also Count(Number of Records) to tell you how many records are in each category. If account ID is unique, 'Number of Records' should basically be equal to 1 for each row of data, so if you sum or count that, it will give you a total for another dimension.
Does that help?
Thanks for reaching out Kaylan. Unfortunately, Number of Records gives me the same results.
It's all about the level of detail in your view. In your table you have the category dimension in your view so it forces Tableau to aggregate down to that level of detail. In the bar chart view there is NO dimension category in the level of detail of the view so everything is aggregated together. What is it you are trying to do with the bar chart?
The category dimension is also on the bar chart. I'm trying to find the number of records (or count of Account IDs) in each bucket of daily actions (10-19, <10, etc. The way I'm interpreting the problem is that when I put number of records in the view, it is aggregating all daily actions so that everything falls into the biggest bucket, instead of calculating the daily actions per record and then giving me the number of records in each category. I just can't figure out how to get it to do the latter.
For reference, I used a calculated fields to create groups based on the number of daily actions:
IF [Daily Actions] < 10 THEN "1-10"
ELSEIF [Daily Actions] < 20 THEN "11-20"
The formula in my original post is the calculated field I used to create [Daily Actions].