1 Reply Latest reply on Apr 28, 2016 12:25 PM by G Marc Turner

    Dynamic Heat Map

    Mondher Ben Hamida

      I am trying to upgrade the following heat map.

      • Rows: 7 pricing bands
      • Columns: top 15 brands
      • Heat map main driver: each cell (pricing band / brand intersection) = # of units sold during a period i have in the filter

      Ideal heat map would have the following in the cells:

      • each brand (column header) would have the top model (name) and # of units sold during that period in the corresponding pricing band cell

      Pasted_Image_4_28_16__9_46_AM.png

        • 1. Re: Dynamic Heat Map
          G Marc Turner

          I think I understand what you trying to do. I used the Sample Superstore data as an example for the attached workbook. I create two calculated fields. One identifies the top number of orders in each cell. This formula could be changed to sum the units sold instead of counting distinct orders though. The other field finds the product name associated with the top number of orders. Both of those fields are added to the label. This might not be exactly what you are looking to do, but hopefully it points you in the right direction.

           

          Clipboard01.jpg

           

          Hope this helps

          -marc