Skip to main content

Posts

Get axis back once it has been removed in any Tableau chart

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!

Grand Totals for percentages is calculating average but not sum

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

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 YouT...

Setting up custom background image map in Tableau

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

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. ...

Tableau Charts in a nutshell

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. ...