• Create 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 ...
    Yeyner Escobar
    last modified by Yeyner Escobar
  • string to hours as measures.twbx

    HI I have a time column(string) i need to write a calculation to get the hours (measure).please help me     thanks and regards Bharath Raj
    Bharath  Raj
    last modified by Bharath Raj
  • Replacing 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: &...
    Jonathan Drummey
    last modified by Jonathan Drummey
  • Covariance, 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 ...
    Jonathan Drummey
    last modified by Jonathan Drummey
  • Rate 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: ...
    Aaron Sheldon
    last modified by Aaron Sheldon
  • Record 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...
    Aaron Sheldon
    last modified by Aaron Sheldon
  • 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...
    Jonathan Drummey
    last modified by Jonathan Drummey
  • Rectangular 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...
    Richard Leeke
    last modified by Richard Leeke
  • Nulls 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 ...
    Tableau kumar
    last modified by Tableau kumar
  • Why 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...
    Jonathan Drummey
    last modified by Jonathan Drummey
  • Year 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 ...
    Jonathan Drummey
    last modified by Jonathan Drummey
  • Datetime 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...
    Richard Leeke
    last modified by Richard Leeke
  • Moving 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...
    Aaron Sheldon
    last modified by Aaron Sheldon
  • Dynamic 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...
    Aaron Sheldon
    last modified by Aaron Sheldon
  • Violin 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...
    Aaron Sheldon
    last modified by Aaron Sheldon
  • LEAD 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...
    Aaron Sheldon
    last modified by Aaron Sheldon
  • Trapezoid 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 ...
    Aaron Sheldon
    last modified by Aaron Sheldon
  • Kaplan 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...
    Aaron Sheldon
    last modified by Aaron Sheldon
  • 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...
    Steve Martin
    last modified by Steve Martin
  • Parameters A Love Story.twbx

    I created this workbook with examples of the parameters Amy Forstrom discusses in her TC17 talk Parameters: A Love Story If you want to really get to know parameters, I really recommend listening to her talk here: ht...
    alison.whitaker.0
    last modified by alison.whitaker.0