2 Replies Latest reply on Apr 25, 2016 9:03 AM by tommy durant

    Improving Performance of this KPI Dashboard

    tommy durant

      My data is structured like the first table below. I used a union query to change it to the 2nd table. This allowed me to create a heatmap showing if a client has a product or not by having a "Check mark"

      Imgur: The most awesome images on the Internet

       

       

      The issue is this turned a table with 50k rows, into a table with 1 million rows and the performance sucks bigtime. 

       

      I want my end result to look like the below version:

      Imgur: The most awesome images on the Internet

       

       

      What is the best way to go about this without making it 50k rows?