2 Replies Latest reply on Jun 5, 2017 11:52 PM by Sleepy Wang

    Can Tableau handle the wide table with sparse data

    Sleepy Wang

      Hi,

       

      I got a wide table to save the different attributes in different categories, something like below:

       

      idcategoryyearwidthheightlength
      A001screen20163218
      A002pen201610
      A003table20174827

       

      Is there a way that I can draw a scatter point chart to show each attribute value based on 2 filters like below:

      1. Correlate the two filters´╝îetc, hide the "length", if the category "screen" is chosen

      2. show the value of chosen attribute in the chart.

      narrow.png

      I tried to add a reference table and some parameter, but neither get what I want.