• Document Nulls Handling - String, Date, Numerical Data typesNulls Handling - String, Date, Numerical Data types

This document is prepared intend to handle the nulls.   We may have nulls in String Data type Columns, Date Data Type Columns, Numeric Data Type Columns, Which cracks our heads while creating calculations, This ...
• 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 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 Covariance, Trend Lines, Correlation Coefficient R and R-SquaredCovariance, Trend Lines, Correlation Coefficient R and R-Squared

Description: These calculations provide the basic correlation values in calculated fields. These include covariance slope of trend line, using on cov(x,y) / var(x) Pearson's correlation coefficient, "R", which is ...
• Document Rate Estimate Standard ErrorsRate Estimate Standard Errors

Description:   Rates are commonly estimated statistically with the ratio of additive aggregates, such as the ratio of sums, or averages. There are three principle reasons driving the use of ratios of estimates: ...
• Document Record Level Standard ScoresRecord Level Standard Scores

Description:   I would argue that standard scores, or z scores, are the canonical example of using an empty INCLUDE level of detail calculation to create record level compositions of aggregates and non-aggregates...
• 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 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 Moving Averages with Edge Smoothing by Triangular WindowsMoving Averages with Edge Smoothing by Triangular Windows

Description:   In signal processing moving averages are an elementary technique to smooth sequential data. While Tableau's WINDOW_AVG is the simplest implementation of moving averages, being WINDOW_SUM divided by...
• Document Dynamic Percentiles from Record CountsDynamic Percentiles from Record Counts

Description:   Tableau's WINDOW_PERCENTILE operates only on the rows, and does not take into account the implicit weighting of the rows due to the underlying record counts. Through a careful application of intege...
• Document Violin Plots from Record Counts with Dynamic Smoothing and PercentilesViolin Plots from Record Counts with Dynamic Smoothing and Percentiles

Description:   Violin plots are used to compare distributions on the same continuous dimension, particularly when working with sparse data. A violin plot combines a density estimator and a box plot to allow for b...
• Document LEAD and LAG using level of detail calculationsLEAD and LAG using level of detail calculations

Description:   A common task in longitudinal analysis is to compare an observed [VALUE] to either a previous [LAG] or following [LEAD] value with respect to a prescribed [ORDER]. With the introduction of level o...
• Document Trapezoid Density EstimationTrapezoid Density Estimation

Description:   When individual bins of a relative frequency histogram are assumed to integrate to the relative frequency of the bin (density, or percentage of observations) then Tableau's bar style marks provide ...
• 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...