4 Replies Latest reply on Oct 22, 2018 5:54 PM by Alexander Farr

    Tableau greyed out worksheet

    Alexander Farr

      Hello everybody,

       

      I had created a workbook with a lot of data, which looks similar this:

       

      2.PNG

      When I switch to "Entire View" the following is shown:

       

      1.png

      Does anybody know how I can see the entire view visualization?

       

      I would really appreciate your help.

      Thank you very much!

        • 1. Re: Tableau greyed out worksheet
          ShivaRam Chennapragada

          Hi Alexander,

           

          Because there are just too many records that you're trying to visualize and when you squeeze them into a single view the bars overlap and appears to be greyed out. Try to minimize number of records you're trying to visualize to fit in the single view.

           

          Hope this helps.

           

          Best,

          Shiva.

          • 2. Re: Tableau greyed out worksheet
            Alexander Farr

            Hi ShivaRam Chennapragada,

             

            Is there any possibility to still show the whole amount of records at once? When creating a pareto chart it is also possible to show a large amount of values in one chart:

             

            1.png

             

            Best,

            Alexander

            • 3. Re: Tableau greyed out worksheet
              ShivaRam Chennapragada

              Hi Alexander, it is important to note the difference between a bar chart and pareto chart. Pareto chart is plotted using running totals which are continuous values that follow a growth path. Hence, when you plot them and view them in single view, although the data is so densely packed it looks normal due to the running totals. A Pareto Chart can only have 1 dimension and at least 1 measure.

               

              However, in your bar chart you're trying to plot "Average Profitability" for each "Brand/Description". That means each combination of these two dimensions would have its own discrete "Average Profitability" value.

               

              Here's how it looks when I take one dimension out and do a "Running Total" of "Average Profitability".

               

              Hope this helps. Let me know if you have questions.

               

              Best,

              Shiva.

              • 4. Re: Tableau greyed out worksheet
                Alexander Farr

                Thank you Shiva!

                 

                So does your visualization show the running sum of average profitability with good with the highest profitability at the left? Is there no way of showing the average profitability similar to this without summing it up?

                 

                Could you post the twbx file?

                 

                Thank you!