Custom fields in Tableau: Using Tableau operators to create custom fields

👉🏻 Download Our Free Data Science Career Guide: https://bit.ly/2POLaN8 👉🏻 Sign up for Our Complete Data Science Training with 57% OFF: https://bit.ly/3iKD0lv In this lesson, we’ll spend some time describing some of the other ways you can transform your source data and create custom fields. Remember, we shouldn’t go too far with these, as Tableau’s main purpose is visualization, and not data creation or modeling. However, sometimes it can be really handy to perform certain manipulations once we’ve loaded our data into Tableau and we need a certain type of analysis. The typical Tableau operators you’ll need to remember are: + (plus) for addition - (minus) For subtraction, *(star) For multiplication, / (forward slash) for division, And ^ (caret) for elevation. The logical functions available in Tableau are like the ones we have in Excel: AND, OR, and NOT A lot of the functions and symbols used in Excel can be used when creating a calculated field. So, for example, some of the most commonly used functions are SUM (for sum), AVG (for average), MIN and MAX (allowing you to find the minimum and maximum values within a range), and ABS (returning the absolute value of a number). And we already saw the text functions LEFT and RIGHT. They allow us to extract a leftmost and a rightmost number of characters within a string we’ve specified. Besides LEFT and RIGHT, we can also use the typical text functions available in Excel – MID (providing us characters that are in the middle of a text string), UPPER and LOWER (allowing us to either convert it to all uppercase characters or convert it to all lowercase characters). ► Consider hitting the SUBSCRIBE button if you LIKE the content: https://www.youtube.com/c/365DataScience?sub_confirmation=1 ► VISIT our website: https://bit.ly/365ds 🤝 Connect with us LinkedIn: https://www.linkedin.com/company/365datascience/ 365 Data Science is an online educational career website that offers the incredible opportunity to find your w