• #### Document Create join with calculated fieldsCreate join with calculated fields

Hello, Tableau friends,   I just want to share a little of what I've learned with the use of Tableau. I really do not know if someone has already mentioned what I am going to explain on this occasion, I hope it ...
• #### Document ABC analysisABC analysis

ABC analysis in Tableau typically involves Table Calculations -- as the logic behind grouping items is based on their Percentile Ranks.   For example, the 'A' group would consist of the first 20% of Products ...
• #### Document Display Line Chart KPI with Seasonal TargetsDisplay Line Chart KPI with Seasonal Targets

I was tasked to represent a KPI with targets that changed each quarter due to seasonal fluctuations. Along with this they wanted to show the previous year in the same chart AND faded in the background.   Oh - a...
• #### Document LOD in Tableau.docxLOD in Tableau.docx

LOD(Level of Detail) Expressions in Tableau for better understanding with examples@
• #### Document Replacing No Data with 0 or Another ValueReplacing No Data with 0 or Another Value

Description:   Often times there will be what looks like NULL data in the data, however, it really is No data. (Refer to the blank spaces in the below view).         Example Calculation: &...
• #### Document Need Solution for LOD caluclationNeed Solution for LOD caluclation

HI All,      I need solution for Below case case: I need count of each Male and Female Fraud's happen in each country,       I tried solution with LOD concept but i get ...
• #### Document What ATTR() Does and Testing Whether ATTR() Returns * (Multiple Values)What ATTR() Does and Testing Whether ATTR() Returns * (Multiple Values)

About ATTR(): ATTR() is a special Tableau function that effectively returns a record-level result as an aggregation. If there are multiple values of the record-level field in the current context then ATTR() will re...
• #### Document Rectangular Bins for Latitude and LongitudeRectangular Bins for Latitude and Longitude

Description: It is sometimes useful to show high volume geographic data summarised into rectangular bins. This is tricky, though, because of the distortion caused by the map projection.   Robert Morton provided...
• #### Document Why Your Grand Total or Subtotal Isn't Working as ExpectedWhy Your Grand Total or Subtotal Isn't Working as Expected

Tableau does not compute Subtotals and Grand Totals as just an aggregation (Sum, Avg, etc.) of the displayed marks. Instead, Subtotals and Grand Totals are computed as a separate calculation of the Measure at a coarse...
• #### Document Year to Date (YTD) from Previous Year and Fiscal YearYear to Date (YTD) from Previous Year and Fiscal Year

Description:   While there is a Year to Date option in a Relative Filter for a date, there is no Year to Date from the previous year. The following formulas use the current Day/Month/Year to determine whether a ...
• #### Document How to show Actual vs Target in bullet graph for different metrics?How to show Actual vs Target in bullet graph for different metrics?

Hi all,   I have one requirement to show Actual vs Target in  Bullet graph for different metrics or it would be helpful if you suggest in any other graphs.   In single sheet, we need to show 4 Metrics ...
• #### Document Datetime BinsDatetime Bins

Description: It is often useful to divide up the members of a datetime dimension into uniformly sized bins. Tableau has built-in support for doing this at the level of common datetime units, ranging from years to sec...
• #### Document Kaplan Meier Product Limit EstimatorKaplan Meier Product Limit Estimator

Description: The Kaplan Meier product limit estimator is widely used in survival analysis. It is applied in the situation where each event observation records, exclusively, either an outcome, or a censoring at a sing...
• #### Document Adding "All" Option to ParametersAdding "All" Option to Parameters

Description:   The calc below demonstrates how to add an "All" option to parameters. This is beneficial when filtering across datasources, where the user needs the ability to look at All values, or individual val...
• #### Document Cumulative Distribution Function (Normal Distribution)Cumulative Distribution Function (Normal Distribution)

Description:   Provides the calculation to produce the Bell Curve significance value, the same output as the Excel Norm.Dist function, the calcs provided require just your Z-Score input.     Example C...
• #### Document QuantileQuantile

Description: Quantiles divide ordered data into a series of essentially equal-sized data subsets. The quantiles are the data values marking the boundaries between consecutive subsets. The most commonly used numbers o...
• #### Document Week Start on MondayWeek Start on Monday

Tableau Function(s) Used:   DATEADD Example Calculation:   DATEADD('day',-1,[Date Field])   Description:   Tableau starts a week with Sunday. By using the above calculation, the start day ...