- We are using a live connection, which means that each interaction with a report will generate an SQL query and we should wait. To avoid this, we will pause Tableau Auto Updates, as shown in the following screenshot:

- Now, we can craft our report by dragging and dropping Dimensions and Measures to the canvas, as follows:
- You should add the following filters:
- C City: UNITED KI1 or UNITED KI5
- S City: UNITED KI1 or UNITED KI5
- D YEAR: Dec1997
Moreover, we should convert D Year into discrete and sort by Revenue.
- We should unpause auto updates and run our query. It takes ~18 seconds for my cluster. If we missed the time, we ...