Hello everybody,
I have a dataset on sales and want to sort this by brands. Additionally, I would be interested to find out the percentage of brands with sales <20 dollars / total number of brands. I have tried several formulas for calculated fields but they did not work.
I would really appreciate your help.
Thank you!
7 answers
Alexander Farr - Sorry, took me a while to get back to you. I think I was over thinking on this one. Here's what I did,
1) I created a dimension, that buckets Brands into 2 categories like so,
2) Then I create a another calc that does a DISTINCT COUNT of Brands.
3) I drop both these on view, and do a quick table calc of COUNTD(Brands) to show % of Total.
Is this what you're looking for?
Best,
Shiva.
