Tech Togs

  Custom View  A custom view is a copy of the view to which we select and apply filters. We can use custom views to save our filters, types or selections without changing the original view. Custom views is a good option if we find ourselves changing tableau server or tableau online views every time we open it. Step 1: Step 2: Step 3:  "The source of the image is obtained from the internet"

 Row Level Security Row level security in a tableau refers to restricting the rows of data that a certain user can view in a given workbook or data source. Viewers see only the data that is of their use or is related to them. This allows us to better control and there by what data users see in the published view based on their tableau server login account.

 Color Code Color codes are representing the formats of colors in computers and the web that the computer can read and display. When do we need it? Color-coding is used to identify and represent things we need, it is an important part of every program, through which we are able to identify and assess data. How many Colour codes are there? According to the computer hope, there are 16,777,216 different color possibilities. Quick View for color code  Color Code Preview : Color Code Samples:

Custom font in tableau Custom fonts allow us to use beautiful combinations of different fonts on our website and tools to improve typography and user experience. How to use custom fonts in Tableau To use a custom font, you download it from the web, and copy-paste the download file into the fonts folder of control panel. After copy paste successfully, launch tableau application again, now you will be able to see new fonts in tableau application. These are the steps to add custom fonts to Control Panel 1. Find and download the font you want to use Here's an idea of your font will look like. 2. Search selected font in google web then download 3. Check your downloads folder, if the file is in zip extension then extract it before use. 4. After successfully extracting just copy and paste it to this location. 5. New font successfully install in your machine, just relaunch the tableau application, now you will be able to see new fonts in tableau application.

 Tableau converting text case  UPPER case function lower case function Proper case function UPPER case function : The upper case function converts all letters to uppercase (capital letters) ex: Function  Name : UPPER (Name) Result: Name: AJAY KUMAR lower case function : The lower case function converts all letters to lowercase.(small letters) ex: Function Name: LOWER(Name) Result: Name: ajay kumar Proper Case The Proper case is text that is capitalized with the first letter of each word. ex: Create a calculator field for this: Name UPPER(LEFT(SPLIT([Name],' ',1),1)) + LOWER(MID(SPLIT([Name],' ',1),2,20)) + ' ' + UPPER(LEFT(SPLIT([Name],' ',2),1)) + LOWER(MID(SPLIT([Name],' ',2),2,20)) + ' ' + UPPER(LEFT(SPLIT([Name],' ',3),1)) + LOWER(MID(SPLIT([Name],' ',3),2,20)) Result: Name: Ajay Kumar

Tableau Navigation Tableau navigation features give us users the ability to seamlessly move from one dashboard, sheet, or story — all within a workbook. Tableau Menu  In the Tableau menu we find all the available menu commands and the main interface of the Tableau application. And we can also Navigate it with [Alt + _ ] command Using alt key we can navigate all the menu of tableau application tool. There are 11 data menu in Tableau application File Data Worksheet Dashboard Story Analysis Map Format Server Window Help

LOD Function Level Of Detail expressions (LOD) allows us to calculate values at data source level and visualization level in tableau application tool. This gives us more control over the level of granularity we want to calculate. Types of LOD FIXED INCLUDE EXCLUDE Fixed : It compute a value using the specified dimensions, without reference to the dimensions in the view. ex: {FIXED [Region] : SUM([Sales])} Include: Calculating values using specified dimensions other than whatever dimensions are in the view ex: { INCLUDE [Customer Name] : SUM([Sales]) } Exclude: It declare dimensions to omit from the view level of detail. ex: {EXCLUDE [Order Date (Month / Year)] : AVG({FIXED [Order Date (Month / Year)] : SUM([Sales])})}