4 Replies Latest reply on Dec 20, 2013 4:26 PM by Phillip Burger

    Order in a Treemap

    Vinod Tirupati

      Hi all..

      I have a Treemap showing 4 different bins. Right now the order in which these buckets appear seems to be based on the size of population in each of the buckets. Is there a way in which I can fix the order so that, irrespective of the size of population in each bucket, the order never changes when I refresh my data?

      Thanks,

      Vinod.

        • 1. Re: Order in a Treemap
          Tracy Rodgers

          Hi Vinod,

           

          Have you tried sorting the dimension? Right click on it and select Sort... then sort however you'd like to see it.

           

          Hope this helps!

           

          -Tracy

          • 2. Re: Order in a Treemap
            Jonathan Drummey

            Hi Tracy,

             

            I haven't found that possible with treemaps, is there something I'm missing? For the bottom-most dimension on the Marks Card, all I've seen is that the the layout of the rectangles in the treemap is completely controlled by the descending sort of the Measure on Size.

             

            Jonathan

            • 3. Re: Order in a Treemap
              Tracy Rodgers

              Hi Jonathan,

               

              That's correct. I was thinking of the issue differently. I was imagining a dimension on the rows or columns shelf, breaking the tree maps down into smaller segments.

               

              -Tracy

              • 4. Re: Order in a Treemap
                Phillip Burger

                I'm pretty sure that order is not preserved. The basic idea is that it's a structure with a starting node, branches, and leaves mapped to a 2-D space. It's going to emanate from larger values to smaller, from trunk to leaves.

                 

                There are different treemap algorithms. I was just over on the Google Code Playground for the Google Charts API for their treemap. The behavior is similar to Tableau and they both might have implemented the same algorithm, presumably, because it's the visual, best practice at least for now.

                 

                Google Code Playground

                 

                Because of this characteristic of treemaps not preserving order, I never include a year-range slide with them.