Welcome to the forums! Would you be able to post a sample workbook?
Size and colour follow the same measure (CNT(Rank)) but I would like that the colour would do something different CNT(Rank(1:100)), just count how many times the country appears in the first 100 positions.
Is it possible? It would be easily possible editing my spreadsheet actually, I just add a column and I put all 1 between 1 and 100 and I leave empty (or 0s) to all the others. But if for this dataset is easy, it could be useful to know how to do it in Tableau, if it is possible.
It looks like Rank is already calculated, so try COUNT(IF [Rank] <= 100 THEN 1 END) for Color.
This works, apparently! Thank you very much.
Actually what I was missing is the correct syntax. I'm pretty new with Tableau.
You're welcome, and welcome to the Tableau community!
On Fri, Nov 22, 2013 at 9:38 AM, francescoemanuele.bucci <