Hi - I couldn't exactly decide how to title this but...
I have a bunch of orders that I want to plot on a map to indicate where all of our <$99 sales are coming from and another map indicating where our $99+ sales are coming from. So essentially a histogram but in map form. However, when I remove the Order ID granularity from my row shelf all of my individual sales get summed together and now the count of <$99 sales is incorrect. I'm wracking my brain because this seems like an obvious task, but for some reason can't seem execute it.
How do I tally <$99 individual sales at the unique ID row level (without breaking my data out by Row ID)? i.e. if I have ten $50 purchases, how do I get a count of 10 rather than a result of zero because Tableau summed purchases to $500.
Again this feels painfully obvious, but I'm just not connecting the dots right now. Thanks in advance!
- Krista
Yours is definitely doing what I want, however "Number of Purchases" in my actual workbook (not the sample I sent you) is a calculation = CountD(OrderID). So because this is already an aggregate, the Sum([Number of Purchases]) from your Total Purchases calculation isn't valid.
