Tableau Analytics

Auto-Concatenation of Dimension Rows or Columns The default setting is Tableau is that when more than six (6) fields are placed in Columns/Rows, you notice that the first two fields are grouped, separated by a comma. Sometimes this is annoying and unwanted. To resolve this issues: 1. Open Tableau Desktop. 2 .Select  Analysis  >  Table Layout  >  Advanced  > Adjust the number of Rows or Columns (Default 6) as desired. Note:  The maximum value is 16. It can be changed by saving the Tableau workbook as XML and updating the value and save it back to Tableau Workbook. Go to Tableau video link below on how to do it:  https://www.youtube.com/watch?v=2DJIaKto5pE&feature=youtu.be

Tableau Extract Update Error "Timeout Error: IPC_NamedPipe::Select(WaitForMultipleObjects) When trying to update the Data Source or w hen attempting to connect to a data source, or create and/or refresh extracts with Tableau Desktop, the following error message occurs:  IPC_NamedPipe::Select(WaitForMultipleObjects): Timeout. Cause Anti-virus software is blocking Tableau processes from running, or the Logs folder contained corrupted information.  Resolution Option 1: If it is easy w ork with IT helpdesk/support to add below Tableau folders and processes to exclusions : Tableau.exe hyperd.exe hyperdstarter.exe *.hyper extension (if AntiVirus has an option for extension exclusions) C:\Users\<username>\Documents\My Tableau Repository C:\Users\<username>\AppData\Local\Temp\TableauTemp C:\Users\<username>\AppData\Local\Tableau C:\Program Files\Tableau Make sure that child folders are included in the exclusions. AntiVirus prog...

Create a color scale that separates data into varying ranges. Using the sample Superstore data to compare varying ranges of Sales.  1. Select  Analysis  >  Create Calculated Field 2. Name the field. In this example, it is named Five Colors. Enter a calculation similar to the following, then click OK: IF SUM(Sales)<20000 THEN 'GRAY' ELSEIF SUM(Sales)>=20000 AND SUM(Sales)<90000 THEN 'LIGHT RED' ELSEIF SUM(Sales)>=100000 AND SUM(Sales)<150000 THEN 'DARK RED' ELSEIF SUM(Sales)>=150000 AND SUM(Sales)<300000 THEN 'LIGHT BLUE' ELSE 'DARK BLUE' END 3. Place the calculated field on the  Color  shelf 4. Click the Color legend drop-down arrow, and select  Edit Colors  to choose your desired colors. See the steps in the video below from Tableau site: 

How View URLs Are Structured The parameter names and values are case-sensitive. The operators and date & time function names are case-insensitive. Characters like comma (,) and ampersand (&) in value should be prefixed and suffixed with tilde (~) symbol to differentiate itself from syntax elements.For example, CompanyName=Syncfusion Inc~,~ Invalid parameter name will get ignored from filter consideration. Invalid parameter value will result in “No data available to display” in widgets.   S tructure of the base URL In Tableau Server or Tableau Online, the basic URL pattern for a Tableau view is: http://<servername>/#/views/<workbook>/<sheet> In a multi-site environment, for views saved to sites other than Default, the site ID is also included in the URL: http://<servername>/#/site/<sitename>/views/<workbook>/<sheet> Adding parameters to the base URL To create a filtering URL, you append a  query string ...

Error:   IPC_NamedPipe::Select(WaitForMultipleObjects): Timeout. When attempting to connect to a data source, or create and/or refresh extracts with Tableau Desktop, the above error message occurs in Tableau Desktop. Fix Option 1: Work with IT to add Tableau folders and processes to exclusions: Tableau.exe hyperd.exe hyperdstarter.exe *.hyper extension (if AntiVirus has an option for extension exclusions) C:\Users\<username>\Documents\My Tableau Repository C:\Users\<username>\AppData\Local\Temp\TableauTemp C:\Users\<username>\AppData\Local\Tableau C:\Program Files\Tableau Make sure that child folders are included in the exclusions. AntiVirus programs may have different options to do this unique to the program, such as using wildcards in the path (*), or an explicit option to add child folders. To help make sure these exclusions are set for full coverage and take effect: Include the above paths and programs in exclusions for all scan s...

Tableau limit filters by number and type Filtering in Tableau is extremely powerful and expressive. However, inefficient and excessive filters are one of the most common causes of poorly performing workbooks and dashboards. Note: Showing the filter dialog requires Tableau to load its members and may create extra queries, especially if the filtered dimension is not in the view. Reduce the number of filters in use . Excessive filters on a view will create a more complex query, which takes longer to return results. Double-check your filters and remove any that aren’t necessary. Use an include filter . Exclude filters load the entire domain of a dimension, while include filters do not. An include filter runs much faster than an exclude filter, especially for dimensions with many members. Use a continuous date filter . Continuous date filters (relative and range-of-date filters) can take advantage of the indexing properties in your database and are faster than discrete date filters...