6 Replies Latest reply on Apr 27, 2018 7:48 AM by Jennifer VonHagel

    Dimension values should remain constant irrespective of Filters

    lalitha p

      Hi Everyone,

       

        I am trying to get a visualization like this.

        I have a sample report which is as follows with Fields: Coffee Type, Count and location(Location as a filter).

        I am trying to plot a tree map out of my data.

       

       

       

      If i filter for Sydney say,

       

      I have coffee types 6 in general. Irrespective of filters i want my coffee types to display in the chart and if there is no count it should display as 0.

      i.e If i filter for Sydney as i dont have type Americano it is missing in the second screenshot but i want to display it as Americano but count should be 0.

       

      Can someone give me any idea on this.

       

      Regards

      LP