In-Built Functions in Tableau

• There are the following categories of In-Built Functions in Tableau:-

(A) Number Type In-built Functions in Tableau

• • Number type in-built functions in Tableau are used to perform calculations or manipulations on numeric data within our visualizations or calculated fields.
  • These functions can be applied to measure values or to create new calculated fields.
  • These functions can be used directly within calculated fields or as part of calculations in Tableau visualizations to perform various types of analysis and data manipulation on numeric data.
  • Some commonly used number functions in Tableau are as follows:-
    1. SUM():
       • Calculates the sum of a set of values.
       • Example: SUM(Sales)

1. 1. 2. AVG():
         • Calculates the average of a set of values.
         • Example: AVG(Profit)

1. 1. 3. MIN():
         • Returns the minimum value from a set of values.
         • Example: MIN(Sales)

1. 1. 4. MAX():
         • Returns the maximum value from a set of values.
         • Example: MAX(Profit)

1. 1. 5. MEDIAN():
         • Returns the median value from a set of values.
         • Example: MEDIAN(Sales)

1. 1. 6. STDDEV() or STDEV():
         • Returns the standard deviation of a set of values.
         • Example: STDEV(Profit)

1. 1. 7. VAR() or VARIANCE():
         • Returns the variance of a set of values.
         • Example: VAR(Sales)

1. 1. 8. COUNT():
         • Returns the number of non-null values in a set of values.
         • Example: COUNT(Region)

1. 1. 9. COUNTD():
         • Returns the number of unique values in a set of values.
         • Example: COUNTD(CustomerID)

1. 1. 10. PERCENTILE():
          • Returns the value at a specified percentile of a set of values.
          • Example: PERCENTILE(Sales, 0.75)

1. 1. 11. QUARTILE():
          • Returns the value at a specified quartile of a set of values.
          • Example: QUARTILE(Profit, 3)

1. 1. 12. RANK():
          • Assigns a rank to each value in a set, with ties given the same rank.
          • Example: RANK(Sales)

1. 1. 13. NTILE():
          • Divides a set of values into a specified number of tiles and assigns a tile number to each value.
          • Example: NTILE(4)

1. 1. 14. Zn():
          • Returns the value if it’s a number; otherwise, returns zero.
          • Example: Zn(Profit)

1. 1. 15. ABS():
          • Returns the absolute value of a number.
          • Example: ABS(Discount)

1. 1. 16. ROUND():
          • Rounds a number to the specified number of decimal places.
          • Example: ROUND(Sales, 2)

1. 1. 17. TRUNC():
          • Truncates a number to the specified number of decimal places.
          • Example: TRUNC(Cost, 2)

(B) String Type In-built Functions in Tableau

• • String type in-built functions in Tableau are used to manipulate and perform operations on string values within the visualizations or calculated fields.
  • These functions can be applied to dimensions or measure values that are represented as strings.
  • These functions can be used directly within calculated fields or as part of calculations in Tableau visualizations to manipulate and analyze string data in various ways.
  • Some commonly used string functions in Tableau are as follows:-

1. 1. 1. LEN():
         • Returns the length of a string.
         • Example: LEN(Product Name)

1. 1. 2. LEFT():
         • Returns the specified number of characters from the beginning of a string.
         • Example: LEFT(Customer Name, 3)

1. 1. 3. RIGHT():
         • Returns the specified number of characters from the end of a string.
         • Example: RIGHT(Postal Code, 5)
      4. MID() or SUBSTRING():
         • Returns a substring from within a string, starting at a specified position and optionally with a specified length.
         • Example: MID(Order ID, 4, 3)
      5. UPPER():
         • Converts all characters in a string to uppercase.
         • Example: UPPER(Product Category)

1. 1. 6. LOWER():
         • Converts all characters in a string to lowercase.
         • Example: LOWER(Country)

1. 1. 7. PROPER():
         • Capitalize the first letter of each word in a string.
         • Example: PROPER(Product Name)
      8. TRIM():
         • Removes leading and trailing spaces from a string.
         • Example: TRIM(Customer Name)
      9. REPLACE():
         • Replaces occurrences of a specified substring within a string with another substring.
         • Example: REPLACE(Description, “old”, “new”)

1. 1. 10. FIND():
          • Returns the starting position of a specified substring within a string.
          • Example: FIND(“needle”, Haystack)

1. 1. 11. CONTAINS():
          • Checks whether a string contains a specified substring, returning true or false.
          • Example: CONTAINS(Product Name, “Table”)

1. 1. 12. CONCAT():
          • Concatenates two or more strings together.
          • Example: CONCAT(First Name, ” “, Last Name)

1. 1. 13. STR() or STR():
          • Converts a number to a string.
          • Example: STR(Sales)

1. 1. 14. SPLIT():
          • Splits a string into an array of substrings based on a specified delimiter.
          • Example: SPLIT(Address, “,”)

1. 1. 15. LEFTPAD() and RIGHTPAD():
          • Pads a string with specified characters on the left or right side to reach a specified length.
          • Example: LEFTPAD(Customer ID, 8, “0”)