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

# Tableau greyed out worksheet

Hello everybody,

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

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

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

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

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:

Best,

Alexander

• ###### 3. Re: Tableau greyed out worksheet

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

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!