• #### 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 LOD in Tableau.docxLOD in Tableau.docx

LOD(Level of Detail) Expressions in Tableau for better understanding with examples@
• #### Document Änderung der Wertebezeichnung (Import von SPSS)Änderung der Wertebezeichnung (Import von SPSS)

Hallo zusammen,   wie man an meiner Fragen merkt, bin ich ein neuer User von Tableau. Es geht um folgendes: Meine Daten stammen ursprünglich aus SPSS. Dort gibt es ganz normal jede Menge variablen. Nehmen w...
• #### 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 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 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 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 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 Average Rank from Count DataAverage Rank from Count Data

Description:   All rank tests, such as the Mann-Whitney and the Kruskal-Wallis, assign the average rank to ties, to ensure consistency when summing over consecutive tied ranks, specifically so that the sum of th...
• #### 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...
• #### Document HomelessProject.twbxHomelessProject.twbx

My first Viz - Homelessness across the English local districts
• #### Document Modified Competition RankModified Competition Rank

Description:   This is a ranking function with ties. Tied items share the lower rank.    Example Calculation:     IF ISNULL(SUM([Measure])) THEN   NULL ELSE   IIF(SUM([Measure...
• #### Document Difference between two daysDifference between two days

Hello Everybody,   I need your help in a specific formula. In Excel, i used this way =(TODAY()-DATE(2013/1/1))/30 and the result should be 14,57. How Can i do the same calculation in Tableau to use this result ...