2 Replies Latest reply on Mar 15, 2016 5:53 AM by Shinichiro Murakami

    Advance Treemap Grouping


      Hi Experts, I try to show two measures group in one visualization, but,...I´m not sure if it possible.


      This is my data:




      The objetive is:





      I need to count distint customers and grouping in Purchases and sales.


      My bad visualization in tableau






      best regards,


        • 1. Re: Advance Treemap Grouping
          Tharashasank Davuluru

          Hi ,


          The treemap component is able to handle negative colour intensities …. as long at least 1 intensity is positive. This means you need to add at least one row with an empty label field, 0 as value and 1% as intensity. As the label and value are both empty, it will not show up in the treemap itself.

          This workaround is however not a solution in case of negative values. A negative value will simply not display. In most cases a simple warning message will suffice as it is probably an exception. In case it is not an exception you should advise to use another chart type for analysis. Like with pie charts, where negative values cannot be displayed.

          • 2. Re: Advance Treemap Grouping
            Shinichiro Murakami

            You can use LOD to use category as dimensions.


            [Purchase G 2]

            IF{fixed[Idcustomer]:SUM([Purchases])} > 0 THEN 'Positive Group'

            ELSEIF {fixed[Idcustomer]:SUM([Purchases])}<0 THEN 'Negative Group'

            ELSE 'Zero Group' END


            [Sales G 2]

            IF{fixed[Idcustomer]:SUM([Sales])} > 0 THEN 'Positive Group'

            ELSEIF {fixed[Idcustomer]:SUM([Sales])}<0 THEN 'Negative Group'

            ELSE 'Zero Group' END


            The rest of process should be easy for you.





            9.1 attached

            2 of 2 people found this helpful