Showing percentage for pre calculated fields in Tableau. In Tableau measures sometimes displays the percentage in four digits like 3343% instead of usual max 100%. This is because the field is already calculated in database and the value for the percent is available like 3, 4, 8 etc which needs a % sign beside them like 3%, 4%,5% etc. In order to do this the simple trick is that: Go to Tableau - > Right click on the measure Click on Format for the Measure..
Posts
Convert a Field to a Date Field Each database stores Date fields in slightly different ways. Tableau does its best in interpreting the date fields, but sometimes a field will be imported to Tableau as a text string or numerical field. If this happens, there are a few steps we can take to resolve the issue. Verifying Date Fields The date field might appear as a string when connecting to the Data Source... Or as a string in the Dimensions Pane. When dates are interpreted as strings, you will lose all of the features and conveniences of working with date fields, such as drilling down, using date calculations, and switching between Continuous and Discrete measures. If your dates aren't interpreted correctly, take the following steps in order: Change the data type of the field Create a calculation using the DATEPARSE function Create a calculation using the DATE function Change the data type of the field The first step in resolving a date field inter
Horizontal Scroll Bar Missing When interacting with a text table that has multiple dimensions on either the Columns or Rows shelf, the horizontal scroll bar does not appear. Furthermore, the dimensions on either shelf are cut off. Resolution To help resolve this issue, follow the steps below. Place only the absolute necessary dimensions on the Rows or Columns shelf. Drag any remaining dimensions to Detail on the Marks Card. Cause Tableau shows a horizontal scroll bar for measures, but not for dimensions. When only dimensions are included on either the Columns or Rows shelf, the lower horizontal scroll bar will not display. Dimensions are treated as headers for measure aggregations and do not generate a horizontal scroll bar when they exceed the width of the view. Additional Info: As an alternative, you can drag dimensions to Detail . When you drag dimensions to Detail , they will appear in the marks' tooltip. Tooltips can be formatted and customized to cont
Report/Dashboard Requirements Template Your Corporation Name Report Specification XXX Company Report Name Table of Contents Specification Details . 4 Document Control Information . 4 Revision Control Information . 4 Environment and User Requirements . 5 Environment Information . 5 Report Details . 6 Report Purpose . 6 Report Users . 6 Report Definitions . 6 File and Layout Details . 7 Access Details . 7 Report Performance Settings . 8 Parameters . 9 Report Parameter Type . 9 Application Parameter Reports Only* – Report Level Settings 9 Parameterized Reports**– Parameter Settings . 10 Parameter 1: 10 Parameter 2: 11 Parameter 3: 12 Report Content 13 Header 13 Graphs . 14 Sub Header 1 . 15 Sub Header 2 . 16 Sub Header 3 . 17 Report Mockup . 18 Testing Considerations . 19 Use Case Scenarios or Notable Test Requirements . 19 Report Name