Hello Tableau Community:
I am still quite fresh with Tableau and I think I might miss something for this frequency analysis. I would like to create a frequency Bar chart for the new aggregated calculated field " OrderCount Group" . Basically, I would to know how many customers for each OrderCount Group. The problem here is that OrderCount Group values are calculated by the Order Count. Could you please help to share any idea on how to create this kind of frequency bar chat for OrderCount Group? This is also like to use the results of table calculations as a new data source for another worksheet? Thanks very much!
IF COUNT([Count Order]) >=15 Then "More than 15"
ELSEIF COUNT([Count Order]) >=10 Then "More than 10"
ELSEIF COUNT([Count Order]) >=5 Then "More than 5"
ELSE "Less than 5"
END
Thank you so much, Kevin! This is what I want. But I have a follow-up questions: After I create the frequency table for OrderCount Group, I also need to add several filters, such as region and Category. And I hope the Order Count group values will be automatically updated when I use different filters, but it could not. It only works for "segment".
Could you please share any ideas on how to do that? Thanks very much!
