Reference: https://www.w3schools.com/sql/sql_join_left.asp

The visualization updates to look like this:

Apply the quick table calculation

1) On the Marks card, right-click SUM(Profit) and select Quick Table Calculation > Moving Average. Note: You can only perform quick table calculations on measures in the view.

A delta symbol appears on the field to indicate that a quick table calculation is being applied to the field. The colors in the visualization update to show the moving average of profit across the years.

Reference: https://help.tableau.com/current/pro/desktop/en-us/calculations_tablecalculations_quick.htm

Reference: https://www.tutorialspoint.com/tableau/tableau_data_blending.htm

Reference: https://help.tableau.com/current/pro/desktop/en-us/order_of_operations.htm

Step 2: Select a time unit

In the Filter dialog box, click Relative dates, and then select the unit of time for the filter.

For example, to show only the three most recent weeks, select Weeks.

Here, you can clearly see that the default date is TODAY

Reference: https://help.tableau.com/current/pro/desktop/en-us/qs_relative_dates.htm

Here, State and City are Strings, but Postal Code? Nope. It’s an Integer. So we can simply use the STR() function to convert it into a String, and hence the entire equation becomes valid!

Reference: https://help.tableau.com/current/pro/desktop/en-us/actions_dashboards.htm

Reference: https://help.tableau.com/current/reader/desktop/en-us/reader_welcome.htm