We're using data from the city of Chicago to see how many potholes are identified and how many are fixed. Use Waterfall.tbwx and Potholes.csv to follow along:
- Create a line or bar chart with one dimension and one measure—Activity Date and Potholes—as follows:
- Apply a Running Total measure under Quick Table Calculation for Potholes, as shown in the following screenshot:
- Change the Marks type to Gantt Bar, as shown in the following screenshot:
- Create bars by sizing the mark with a negative version of the same measure. ...
