Content in Tableau Community Forums

How to hide a NULL table value; BUT have remaining 'Grand Total' calc that ONLY sums the non-null dimensions

tableaucommunity@tableau.com — Wed, 16 Apr 2014 12:48:07 GMT

I want to sum the non-null values taking into account the null so that the 'Grand Total' = (100% - (non-null totals)).

I am using a 126 million lines of sales history with Tableau server; connecting live; and the query/render times are multi-minutes. How can this size of data render in less than 1 minute? What am I missing?

tableaucommunity@tableau.com — Tue, 14 Aug 2012 15:07:01 GMT

We are interested in using Tableau for 'big' data sets where 'big' is sales history in the 100 million to 1 billion lines of data. I have a client with 126 million lines (sales invoices lines) and to just get basic queries like counts, sum of sales, GP$ is taking 5-10-15 minutes. What options do I have? I am going to try an extract, but in the past I have not seen great response time improvement.

'BIG' data experts, please advise.

regards,

Rick

Using tableau server what does a 'request' metric indicate?

tableaucommunity@tableau.com — Thu, 09 Aug 2012 02:38:12 GMT

The server analysis tracks the metric 'requests' per user. What does this mean? I can't find a definition anywhere in tableau.

What is the best way to identify the causes of slow performance response time with tableau server? The logs are difficult to read and do not quickly point to the response issue. Any help would be greatly appreciated.

tableaucommunity@tableau.com — Thu, 31 May 2012 13:40:42 GMT

What is the best way to identify the causes of slow performance response time with tableau server? The logs are difficult to read and do not quickly point to the response issue. Any help would be greatly appreciated. We have looked at the server analysis user activity but it only provides a 12 hour window (the expanded filters do not work).

regards,

Rick

Any work-arounds other than 'pause/resume query' to the issue when deploying to the Tableau server a workbook that needs multiple filters to be checked BEFORE the query begins; aka a default 'pause' state?

tableaucommunity@tableau.com — Mon, 14 May 2012 19:38:39 GMT

Any work-arounds other than 'pause/resume query' to the issue when deploying to the Tableau server a workbook that needs multiple filters to be checked BEFORE the query begins; aka a default 'pause' state?

Currently the user forgets/dislikes the 'pause/resume' feature and just performs multiple filter clicks that cause the query to stall; and performance to be unacceptable.

Any help would be greatly appreciated.

Binning - any easy methods to increase performance and reduce query time?

tableaucommunity@tableau.com — Thu, 26 Apr 2012 12:24:30 GMT

In using the binning feature the response time is too long when running the app on a web server. Any ideas/suggestions would be most helpful!

Binning an aggregated measure

tableaucommunity@tableau.com — Fri, 13 Apr 2012 22:50:01 GMT

I have a problem in trying to use bins for an aggregated field, Total Margin%. How can I work around this issue?

Attached is a sample data set of one contract with many items. My database has hundreds of contracts with up to 40k items per contract.

I have seen using IF to create bin 'sets'. This will not work as there will be a wide range of Total Margin%, depending upon the contract data set.

Also, I am using v6 not v7.Does v7 solve this issue?

Any help would be greatly appreciated.

create 'variable' binning

tableaucommunity@tableau.com — Fri, 16 Mar 2012 19:49:14 GMT

I have a table of items with costs. Item cost can range from < $1.00 to maximum of $900.00. I want to use binning (I think), but want the bins to be variable based on the item chosen. If cost range is < $1.00 the bins could be at .05 while if cost range is $800-900 perhaps the bins are at $5.00. Current binning in Tableau 6.0 is either incremented by 1 or manual set. Any suggestions?