25 Jan 2022

Want to Get Latest Updates and Tips on Tableau Blogs

25 jan 2022 vimeo thumbnail

We looked at how you can change the date properties of a field to be an April start date.

We then looked at overcoming common challenges when connecting to Excel data sources, including
➡️ empty rows and columns
➡️ the need to remove totals and sub-totals
➡️ pivoting multiple columns of months into a single date field of measures
➡️ Excel sheets that have multiple tables of data, or tables of data being hard to locate for Tableau

We also looked at how Tableau calculated fields operate
➡️ creating a simple ratio,
➡️ row and aggregate level calculations
➡️ how to emulate the “SUMIF()” calculation in Tableau
➡️ overcoming the common “Cannot mix aggregate with non-aggregate” error message.

Share This Post:

001 database

Tableau Desktop Analyst

002 bar chart

Tableau Desktop Foundation

003 network

Tableau Training
on Tap

Share :

Leave a Comment

Your email address will not be published. Required fields are marked *