Finding mode of dimension then count of mode value within that dimension
Hopefully, this isn't a repeat question. I've searched pretty extensively on the forums and couldn't find what I needed.
Basically, I have a straight table of customer IDs with some high-level metrics associated with them, and one of the things I'm trying to calculate is "favorite brand" and "count of favorite brand pruchases". I've found that I can find "favorite brand" with the following formulas:
FirstSortedValue(distinct brand, -purchase_id)
The only thing I can't come up with is a count of the mode (brand) value within a customer ID. Here's what I've tried: