{"id":247,"date":"2024-10-02T02:59:48","date_gmt":"2024-10-02T02:59:48","guid":{"rendered":"https:\/\/openbook.ums.edu.my\/essentialsofdatavisualizationwithtableau\/chapter\/chapter-7-motion-visualizations\/"},"modified":"2024-10-10T08:14:59","modified_gmt":"2024-10-10T08:14:59","slug":"chapter-7-motion-visualizations","status":"publish","type":"chapter","link":"https:\/\/openbook.ums.edu.my\/essentialsofdatavisualizationwithtableau\/chapter\/chapter-7-motion-visualizations\/","title":{"raw":"MOTION VISUALIZATIONS","rendered":"MOTION VISUALIZATIONS"},"content":{"raw":"
\r\n\r\n\r\n\r\n\r\n
\r\n
\r\n
\r\n

\"image\"<\/p>\r\n\r\n<\/div>\r\n<\/div><\/td>\r\n

\r\n
\r\n

By the end of this chapter, readers will be able to:<\/p>\r\n\r\n

    \r\n \t
  • Build motion line charts using Tableau<\/li>\r\n \t
  • Build race bars using Tableau<\/li>\r\n<\/ul>\r\n

    <\/p>\r\n\r\n<\/div><\/td>\r\n<\/tr>\r\n

<\/td>\r\n<\/td>\r\n<\/tr>\r\n<\/tbody>\r\n<\/table>\r\n

<\/a>M<\/strong>otion <\/strong>L<\/strong>ine <\/strong>C<\/strong>hart<\/strong><\/h2>\r\n

Motion line charts, also known as animated line charts, not only make data presentations more engaging but also allow us to observe how values fluctuate over a specific time range. This helps in identifying any exciting or abnormal value transitions. In Tableau, you can create a motion line chart by placing a date field on the Pages shelf. This will split the line chart into a series of pages, creating animations that clearly show how values change over time, such as years, quarters, or months.<\/p>\r\n\r\n

<\/a>Exercise 31<\/strong><\/h3>\r\n

Create a motion line chart to illustrate the fluctuations in total sales across different regions over various quarters and years.<\/p>\r\n

Solution - Exercise 31<\/strong><\/p>\r\n

Step 1: Drag and drop the Order Date<\/strong> onto the C<\/strong>olumn<\/strong>s<\/strong> shelf and the Sales<\/strong> field onto the Rows<\/strong> shelf. Name the resulting line chart VIZ 27<\/strong>.<\/p>\r\n

\"image\"<\/p>\r\n

Step 2: Click the down arrow next to the Order D<\/strong>ate<\/strong> field in the C<\/strong>olumn<\/strong>s<\/strong> shelf. Under the continuous date format section, choose Quarter<\/strong> to change the time frame to quarters by year.<\/p>\r\n

\"image\"<\/p>\r\n

Step 3- Change the type of marks to C<\/strong>ircle<\/strong>.<\/p>\r\n

\"image\"<\/p>\r\n

Step 4: Press and hold the Ctrl<\/strong> key, then click and drag the QUARTER(Order Date)<\/strong> field from the Rows<\/strong> shelf to the Pages<\/strong> shelf.<\/p>\r\n

\"image\"<\/p>\r\n

Step 5: Check the S<\/strong>how <\/strong>H<\/strong>istory<\/strong> box in the Pages<\/strong> card, appearing to the right of the worksheet.<\/p>\r\n

\"image\"<\/p>\r\n

Step 6: Click the down arrow next to Show History. <\/strong> For a standard animated chart, choose All<\/strong> under the Marks to Show History <\/strong>F<\/strong>or<\/strong>, and choose Both<\/strong> in the Show<\/strong> section.<\/p>\r\n

\"\"<\/p>\r\n

Step 7: Add the Region<\/strong> field to the Colour<\/strong> C<\/strong>ard<\/strong> to display different lines for each region within the same chart.<\/p>\r\n

\"image\"<\/p>\r\n

Step 8: Click the Play<\/strong> button on the Pages<\/strong> card to observe how sales fluctuate for each region across different periods. Note that we can also control the speed of the animations using the options available on the Pages<\/strong> card.<\/p>\r\n

\"image\"Speed control\r\n\"image\"<\/p>\r\n[h5p id=\"19\"]\r\n\r\n[h5p id=\"20\"]\r\n

<\/a>Race <\/strong>B<\/strong>ar<\/strong><\/h2>\r\n

Race bars help illustrate how multiple items, such as states, regions, or companies, perform or change over time. A race bar helps trace progress, evaluate growth, or detect shifts in data. In Tableau, a race bar can be created using the Pages shelf to animate changes in the data, allowing users to show how values evolve over different periods.<\/p>\r\n\r\n

<\/a>Exercise 32<\/strong><\/h3>\r\n

Construct a race bar chart to display the top ten states for each quarter and year, based on total sales.<\/p>\r\n

Solution \u2013 Exercise 32<\/strong><\/p>\r\n

Step 1: Open a new worksheet and name it VIZ 28<\/strong>. Create a calculated field for the running sales using the RUNNING_SUM<\/strong> function. Name the calculated field Running Sales<\/strong>.<\/p>\r\n

\"image\"<\/p>\r\n

Step 2: Create a calculated field using the Rank_Unique<\/strong> function to rank the running sales. Use the following expression, which incorporates the Running Sales<\/strong> field. Name the calculated field Rank<\/strong>ing<\/strong> Sales<\/strong>.<\/p>\r\n

\"image\"<\/p>\r\n

Step 3: Drag the Sales<\/strong> field onto the C<\/strong>olumn<\/strong>s<\/strong> shelf and the Ranking Sales<\/strong> field onto the Rows<\/strong> shelf. Add the State<\/strong> field to the Colour<\/strong> C<\/strong>ard<\/strong>.<\/p>\r\n

\"image\"<\/p>\r\n

Step 4: Add the Order Date<\/strong> field to the Pages<\/strong> shelf. Click the down arrow next to the added Order Date<\/strong> and choose Month<\/strong> under the continuous date options. This allows Tableau to organize the data into separate pages by month and year.<\/p>\r\n

\"image\"<\/p>\r\n

Step 5: Click the down arrow next to the Ranking Sales<\/strong> field in the Rows<\/strong> shelf. Set the Ranking Sales<\/strong> field to Discrete<\/strong>.<\/p>\r\n

\"image\"<\/p>\r\n

Step 6: Click the down arrow next to the Ranking Sales<\/strong> field in the C<\/strong>olumn<\/strong>s<\/strong> shelf and choose Edit Table Calculation<\/strong>.<\/p>\r\n

\"image\"<\/p>\r\n

Step 7 \u2013 Under Compute Using<\/strong>, choose Specific Dimensions<\/strong> to select the State<\/strong> field. Then, switch the Nested Calculations<\/strong> option to Running Sales<\/strong>, and click Specific <\/strong>Dimensions<\/strong> to choose Month of Order Date<\/strong>. Also, make sure the Running Sales<\/strong> field on the C<\/strong>olumn<\/strong>s<\/strong> shelf has the same calculation setting by verifying its Table Calculation<\/strong>; it should be computed using the Month of Order Date<\/strong>. This setup ensures that Tableau calculates the ranking sales by State<\/strong> for each Month of Order Date<\/strong>, with running sales computed by Month of Order Date<\/strong> for each State<\/strong>.<\/p>\r\n

\"image\"\"image\"<\/p>\r\n

Step 7: Copy the discrete Ranking Sales<\/strong> field from the Rows<\/strong> shelf and add it to the Filter shelf. To do this, hold the Ctrl button, click the Ranking Sales<\/strong> field in the Rows<\/strong> shelf, and drag it onto the Filter<\/strong> shelf. Then, edit the filter to display only the ten states with the highest running sales.<\/p>\r\n

\"image\"<\/p>\r\n

Step 8: Click Format<\/strong> on the toolbar and choose Animations<\/strong>. In the Animations<\/strong> setting, configure the Style and Duration of the animation according to your preferences.<\/p>\r\n

\"image\"<\/p>\r\n

Step 9: Add the State<\/strong> and Running Sales<\/strong> fields to the Label<\/strong> C<\/strong>ard<\/strong>. For an improved animation experience, save the completed race bar to your Tableau Public profile and press play in the Pages control card to see the transitions between bars at different time points.<\/p>\r\n

\"image\"<\/p>\r\n[h5p id=\"21\"]\r\n

<\/p>\r\n\r\n<\/div>","rendered":"

\n\n\n\n\n
\n
\n
\n

\"image\"<\/p>\n<\/div>\n<\/div>\n<\/td>\n

\n
\n

By the end of this chapter, readers will be able to:<\/p>\n

    \n
  • Build motion line charts using Tableau<\/li>\n
  • Build race bars using Tableau<\/li>\n<\/ul>\n

    \n<\/div>\n<\/td>\n<\/tr>\n

<\/td>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

<\/a>M<\/strong>otion <\/strong>L<\/strong>ine <\/strong>C<\/strong>hart<\/strong><\/h2>\n

Motion line charts, also known as animated line charts, not only make data presentations more engaging but also allow us to observe how values fluctuate over a specific time range. This helps in identifying any exciting or abnormal value transitions. In Tableau, you can create a motion line chart by placing a date field on the Pages shelf. This will split the line chart into a series of pages, creating animations that clearly show how values change over time, such as years, quarters, or months.<\/p>\n

<\/a>Exercise 31<\/strong><\/h3>\n

Create a motion line chart to illustrate the fluctuations in total sales across different regions over various quarters and years.<\/p>\n

Solution – Exercise 31<\/strong><\/p>\n

Step 1: Drag and drop the Order Date<\/strong> onto the C<\/strong>olumn<\/strong>s<\/strong> shelf and the Sales<\/strong> field onto the Rows<\/strong> shelf. Name the resulting line chart VIZ 27<\/strong>.<\/p>\n

\"image\"<\/p>\n

Step 2: Click the down arrow next to the Order D<\/strong>ate<\/strong> field in the C<\/strong>olumn<\/strong>s<\/strong> shelf. Under the continuous date format section, choose Quarter<\/strong> to change the time frame to quarters by year.<\/p>\n

\"image\"<\/p>\n

Step 3- Change the type of marks to C<\/strong>ircle<\/strong>.<\/p>\n

\"image\"<\/p>\n

Step 4: Press and hold the Ctrl<\/strong> key, then click and drag the QUARTER(Order Date)<\/strong> field from the Rows<\/strong> shelf to the Pages<\/strong> shelf.<\/p>\n

\"image\"<\/p>\n

Step 5: Check the S<\/strong>how <\/strong>H<\/strong>istory<\/strong> box in the Pages<\/strong> card, appearing to the right of the worksheet.<\/p>\n

\"image\"<\/p>\n

Step 6: Click the down arrow next to Show History. <\/strong> For a standard animated chart, choose All<\/strong> under the Marks to Show History <\/strong>F<\/strong>or<\/strong>, and choose Both<\/strong> in the Show<\/strong> section.<\/p>\n

\"\"<\/p>\n

Step 7: Add the Region<\/strong> field to the Colour<\/strong> C<\/strong>ard<\/strong> to display different lines for each region within the same chart.<\/p>\n

\"image\"<\/p>\n

Step 8: Click the Play<\/strong> button on the Pages<\/strong> card to observe how sales fluctuate for each region across different periods. Note that we can also control the speed of the animations using the options available on the Pages<\/strong> card.<\/p>\n

\"image\"Speed control
\n\"image\"<\/p>\n

\n