The Tableau CONTAINS function is one of the string functions that helps to perform search operations. It will search each row of a given column for the given Substring. If the specified Substring is present in the original, it will return boolean True. Otherwise, it returns False. This article uses an example to show how … Read more
This Tableau article explains creating a KPI or Key Performance Indicator using a window average with an example. To demonstrate the Tableau KPI using the window average, we used the Sample Superstore Excel sheet. Please visit the Excel Source article to understand the Data Source. Tableau KPI using window average Drag and drop the Sales … Read more
This Tableau article explains using the string parameter to work on dimensions, including displaying a particular country’s sales, performing wildcard searches, and multidimensional wildcard searches with an example. To demonstrate the Tableau String Parameter values, we used the Dimproduct, DimGeography, and FactInternetSales tables in the AdventureWorksDW database. Please visit the SQL Source and SQL Tutorial … Read more
This Tableau article explains how to add a Reference Line using a parameter with an example. In general, you can add a reference line to the sales average. However, if the organization has a specific range of values to compare against the sales, then this approach is viable. Instead of allowing fixed reference lines, it … Read more
This Tableau article explains how to use the Start and End Date filter to restrict the report from showing the records between those dates using the parameter with an example. In general, finding the sales between the start and end dates is the most common scenario to evaluate the business. To demonstrate the Tableau Start … Read more
This article explains how to perform the Tableau Date Calculation using a parameter with an example. In general, when you want to show the sales trend, by default, it shows the sales by year or month, but not both. However, use the parameter and the DATETRUNC function combination. You can allow the users to choose … Read more
This Tableau Table Calculation article explains how to calculate the percentage difference between the previous year and this year. The percentage difference table calculation helps to understand the total percentage of sales’ downfall or upward trends. To demonstrate the Tableau percentage difference calculation, we used the Sample Superstore Excel sheet. Please visit the Excel Source … Read more
This article explains how to create a basic sales report in Tableau to understand the company sales by state/province and the financial years with an example. To demonstrate the steps involved in creating a basic sales report in Tableau, we used the AdventureWorksDW database. Please visit the SQL Source and SQL Tutorial article to understand … Read more
This article shows how to add a Pie chart to the Tableau Maps using the layers and Dual Axis options with examples. To demonstrate this example, we used the Sample Superstore Excel sheet. There are two approaches to fulfill this requirement: the first is adding the Marks Layer(latest), and the second is the dual axis … Read more
In this Tableau article, we will show you how to use the calculated fields to create a KPI or key performance Indicators and display the KPI in a donut chart. To demonstrate the Tableau KPI Donut Chart, we used the Sample Superstore Excel sheet. Please visit the Excel Source article to understand the Data Source. … Read more
