-
1. Re: Treemap: filter differently on size and colours
Tracy RodgersNov 21, 2013 9:31 AM (in response to francescoemanuele.bucci)
Hi Francesco,
Welcome to the forums! Would you be able to post a sample workbook?
-Tracy
-
2. Re: Treemap: filter differently on size and colours
francescoemanuele.bucci Nov 22, 2013 3:15 AM (in response to Tracy Rodgers)Hello tracy, if for sample you mean a screenshot, here we go:
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.
-
3. Re: Treemap: filter differently on size and colours
Jonathan DrummeyNov 22, 2013 6:26 AM (in response to francescoemanuele.bucci)
It looks like Rank is already calculated, so try COUNT(IF [Rank] <= 100 THEN 1 END) for Color.
-
4. Re: Treemap: filter differently on size and colours
francescoemanuele.bucci Nov 22, 2013 6:37 AM (in response to Jonathan Drummey)This works, apparently! Thank you very much.
Actually what I was missing is the correct syntax. I'm pretty new with Tableau.
-
5. Re: Treemap: filter differently on size and colours
Jonathan DrummeyNov 22, 2013 7:26 AM (in response to francescoemanuele.bucci)
You're welcome, and welcome to the Tableau community!
On Fri, Nov 22, 2013 at 9:38 AM, francescoemanuele.bucci <
-
6. Re: Treemap: filter differently on size and colours
francescoemanuele.bucci Nov 22, 2013 11:25 AM (in response to Jonathan Drummey)Thank you