Let's ask questions with Tableau. For example, we want to know the revenue in specific cities (UNITED KI5, UNITED KI1) in December 1997. Moreover, we want to order the result by revenue amount in descending order.
Creating a Tableau report
How to do it...
- 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...