• Coloring Parts Of A Text Block

    Current Situation: We are working on getting our Project Managers out of PowerPoint and into entering their data into a SharePoint form so we can create views in Tableau. They are accepting the change but there has b...
    Dana Chaffin
    last modified by Dana Chaffin
  • 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
  • Need 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 ...
    Ravi Teja Baratam
    last modified by Ravi Teja Baratam
  • 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
  • Strip URL's of parameters in Tableau

    Description:  I often need to parse Google Analytics data or any other data that contains a list of URL's.  While doing this, I need to remove the parameters that appear at the end of a content url so pages ...
    Patrick Van Der Hyde
    last modified by Patrick Van Der Hyde
  • 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
  • Removing Extra Characters

    Description:   Removes extra characters from the end of a string.       Example Calculation:   //for example in a field similar to [Size After] (which has a format similar to 1KB, 110KB, 10...
    Tracy Rodgers
    last modified by Tracy Rodgers
  • 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
  • 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
  • Parse fields containing JSON data

    Description:   This demonstrates one way to extract data from a field that contains JSON data (e.g. key/value pairs). The approach using a regex to pattern match on the key and then extract the value.   E...
    Samuel Leach
    last modified by Samuel Leach
  • 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
  • Quantile

    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...
    Richard Leeke
    last modified by Richard Leeke
  • Week 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 ...
    Tracy Rodgers
    last modified by Tracy Rodgers
  • t-test of two independent means

    Description:   This is the simplest t-test for a significant difference in the means of two independent populations assumed to have equal variance. This test assumes the two samples are of equal size. The test i...
    Scott Tennican
    last modified by Scott Tennican
  • Template

    Description:             Example Calculation:   //calculation comments in green and in Courier New   If [calculation] then [black] and [ Courier New font] end     ...
    Tracy Rodgers
    last modified by Tracy Rodgers
  • Convert String to Datetime (retaining fractional seconds)

    Description: Tableau's inbuilt conversion function for converting a string representation of a date and time to a datetime field is DATETIME(). This works fine as long as the precision of the time portion of the fiel...
    Richard Leeke
    last modified by Richard Leeke