1 Reply Latest reply on Apr 17, 2018 3:52 PM by Patrick A Van Der Hyde

    Creating a stacked bar with 3 measures with height of stacked bar as 4th measure

    DHRUV BALI

      Hello Fellow Tableau users,

      I was hoping if I could engage all of your bright minds to help me solve a request. I am trying to create a stacked bar with 3 aggregate of different measures but I want the height of the stacked bar to be equal to aggregate of a completely different measure. Since scrubbing of the whole data set is not a viable option my sample dataset looks like this in excel

       

      MonthABCT
      Jan25711
      Jan36812
      Jan47913
      Feb23810
      Feb451012
      Mar25810
      Mar451012
      Mar25810
      Mar451012

       

      and what I am trying to achieve is stacked bars with height of avg T but the color distribution be among avg A,b&C

       

       

      Monthavg Aavg Bavg Cavg T
      J36812
      F34911
      M35911

       

      Any help is deeply appreciated.

       

      Thanks