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

    Advance Treemap Grouping

    carlos.sanzporro.0

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

       

      This is my data:

       

      data.png

       

      The objetive is:

       

      objetive.png

       

       

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

       

      My bad visualization in tableau

       

      TABLEAU.png

       

      Thanks,

       

      best regards,

      Carlos

        • 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.

             

            Thanks,

            Shin

             

            9.1 attached

            2 of 2 people found this helpful