Advanced Chart Types

Motion chart

Motion charts are suitable for showing a time dependent visualization interactively or in animation:

  1. Import your dataset, and create the aforementioned Trend Chart. Our X-axis was the DateTotal (in the format of WEEK) and Cases is the Measures.

  2. All you need to do to make the Motion Chart is drag DateTotal over to the Pages shelf, and change the format again to match with the X-axis.

  3. Change the Mark Type from Automatic to Circle.

  4. Go to Show History, and select Trails to view the trend change.

Bump Chart

Although the Line chart managed to show the difference of Cases between each County, the Bump Chart gave a more clear and concise picture of the same outcome.

  1. First we need to think of the Measure on the basis of which we wish to rank our Dimensions. Here the Measure we have taken is Cases and the Dimension is County.

  2. You need the help of a Calculated Field to make Bump Charts. So quickly create a calculation as below. We are going to rank the Average of Cases for each County:

  1. Now drag DateTotal over to the Columns and change the format to WEEK. Drag County to Colour in the Marks Pane. And finally drag Rank over to the Rows.

  2. In the graph that you can see now, the Ranks have been allocated based on the number of weeks. However, we need them to be on the basis of Counties. So right click on Rank in Rows, and go to Edit Table Calculation.

  3. Since we wish to Compute Using County, change the configuration to:

  4. Finally, visualization.

Donut Chart

A donut chart is yet another representation of an elementary chart. To put it candidly, its a pie chart with a hole in the middle, but it helps put more emphasis on the various segments.

  1. We will begin with a simple Pie Chart depicting the Cases of each County.

  2. To create a Dual Axis for the Pie Chart, drag Deaths from Measures over to the Rows, twice. Change the Measure of each green pill, by right clicking on them and choosing Minimum in place of the default Sum:.

  3. Choose the second Pie Chart in the Marks Pane, and drag every Measure / Dimension out of it. Reduce the size of the chart, and change the color to white.

  4. To create the Dual axis, right click on the second Pie Charts’ Y – Axis, and select the Dual Axis, to get your chart.

Waterfall Chart

A waterfall chart derives its name from its analogous orientation and flow. Here we have plotted the Moving Averages of the Cases of COVID-19 over time. Waterfall charts are used to analyze the cumulative effect of a Measure, and see how it increases and decreases as a whole. To understand this better, let’s visualize it. A waterfall chart is a derivative of a Line Chart.

  1. Create a line chart by using DateTotal aggregated to weekly level and AVG(Cases).

  2. Create a calculated field and call it NegCases and put it in the Markers as Size and change its aggregation to Median.

  3. Put Cases in the Markers as Color.

Pareto Chart

Pareto chart is essentially combination of line and bar charts. Use Dual Axis and put the line on the previous chart as:

The workbook to reproduce the visualizations in this section is shared here: https://bit.ly/3lo0vT8