Reminder

All sessions are recorded and saved to the OneDrive link above.

What should I use to show the date time the user ran the report?

Now() is showing 1/1/1900 12:00:00.000 = Sarah will open a ticket with

Today() is showing just the date

Tableau Date Functions: https://help.tableau.com/current/pro/desktop/en-us/functions_functions_date.htm?_gl=1*g2dpmk*_ga*MTA0NTAwMzY0OS4xNzI4NDIzNDQ1*_ga_8YLN0SNXVS*MTczMjEyNTgyOS4xNi4xLjE3MzIxMjU5MDQuMC4wLjA.#now

Why is Tableau displaying the word ‘Null’?

when you use an if/then/end equation without telling Tableau what to display when the criteria doesn’t match Tableau will display Null

You can use if/then/else/end to tell Tableau what to display

Demo of Blending Data in Tableau

See recording for details

First data source added to a Sheet is the driver for that sheet.

Create 2 sheets and start with a different data source per sheet to see how Tableau works.

Data sources with 1 row per person blended with multiple rows per person with either need more filters and/or the sheet needs to start with the data source that has more rows.

How can I hide ‘Null’ from the filter my customer’s pick from?

Options

1. Create a copy of the field and exclude null in the filters, then update the original filter to only show relevant values

2. Create a copy of the field and exclude null on the data source tab, use with caution

3. Create a copy of the field and use calculation ifnull(Field, ‘No Value’) which will move the null to a new position alphabetically

https://tarsolutions.co.uk/blog/null-functions-in-tableau/