Get axis back once it has been removed in any Tableau chart Usually when we don't want see the names on the axis we will try to remove the header and it will remove the axis labels altogether in any type of chart in Tableau. Get get back the axis, follow the steps below: 1) This usually happens with measures or continuous dimensions like date, so remember to to the columns or rows pane where the measure is displayed as shown in the picture below. 2) Right on the measure/dimension pill and right click on it. 3) Select Show Header' option. That makes life easy!
Posts
Grand Totals for percentages is calculating average but not sum This is due to the default property Automatic is selected for Grand Totals. Change this property t Sum to resolve the issue. Follow the steps below. Open the where the data grid is created. Goto Analysis -> Totals -> Total All Using -> Select Sum(or other function which you would like to use for all the measures. This should show all the measure Grand totals to Sum. Check the screenshot below:
Repeated Row Labels in Tableau This simple tricks helps to repeat row headers on each row of a view, instead of using grouped row headers. For example, view with grouped row headers: View with repeating row headers: Environment Tableau Desktop Answer Both options start from the "Original" worksheet in the workbook downloadable from the right-hand pane of this article. Directions for creating the "Original" worksheet are included in the workbook. CLICK TO EXPAND STEPS Option 1: Use INDEX() To view the above steps in action, see the video below. Note: the video has no sound. To view the video in higher quality, click the YouTube icon below to watch it on YouTube directly. CLICK TO EXPAND STEPS Option 2 - Use Combined Field / Calculation To view the above steps in action, see the video below. Note: the video has no sound. To view the video in higher quality, click the YouTube icon below to watch it on YouTube directly.
Setting up custom background image map in Tableau The process to include a custom image map of png/jpeg format was illustrated by Tableau corp in the video below: Tableau background image video Click for Tableau KB: Use Background Images in Your Views Click for Tableau KB: Find Background Image Coordinates Click for Tableau KB: Background Images Missing, Distorted, Cut Off or Reversed Click for Tableau KB: Build Maps in Tableau Click for Tableau KB: for dual axis layered ma ps Click for Tableau KB: Create Territories on a Map Click for Tableau KB: Blend Geographic Data
Tableau File Types and Folders with icons explained You can save your work using several different Tableau specific file types: workbooks, bookmarks, packaged data files, data extracts, and data connection files. Each of these file types are described below: Workbooks (.twb) – Tableau workbook files have the .twb file extension. Workbooks hold one or more worksheets, plus zero or more dashboards and stories. Bookmarks (.tbm) – Tableau bookmark files have the .tbm file extension. Bookmarks contain a single worksheet and are an easy way to quickly share your work. For more information. Packaged Workbooks (.twbx) – Tableau packaged workbooks have the .twbx file extension. A packaged workbook is a single zip file that contains a workbook along with any supporting local file data and background images. This format is the best way to package your work for sharing with others who don’t have access to the original data. For more information. Extract (.hype
Tableau Licence Types Go to the link here to find different licence types available in Tableau
Tableau Charts in a Nutshell Line — View trends in data over time. Examples: Stock price change over a five-year period or website page views during a month. Bar — Compare data across categories. Examples: Volume of shirts in different sizes, or percent of spending by department. Heat Map — Show the relationship between two factors. Examples: Segment analysis of target market, or sales leads by individual rep. Highlight Table — Shows detailed information on heat maps. Examples: The percent of a market for different segments, or sales numbers in a region. Treemap — Show hierarchical data as a proportion of a whole. Examples: Storage usage across computer machines, comparing fiscal budgets between years. Gantt — Show duration over time. Examples: Project timeline, duration of a machine’s use, availability of players on a team. Bullet — Evaluate performance of a metric against a goal. Examples: Sales
Create Clickable mailto link email in Tableau dashboard This is a simple technique where we have to create a text object on the dashboard. This is rather a simple technique where we have to create a text object on the dashboard with the following text in it: mailto:emailaddress@yourcompany.com Just place the required email address after mailto: then once the dashboard is opened/run it, click on the above mailto:emailaddress@yourcompany.com. It will open the default email application like outllook with the address mailto:emailaddress@yourcompany.com in the to address. It doesn't even need you to create an action filter.
Set the Default Start Page for All Users In a new deployment, when users sign in to the Tableau Server web authoring environment, they are taken to the Home screen, which displays a role-based welcome banner. Home also displays recent views, favorites, and the site's most-viewed content. As the server administrator, you can change users’ default landing page at the server and site level. For example, you can show all workbooks, and when the user signs in, they see the workbooks they have access to. To set the default start page for all users Display the page or filtered view you want to be the default page users see when they sign in to the site. Select your profile icon in the upper right area of the page. To set the start page for: All users on a site: click Set as Start Page and For Users on this Site . All users on the server: click Set as Start Page and For All Server Users . User-set start pages and hierarchy Users can set their own s
Tableau row level calculations to compare previous row value and current row value If current row value is greater than previous row value then calculate: Current row value - previous row value = IF INDEX() == 1 THEN ATTR( [Delay Minutes] ) ELSEIF ATTR( [Delay Minutes] ) > LOOKUP(ATTR( [Delay Minutes] ), -1) THEN ATTR( [Delay Minutes] ) - LOOKUP(ATTR( [Delay Minutes] ), -1) ELSE 0 END