4 Replies Latest reply on Feb 21, 2018 8:51 AM by Ramandeep Singh

    Help with heat maps and updating weather profile

    Ramandeep Singh

      Hello Everyone,

       

      Thank you for reading my post. I have spent a lot of time before i moved here and started looking for help. There's not a lot on the internet that can help me solve this issue related to heatmaps and bin data OR i might have missed it.

       

      https://public.tableau.com/profile/ramanasbs#!/vizhome/Testworkbook1_1/Story1?publish=yes

       

      Issue-1:

      I made heat maps using the energy data and weather temperature Bins. The problem is the heat maps colours are showing up in the empty cells (no data) and is causing a lot of distraction. Is there a way that the empty cells are not coloured and stay invisible? It works if i am not pivoting the data under site names.

       

      Issue-2:

      All the sites have different weather profile. So, how to change weather automatically when i change the site number.? I tried to create a calculated field (using IF ELSE) but it didn't work because i am trying to reflect Weather Bins when site number is changed.

       

      I have uploaded the workbook and two screenshots for your reference.

       

      thank you!

      Raman