Top 10 and Bottom 10 values by Sales

1) First you create a set for top 10 Products by Right click on a product field-> then create a set -> then select "Top" ->  then define "10", choose "Sales"  with sum.

2) Create second set  for create Bottom 10 Products by right click on a product field -> create a set -> then select bottom -> then define 10, choose sales with sum

3)  now combine the first and second set, by clicking on any one of the sets and -> selecct combine set -> select all values 

4) First drag the sales in to rows shelf, and then Products in to columns shelf.

5) Now drag the combine set in to the filter shelf... now your view will have only top 10 and bottom 10 values by sales.

Tableau Connection Error - 127

Once in  six months or an year, We used to recieve a connection error called 127 in Tableau especially when we connected to an Oracle Database.  It means the database connection drivers might be out of date.

Fix for this is : We need to downlaod the right version of Oracle Instant client, Unzip it to the Oracle folder and then add it to the system Environment variable Path.

After that you should restart your Tableau server. That's it...

How to Create Installation log in Tableau?

Step 1: Download the Tableau Desktop or Tableau Reader installer to your machine, to the location of your choice.
Step 2: Click the Start button.
Step 3: In the search box, type Command Prompt. In the list of results, right-click Command Prompt, and then click Run as administrator.
Step 4: Type cd c:\ to change the drive directory to c:
Step 5: Type cd and the path to the location where you downloaded the Tableau Desktop or Tableau Reader installer in step 1.
For example, cd Users\<username>\Desktop. The <username> must be replaced with your Windows username.
Step 6: For Tableau Desktop, type TableauDesktop.exe /t:"full path to the folder of your choice"/c to simultaneously extract the Tableau Desktop installer to a folder that is created with a name of your choice.

For Tableau Reader, type 
For Tableau Reader, type TableauReader.exe /t: "full path to the folder of your choice"/c.
For example, TableauDesktop.exe /t:"c:\Users\<username>\Desktop\TableauDesktopTemp"/c.
Step 7: Type cd and the name of the folder you created in step 6.
For example, cd TableauDesktopTemp.
Step 8: Type dir to see the contents of this folder.
Make note of the full name of the .msi file contained in this folder. For example, the full name of Tableau Desktop .msi file may look similar to this, tableau-setup-std-tableau-6-1.11.0724.1830.msi.
Step 9: Type msiexec /i fullfilename.msi /l*v logfile.txt to install Tableau. Everything that happens during this installation process is recorded in the installation log called "logfile.txt".

Replace"fullfilename.msi" with the full file name you noted in step 8. For example, 
Replace"fullfilename.msi" with the full file name you noted in step 8. For example, msiexec /i tableau-setup-std-tableau-6-1.11.0724.1830.msi /l*v logfile.txt.
Step 10 (optional):If an error or other issue occurs during installation, navigate to the folder you created in step 6. It will contain the installation log called "logfile.txt".https://www.facebook.com/groups/15888884513646