{"id":172,"date":"2024-10-02T02:59:19","date_gmt":"2024-10-02T02:59:19","guid":{"rendered":"https:\/\/openbook.ums.edu.my\/essentialsofdatavisualizationwithtableau\/chapter\/chapter-5-calculations-in-tableau\/"},"modified":"2024-10-10T03:39:25","modified_gmt":"2024-10-10T03:39:25","slug":"chapter-5-calculations-in-tableau","status":"publish","type":"chapter","link":"https:\/\/openbook.ums.edu.my\/essentialsofdatavisualizationwithtableau\/chapter\/chapter-5-calculations-in-tableau\/","title":{"raw":"CALCULATIONS IN TABLEAU","rendered":"CALCULATIONS IN TABLEAU"},"content":{"raw":"<div class=\"chapter-5:-calculations-in-tableau\">\r\n<table>\r\n<tbody>\r\n<tr class=\"GridTable4-Accent5-R\" style=\"height: 0\">\r\n<td class=\"GridTable4-Accent5-C\" style=\"background-color: #5b9bd5;border-top: solid #5B9BD5 0.5pt;border-bottom: solid #5B9BD5 0.5pt;border-right: none windowtext 0pt;border-left: solid #5B9BD5 0.5pt\">\r\n<div class=\"GridTable4-Accent5-firstCol\">\r\n<div class=\"GridTable4-Accent5-firstRow\">\r\n<p class=\"import-Normal\"><img src=\"https:\/\/openbook.ums.edu.my\/essentialsofdatavisualizationwithtableau\/wp-content\/uploads\/sites\/190\/2024\/10\/image1-4.png\" alt=\"image\" width=\"96px\" height=\"96px\" \/><\/p>\r\n\r\n<\/div>\r\n<\/div><\/td>\r\n<td class=\"GridTable4-Accent5-C\" style=\"background-color: #5b9bd5;border: solid #9CC2E5 0.5pt\">\r\n<div class=\"GridTable4-Accent5-firstRow\">\r\n<p class=\"import-Normal\">By the end of this chapter, readers will be able to:<\/p>\r\n\r\n<ul>\r\n \t<li>Perform simple calculations in Tableau using Quick Calculation Table<\/li>\r\n \t<li>Create new calculated fields<\/li>\r\n<\/ul>\r\n<\/div><\/td>\r\n<\/tr>\r\n<tr>\r\n<td><\/td>\r\n<td><\/td>\r\n<\/tr>\r\n<\/tbody>\r\n<\/table>\r\n<h2><a id=\"_Toc170398204\"><\/a><a id=\"_Toc178253028\"><\/a><strong>Quick <\/strong><strong>C<\/strong><strong>alculation <\/strong><strong>T<\/strong><strong>able<\/strong><\/h2>\r\n<p class=\"import-Normal\" style=\"text-align: justify\">In Tableau, the <strong>Quick Calculation<\/strong> <strong>Table<\/strong> feature offers a convenient way to perform common calculations immediately without the need to write complex formulas manually. <strong>Quick Calculation Table<\/strong> can be accessed by clicking the down arrow next to each field available in the <strong>D<\/strong><strong>ata <\/strong><strong>P<\/strong><strong>ane<\/strong>. When users choose the <strong>Quick Calculation Table<\/strong>, a list of common calculations that users may want to apply to the selected field appears. These calculations include:<\/p>\r\n\r\n<ul>\r\n \t<li><strong>Percent of Total<\/strong>: Calculates the percentage of each value in the selected field relative to the total.<\/li>\r\n \t<li><strong>Running Total<\/strong>: Computes the cumulative total of the values in the selected field.<\/li>\r\n \t<li><strong>Difference<\/strong>: Calculates the difference between consecutive values in the selected field.<\/li>\r\n \t<li><strong>Percent Difference<\/strong>: Computes the percentage difference between consecutive values in the selected field.<\/li>\r\n \t<li><strong>Rank<\/strong>: Assigns a rank to each value in the selected field based on specified criteria.<\/li>\r\n<\/ul>\r\n<h3><a id=\"_Toc170398205\"><\/a><a id=\"_Toc178253029\"><\/a>Exercise 18<\/h3>\r\n<p class=\"import-Normal\" style=\"text-align: justify\">Create a pie chart showing the total percentage of sales contributed by each segment of customers. Rename the chart to <strong>VIZ 13<\/strong>. What is the total percentage of sales contributed by the home office segment?<\/p>\r\n<p class=\"import-Normal\" style=\"text-align: justify\"><strong>Solution \u2013 Exercise 18<\/strong><\/p>\r\n<p class=\"import-Normal\" style=\"text-align: justify\">Step 1: Open a new worksheet and rename it to <strong>VIZ 13<\/strong>. Click both the <strong>Segment<\/strong> and <strong>Sales<\/strong> fields in the <strong>Data Pane<\/strong> by holding the <strong>Ctrl<\/strong> button. Under <strong>Show Me<\/strong>, choose the <strong>Pie Chart<\/strong> icon.<\/p>\r\n<p class=\"import-Normal\" style=\"text-align: center\"><img class=\"aligncenter\" src=\"https:\/\/openbook.ums.edu.my\/essentialsofdatavisualizationwithtableau\/wp-content\/uploads\/sites\/190\/2024\/10\/image126.png\" alt=\"image\" width=\"728\" height=\"298\" \/><\/p>\r\n<p class=\"import-Normal\" style=\"text-align: justify\">Step 2: Name the pie chart <strong>VIZ 13<\/strong>. Drag and drop the <strong>Sales <\/strong>field to the <strong>L<\/strong><strong>abel<\/strong> <strong>C<\/strong><strong>ard<\/strong> to add total sales information to the pie chart.<\/p>\r\n<p class=\"import-Normal\" style=\"text-align: justify\"><img class=\"aligncenter\" src=\"https:\/\/openbook.ums.edu.my\/essentialsofdatavisualizationwithtableau\/wp-content\/uploads\/sites\/190\/2024\/10\/image127.png\" alt=\"image\" width=\"696\" height=\"255\" \/><\/p>\r\n<p class=\"import-Normal\" style=\"text-align: justify\">Step 3: Click the down arrow next to the <strong>Sales<\/strong> field added to<strong> Label <\/strong><strong>C<\/strong><strong>ard,<\/strong> choose <strong>Quick Table Calculation<\/strong>, and pick <strong>Percent of Total<\/strong>.<\/p>\r\n<p class=\"import-Normal\" style=\"text-align: center\"><img class=\"aligncenter\" src=\"https:\/\/openbook.ums.edu.my\/essentialsofdatavisualizationwithtableau\/wp-content\/uploads\/sites\/190\/2024\/10\/image128.png\" alt=\"image\" width=\"483\" height=\"422\" \/><\/p>\r\n<p class=\"import-Normal\" style=\"text-align: justify\">Step 4: The pie chart now shows the percentage of sales for each segment relative to total sales. It is clear that the home office segment accounted for just 18.70% of the overall sales.<\/p>\r\n<p class=\"import-Normal\" style=\"text-align: center\"><img class=\"aligncenter\" src=\"https:\/\/openbook.ums.edu.my\/essentialsofdatavisualizationwithtableau\/wp-content\/uploads\/sites\/190\/2024\/10\/image129.png\" alt=\"image\" width=\"374\" height=\"258\" \/><\/p>\r\n\r\n<h3><a id=\"_Toc178253030\"><\/a><strong>Exercise<\/strong><strong> 19<\/strong><\/h3>\r\n<p class=\"import-Normal\" style=\"text-align: justify\">Generate a line chart illustrating <strong>sales<\/strong> by <strong>quarter per year <\/strong>and name it <strong>VIZ 14<\/strong>. Apply the <strong>Percentage Difference<\/strong> available in the <strong>Quick Table Calculation<\/strong> to determine which quarter and year experienced a significant decrease in sales compared to the preceding period, and indicate the percentage of the decline.<\/p>\r\n<p class=\"import-Normal\" style=\"text-align: justify\"><strong>Solution \u2013 Exercise 19<\/strong><\/p>\r\n<p class=\"import-Normal\" style=\"text-align: justify\">Step 1: Add <strong>Order Date<\/strong> to the <strong>C<\/strong><strong>olumn<\/strong><strong>s<\/strong> shelf and <strong>Sales<\/strong> to the <strong>Rows<\/strong> shelf, then rename the worksheet to <strong>VIZ 14<\/strong>. Click the down arrow next to the <strong>Order Date<\/strong> field available on the <strong>Columns<\/strong> shelf. Switch the <strong>Order Date<\/strong> format from <strong>Year<\/strong> to <strong>Quarter &amp; Year<\/strong>. As the <strong>Order Date<\/strong> is now set as a continuous field, a line chart (not a bar graph) will automatically display.<\/p>\r\n<p class=\"import-Normal\" style=\"text-align: center\"><img class=\"aligncenter\" src=\"https:\/\/openbook.ums.edu.my\/essentialsofdatavisualizationwithtableau\/wp-content\/uploads\/sites\/190\/2024\/10\/image130.png\" alt=\"image\" width=\"220\" height=\"552\" \/><\/p>\r\n<p class=\"import-Normal\" style=\"text-align: justify\">Step 2: Add <strong>Sales<\/strong> to the <strong>L<\/strong><strong>abel<\/strong> <strong>C<\/strong><strong>ard<\/strong>. Click the down arrow next to the added <strong>Sales <\/strong>field, choose <strong>Quick Table Calculation<\/strong>, and then select <strong>Percent Difference<\/strong>.<\/p>\r\n<p class=\"import-Normal\" style=\"text-align: center\"><img class=\"aligncenter\" src=\"https:\/\/openbook.ums.edu.my\/essentialsofdatavisualizationwithtableau\/wp-content\/uploads\/sites\/190\/2024\/10\/image131.png\" alt=\"image\" width=\"405\" height=\"370\" \/><\/p>\r\n<p class=\"import-Normal\" style=\"text-align: justify\">Step 3: The line chart now displays the percentage change in sales for each quarter of the year compared to the previous time point. It indicates a significant decline in sales during Q1 2019, with a decrease of -61.7% from the prior quarter.<\/p>\r\n<p class=\"import-Normal\" style=\"text-align: justify\"><img class=\"aligncenter\" src=\"https:\/\/openbook.ums.edu.my\/essentialsofdatavisualizationwithtableau\/wp-content\/uploads\/sites\/190\/2024\/10\/image132.png\" alt=\"image\" width=\"699\" height=\"354\" \/><\/p>\r\n\r\n<h3><a id=\"_Toc170398207\"><\/a><a id=\"_Toc178253031\"><\/a><strong>Exercise<\/strong><strong> 20<\/strong><\/h3>\r\n<p class=\"import-Normal\" style=\"text-align: justify\">Using the <strong>Quick Calculation Table<\/strong>, find the rank of bookcases among the other sub-categories in terms of total profit earned.<\/p>\r\n<p class=\"import-Normal\" style=\"text-align: justify\"><strong>Solution - Exercise 20<\/strong><\/p>\r\n<p class=\"import-Normal\" style=\"text-align: justify\">Step 1: Create a bar graph showing the total profit vs. sub-categories. Name it <strong>VIZ 15<\/strong>. Drop the <strong>P<\/strong><strong>rofit<\/strong> field to the <strong>L<\/strong><strong>abel <\/strong><strong>C<\/strong><strong>ard<\/strong>.<\/p>\r\n<p class=\"import-Normal\" style=\"text-align: justify\"><img class=\"aligncenter\" src=\"https:\/\/openbook.ums.edu.my\/essentialsofdatavisualizationwithtableau\/wp-content\/uploads\/sites\/190\/2024\/10\/image133.png\" alt=\"image\" width=\"708\" height=\"357\" \/><\/p>\r\n<p class=\"import-Normal\" style=\"text-align: justify\">Step 2: Click the down arrow next to the <strong>Sales<\/strong> field on <strong>Label<\/strong> <strong>C<\/strong><strong>ard<\/strong>, choose the <strong>Quick Table Calculation<\/strong>, and then select <strong>Rank<\/strong>.<\/p>\r\n<p class=\"import-Normal\" style=\"text-align: center\"><img class=\"aligncenter\" src=\"https:\/\/openbook.ums.edu.my\/essentialsofdatavisualizationwithtableau\/wp-content\/uploads\/sites\/190\/2024\/10\/image134.png\" alt=\"image\" width=\"397\" height=\"372\" \/><\/p>\r\n<p class=\"import-Normal\" style=\"text-align: justify\">Step 3: The bar graph displays the rank of each sub-category item. Based on the bar graph, bookcases ranked at the 16<sup>th<\/sup> position in terms of profitability.<\/p>\r\n<p class=\"import-Normal\" style=\"text-align: justify\"><img class=\"aligncenter\" src=\"https:\/\/openbook.ums.edu.my\/essentialsofdatavisualizationwithtableau\/wp-content\/uploads\/sites\/190\/2024\/10\/image135.png\" alt=\"image\" width=\"717\" height=\"367\" \/><\/p>\r\n[h5p id=\"17\"]\r\n<h2><a id=\"_Toc178253032\"><\/a><strong>Calculated <\/strong><strong>F<\/strong><strong>ield<\/strong><strong>s<\/strong><\/h2>\r\n<p class=\"import-Normal\" style=\"text-align: justify\">Tableau users have the option to process the current data within a data source to generate a new field, which may be necessary for further analysis. This new field, known as a calculated field, can be created using various mathematical functions available in Tableau. These functions fall into several categories, including basic arithmetic, statistical, logical, date, and string functions.<\/p>\r\n\r\n<h3><a id=\"_Toc178253033\"><\/a><strong>Exercise 21<\/strong><\/h3>\r\n<p class=\"import-Normal\" style=\"text-align: justify\">Create a calculated field using the existing data to represent the cost for each order. Note that, cost = sales \u2013 profit. Construct a bar chart to display the average cost per sub-category. Which sub-category item has the largest average cost?<\/p>\r\n<p class=\"import-Normal\" style=\"text-align: justify\"><strong>Solution \u2013 Exercise 21<\/strong><\/p>\r\n<p class=\"import-Normal\" style=\"text-align: justify\">Step 1: Click the down arrow at the top right corner of the <strong>D<\/strong><strong>ata <\/strong><strong>P<\/strong><strong>ane<\/strong> and choose <strong>Create Calculated Field<\/strong>.<\/p>\r\n<p class=\"import-Normal\" style=\"text-align: center\"><img class=\"aligncenter\" src=\"https:\/\/openbook.ums.edu.my\/essentialsofdatavisualizationwithtableau\/wp-content\/uploads\/sites\/190\/2024\/10\/image136.png\" alt=\"image\" width=\"201\" height=\"285\" \/><\/p>\r\n<p class=\"import-Normal\" style=\"text-align: justify\">Step 2: Name the new field <strong>C<\/strong><strong>ost<\/strong>, and enter the needed formula in the available calculation space. Note that the fields required in the formula appear as we type them. Tableau alerts us if the entered formula is invalid either because of illogical calculations or if its expression does not meet Tableau's calculation language.<\/p>\r\n<p class=\"import-Normal\" style=\"text-align: center\"><img class=\"aligncenter\" src=\"https:\/\/openbook.ums.edu.my\/essentialsofdatavisualizationwithtableau\/wp-content\/uploads\/sites\/190\/2024\/10\/image137.png\" alt=\"image\" width=\"543\" height=\"257\" \/><\/p>\r\n<p class=\"import-Normal\" style=\"text-align: justify\">Step 3: Once clicking <strong>OK<\/strong>, the newly created calculated will appear in the <strong>D<\/strong><strong>ata <\/strong><strong>P<\/strong><strong>ane<\/strong>.<\/p>\r\n<p class=\"import-Normal\" style=\"text-align: center\"><img class=\"aligncenter\" src=\"https:\/\/openbook.ums.edu.my\/essentialsofdatavisualizationwithtableau\/wp-content\/uploads\/sites\/190\/2024\/10\/image138.png\" alt=\"image\" width=\"212\" height=\"148\" \/><\/p>\r\n<p class=\"import-Normal\" style=\"text-align: justify\">Step 4: To create the cost vs. sub-category graph, drag and drop the <strong>C<\/strong><strong>ost<\/strong> and <strong>S<\/strong><strong>ub-<\/strong><strong>C<\/strong><strong>ategory<\/strong> fields onto the <strong>C<\/strong><strong>olumn<\/strong><strong>s<\/strong> and <strong>Rows<\/strong> shelf, respectively. Name it <strong>VIZ<\/strong> <strong>16<\/strong>. Change the aggregation type of cost from sum to average. Also, drop the <strong>C<\/strong><strong>ost<\/strong> field to the <strong>L<\/strong><strong>abel <\/strong><strong>C<\/strong><strong>ard<\/strong> and ensure the aggregation is set to average. The graph points out machine has the highest average cost with $1616, followed by copiers, and Tables.<\/p>\r\n<p class=\"import-Normal\" style=\"text-align: justify\"><img class=\"aligncenter\" src=\"https:\/\/openbook.ums.edu.my\/essentialsofdatavisualizationwithtableau\/wp-content\/uploads\/sites\/190\/2024\/10\/image139.png\" alt=\"image\" width=\"700\" height=\"351\" \/><\/p>\r\n\r\n<h3><a id=\"_Toc178253034\"><\/a><strong>Exercise 22<\/strong><\/h3>\r\n<p class=\"import-Normal\" style=\"text-align: justify\">Create a calculated field to classify the sub-category items as \"High profit\", \"Moderate profit\", \"Low profit\", and \"Loss\". Apply the conditions listed in the following table for the classification. Also, generate a chart depicting the total profit versus sub-category, and integrate the classification information into the chart. What are the sub-category items that are classified as \"Loss\" items?<\/p>\r\n\r\n<table style=\"width: 685px\">\r\n<tbody>\r\n<tr class=\"ListTable2-Accent1-R\" style=\"height: 0\">\r\n<td class=\"ListTable2-Accent1-C\" style=\"border-top: 0.5pt solid #8eaadb;border-bottom: 0.5pt solid #8eaadb;width: 187.656px\">\r\n<div class=\"ListTable2-Accent1-firstCol\">\r\n<div class=\"ListTable2-Accent1-firstRow\">\r\n<p class=\"import-Normal\" style=\"text-align: justify\">Classification<\/p>\r\n\r\n<\/div>\r\n<\/div><\/td>\r\n<td class=\"ListTable2-Accent1-C\" style=\"border-top: 0.5pt solid #8eaadb;border-bottom: 0.5pt solid #8eaadb;width: 470.094px\">\r\n<div class=\"ListTable2-Accent1-firstRow\">\r\n<p class=\"import-Normal\" style=\"text-align: justify\">Condition<\/p>\r\n\r\n<\/div><\/td>\r\n<\/tr>\r\n<tr class=\"ListTable2-Accent1-R\" style=\"height: 0\">\r\n<td class=\"ListTable2-Accent1-C\" style=\"background-color: #d9e2f3;border-top: 0.5pt solid #8eaadb;border-bottom: 0.5pt solid #8eaadb;width: 187.656px\">\r\n<div class=\"ListTable2-Accent1-band1Horz\">\r\n<div class=\"ListTable2-Accent1-firstCol\">\r\n<p class=\"import-Normal\" style=\"text-align: justify\">High profit<\/p>\r\n\r\n<\/div>\r\n<\/div><\/td>\r\n<td class=\"ListTable2-Accent1-C\" style=\"background-color: #d9e2f3;border-top: 0.5pt solid #8eaadb;border-bottom: 0.5pt solid #8eaadb;width: 470.094px\">\r\n<div class=\"ListTable2-Accent1-band1Horz\">\r\n<p class=\"import-Normal\" style=\"text-align: justify\">Total profit is $30,000 and above.<\/p>\r\n\r\n<\/div><\/td>\r\n<\/tr>\r\n<tr class=\"ListTable2-Accent1-R\">\r\n<td class=\"ListTable2-Accent1-C\" style=\"border-top: 0.5pt solid #8eaadb;border-bottom: 0.5pt solid #8eaadb;width: 187.656px\">\r\n<div class=\"ListTable2-Accent1-firstCol\">\r\n<p class=\"import-Normal\" style=\"text-align: justify\">Moderate profit<\/p>\r\n\r\n<\/div><\/td>\r\n<td class=\"ListTable2-Accent1-C\" style=\"border-top: 0.5pt solid #8eaadb;border-bottom: 0.5pt solid #8eaadb;width: 470.094px\">\r\n<p class=\"import-Normal\" style=\"text-align: left\">Total profit is $10,000 and above.<\/p>\r\n<\/td>\r\n<\/tr>\r\n<tr class=\"ListTable2-Accent1-R\" style=\"height: 0\">\r\n<td class=\"ListTable2-Accent1-C\" style=\"background-color: #d9e2f3;border-top: 0.5pt solid #8eaadb;border-bottom: 0.5pt solid #8eaadb;width: 187.656px\">\r\n<div class=\"ListTable2-Accent1-band1Horz\">\r\n<div class=\"ListTable2-Accent1-firstCol\">\r\n<p class=\"import-Normal\" style=\"text-align: justify\">Low profit<\/p>\r\n\r\n<\/div>\r\n<\/div><\/td>\r\n<td class=\"ListTable2-Accent1-C\" style=\"background-color: #d9e2f3;border-top: 0.5pt solid #8eaadb;border-bottom: 0.5pt solid #8eaadb;width: 470.094px\">\r\n<div class=\"ListTable2-Accent1-band1Horz\">\r\n<p class=\"import-Normal\" style=\"text-align: justify\">Total profit is $0 and above.<\/p>\r\n\r\n<\/div><\/td>\r\n<\/tr>\r\n<tr class=\"ListTable2-Accent1-R\">\r\n<td class=\"ListTable2-Accent1-C\" style=\"border-top: 0.5pt solid #8eaadb;border-bottom: 0.5pt solid #8eaadb;width: 187.656px\">\r\n<div class=\"ListTable2-Accent1-firstCol\">\r\n<p class=\"import-Normal\" style=\"text-align: justify\">Loss<\/p>\r\n\r\n<\/div><\/td>\r\n<td class=\"ListTable2-Accent1-C\" style=\"border-top: 0.5pt solid #8eaadb;border-bottom: 0.5pt solid #8eaadb;width: 470.094px\">\r\n<p class=\"import-Normal\" style=\"text-align: justify\">Total profit is below $0.<\/p>\r\n<\/td>\r\n<\/tr>\r\n<tr>\r\n<td style=\"width: 187.656px\"><\/td>\r\n<td style=\"width: 470.094px\"><\/td>\r\n<\/tr>\r\n<\/tbody>\r\n<\/table>\r\n<p class=\"import-Normal\"><strong>Solution \u2013 Exercise 22<\/strong><\/p>\r\n<p class=\"import-Normal\" style=\"text-align: justify\">Step 1: Create a calculated field using the logical functions, e.g., IF, THEN, and ELSE, to classify the sub-category items based on the conditions given. Name the field <strong>Profit <\/strong><strong>C<\/strong><strong>lassification<\/strong>.<\/p>\r\n<p class=\"import-Normal\" style=\"text-align: center\"><img class=\"aligncenter\" src=\"https:\/\/openbook.ums.edu.my\/essentialsofdatavisualizationwithtableau\/wp-content\/uploads\/sites\/190\/2024\/10\/image140.png\" alt=\"image\" width=\"605\" height=\"301\" \/><\/p>\r\n<p class=\"import-Normal\" style=\"text-align: justify\">Step 2: Open a new worksheet and rename it to <strong>VIZ 17<\/strong>. Construct a bar graph depicting the total profit versus sub-category.<\/p>\r\n<p class=\"import-Normal\" style=\"text-align: justify\">Step 3: Drag and drop the <strong>Profit <\/strong><strong>Classification<\/strong> field to the <strong>C<\/strong><strong>olour<\/strong> and <strong>L<\/strong><strong>abel <\/strong><strong>C<\/strong><strong>ards<\/strong> to distinguish each sub-category according to its classification. The chart tells that bookcases, supplies, and tables are three sub-category items classified as \"Loss\".<\/p>\r\n<p class=\"import-Normal\" style=\"text-align: justify\"><img class=\"aligncenter\" src=\"https:\/\/openbook.ums.edu.my\/essentialsofdatavisualizationwithtableau\/wp-content\/uploads\/sites\/190\/2024\/10\/image141.png\" alt=\"image\" width=\"726\" height=\"315\" \/><\/p>\r\n[h5p id=\"16\"]\r\n<p class=\"import-Normal\" style=\"text-align: justify\"><\/p>\r\n\r\n<\/div>","rendered":"<div class=\"chapter-5:-calculations-in-tableau\">\n<table>\n<tbody>\n<tr class=\"GridTable4-Accent5-R\" style=\"height: 0\">\n<td class=\"GridTable4-Accent5-C\" style=\"background-color: #5b9bd5;border-top: solid #5B9BD5 0.5pt;border-bottom: solid #5B9BD5 0.5pt;border-right: none windowtext 0pt;border-left: solid #5B9BD5 0.5pt\">\n<div class=\"GridTable4-Accent5-firstCol\">\n<div class=\"GridTable4-Accent5-firstRow\">\n<p class=\"import-Normal\"><img decoding=\"async\" src=\"https:\/\/openbook.ums.edu.my\/essentialsofdatavisualizationwithtableau\/wp-content\/uploads\/sites\/190\/2024\/10\/image1-4.png\" alt=\"image\" width=\"96px\" height=\"96px\" \/><\/p>\n<\/div>\n<\/div>\n<\/td>\n<td class=\"GridTable4-Accent5-C\" style=\"background-color: #5b9bd5;border: solid #9CC2E5 0.5pt\">\n<div class=\"GridTable4-Accent5-firstRow\">\n<p class=\"import-Normal\">By the end of this chapter, readers will be able to:<\/p>\n<ul>\n<li>Perform simple calculations in Tableau using Quick Calculation Table<\/li>\n<li>Create new calculated fields<\/li>\n<\/ul>\n<\/div>\n<\/td>\n<\/tr>\n<tr>\n<td><\/td>\n<td><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h2><a id=\"_Toc170398204\"><\/a><a id=\"_Toc178253028\"><\/a><strong>Quick <\/strong><strong>C<\/strong><strong>alculation <\/strong><strong>T<\/strong><strong>able<\/strong><\/h2>\n<p class=\"import-Normal\" style=\"text-align: justify\">In Tableau, the <strong>Quick Calculation<\/strong> <strong>Table<\/strong> feature offers a convenient way to perform common calculations immediately without the need to write complex formulas manually. <strong>Quick Calculation Table<\/strong> can be accessed by clicking the down arrow next to each field available in the <strong>D<\/strong><strong>ata <\/strong><strong>P<\/strong><strong>ane<\/strong>. When users choose the <strong>Quick Calculation Table<\/strong>, a list of common calculations that users may want to apply to the selected field appears. These calculations include:<\/p>\n<ul>\n<li><strong>Percent of Total<\/strong>: Calculates the percentage of each value in the selected field relative to the total.<\/li>\n<li><strong>Running Total<\/strong>: Computes the cumulative total of the values in the selected field.<\/li>\n<li><strong>Difference<\/strong>: Calculates the difference between consecutive values in the selected field.<\/li>\n<li><strong>Percent Difference<\/strong>: Computes the percentage difference between consecutive values in the selected field.<\/li>\n<li><strong>Rank<\/strong>: Assigns a rank to each value in the selected field based on specified criteria.<\/li>\n<\/ul>\n<h3><a id=\"_Toc170398205\"><\/a><a id=\"_Toc178253029\"><\/a>Exercise 18<\/h3>\n<p class=\"import-Normal\" style=\"text-align: justify\">Create a pie chart showing the total percentage of sales contributed by each segment of customers. Rename the chart to <strong>VIZ 13<\/strong>. What is the total percentage of sales contributed by the home office segment?<\/p>\n<p class=\"import-Normal\" style=\"text-align: justify\"><strong>Solution \u2013 Exercise 18<\/strong><\/p>\n<p class=\"import-Normal\" style=\"text-align: justify\">Step 1: Open a new worksheet and rename it to <strong>VIZ 13<\/strong>. Click both the <strong>Segment<\/strong> and <strong>Sales<\/strong> fields in the <strong>Data Pane<\/strong> by holding the <strong>Ctrl<\/strong> button. Under <strong>Show Me<\/strong>, choose the <strong>Pie Chart<\/strong> icon.<\/p>\n<p class=\"import-Normal\" style=\"text-align: center\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter\" src=\"https:\/\/openbook.ums.edu.my\/essentialsofdatavisualizationwithtableau\/wp-content\/uploads\/sites\/190\/2024\/10\/image126.png\" alt=\"image\" width=\"728\" height=\"298\" \/><\/p>\n<p class=\"import-Normal\" style=\"text-align: justify\">Step 2: Name the pie chart <strong>VIZ 13<\/strong>. Drag and drop the <strong>Sales <\/strong>field to the <strong>L<\/strong><strong>abel<\/strong> <strong>C<\/strong><strong>ard<\/strong> to add total sales information to the pie chart.<\/p>\n<p class=\"import-Normal\" style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter\" src=\"https:\/\/openbook.ums.edu.my\/essentialsofdatavisualizationwithtableau\/wp-content\/uploads\/sites\/190\/2024\/10\/image127.png\" alt=\"image\" width=\"696\" height=\"255\" \/><\/p>\n<p class=\"import-Normal\" style=\"text-align: justify\">Step 3: Click the down arrow next to the <strong>Sales<\/strong> field added to<strong> Label <\/strong><strong>C<\/strong><strong>ard,<\/strong> choose <strong>Quick Table Calculation<\/strong>, and pick <strong>Percent of Total<\/strong>.<\/p>\n<p class=\"import-Normal\" style=\"text-align: center\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter\" src=\"https:\/\/openbook.ums.edu.my\/essentialsofdatavisualizationwithtableau\/wp-content\/uploads\/sites\/190\/2024\/10\/image128.png\" alt=\"image\" width=\"483\" height=\"422\" \/><\/p>\n<p class=\"import-Normal\" style=\"text-align: justify\">Step 4: The pie chart now shows the percentage of sales for each segment relative to total sales. It is clear that the home office segment accounted for just 18.70% of the overall sales.<\/p>\n<p class=\"import-Normal\" style=\"text-align: center\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter\" src=\"https:\/\/openbook.ums.edu.my\/essentialsofdatavisualizationwithtableau\/wp-content\/uploads\/sites\/190\/2024\/10\/image129.png\" alt=\"image\" width=\"374\" height=\"258\" \/><\/p>\n<h3><a id=\"_Toc178253030\"><\/a><strong>Exercise<\/strong><strong> 19<\/strong><\/h3>\n<p class=\"import-Normal\" style=\"text-align: justify\">Generate a line chart illustrating <strong>sales<\/strong> by <strong>quarter per year <\/strong>and name it <strong>VIZ 14<\/strong>. Apply the <strong>Percentage Difference<\/strong> available in the <strong>Quick Table Calculation<\/strong> to determine which quarter and year experienced a significant decrease in sales compared to the preceding period, and indicate the percentage of the decline.<\/p>\n<p class=\"import-Normal\" style=\"text-align: justify\"><strong>Solution \u2013 Exercise 19<\/strong><\/p>\n<p class=\"import-Normal\" style=\"text-align: justify\">Step 1: Add <strong>Order Date<\/strong> to the <strong>C<\/strong><strong>olumn<\/strong><strong>s<\/strong> shelf and <strong>Sales<\/strong> to the <strong>Rows<\/strong> shelf, then rename the worksheet to <strong>VIZ 14<\/strong>. Click the down arrow next to the <strong>Order Date<\/strong> field available on the <strong>Columns<\/strong> shelf. Switch the <strong>Order Date<\/strong> format from <strong>Year<\/strong> to <strong>Quarter &amp; Year<\/strong>. As the <strong>Order Date<\/strong> is now set as a continuous field, a line chart (not a bar graph) will automatically display.<\/p>\n<p class=\"import-Normal\" style=\"text-align: center\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter\" src=\"https:\/\/openbook.ums.edu.my\/essentialsofdatavisualizationwithtableau\/wp-content\/uploads\/sites\/190\/2024\/10\/image130.png\" alt=\"image\" width=\"220\" height=\"552\" \/><\/p>\n<p class=\"import-Normal\" style=\"text-align: justify\">Step 2: Add <strong>Sales<\/strong> to the <strong>L<\/strong><strong>abel<\/strong> <strong>C<\/strong><strong>ard<\/strong>. Click the down arrow next to the added <strong>Sales <\/strong>field, choose <strong>Quick Table Calculation<\/strong>, and then select <strong>Percent Difference<\/strong>.<\/p>\n<p class=\"import-Normal\" style=\"text-align: center\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter\" src=\"https:\/\/openbook.ums.edu.my\/essentialsofdatavisualizationwithtableau\/wp-content\/uploads\/sites\/190\/2024\/10\/image131.png\" alt=\"image\" width=\"405\" height=\"370\" \/><\/p>\n<p class=\"import-Normal\" style=\"text-align: justify\">Step 3: The line chart now displays the percentage change in sales for each quarter of the year compared to the previous time point. It indicates a significant decline in sales during Q1 2019, with a decrease of -61.7% from the prior quarter.<\/p>\n<p class=\"import-Normal\" style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter\" src=\"https:\/\/openbook.ums.edu.my\/essentialsofdatavisualizationwithtableau\/wp-content\/uploads\/sites\/190\/2024\/10\/image132.png\" alt=\"image\" width=\"699\" height=\"354\" \/><\/p>\n<h3><a id=\"_Toc170398207\"><\/a><a id=\"_Toc178253031\"><\/a><strong>Exercise<\/strong><strong> 20<\/strong><\/h3>\n<p class=\"import-Normal\" style=\"text-align: justify\">Using the <strong>Quick Calculation Table<\/strong>, find the rank of bookcases among the other sub-categories in terms of total profit earned.<\/p>\n<p class=\"import-Normal\" style=\"text-align: justify\"><strong>Solution &#8211; Exercise 20<\/strong><\/p>\n<p class=\"import-Normal\" style=\"text-align: justify\">Step 1: Create a bar graph showing the total profit vs. sub-categories. Name it <strong>VIZ 15<\/strong>. Drop the <strong>P<\/strong><strong>rofit<\/strong> field to the <strong>L<\/strong><strong>abel <\/strong><strong>C<\/strong><strong>ard<\/strong>.<\/p>\n<p class=\"import-Normal\" style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter\" src=\"https:\/\/openbook.ums.edu.my\/essentialsofdatavisualizationwithtableau\/wp-content\/uploads\/sites\/190\/2024\/10\/image133.png\" alt=\"image\" width=\"708\" height=\"357\" \/><\/p>\n<p class=\"import-Normal\" style=\"text-align: justify\">Step 2: Click the down arrow next to the <strong>Sales<\/strong> field on <strong>Label<\/strong> <strong>C<\/strong><strong>ard<\/strong>, choose the <strong>Quick Table Calculation<\/strong>, and then select <strong>Rank<\/strong>.<\/p>\n<p class=\"import-Normal\" style=\"text-align: center\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter\" src=\"https:\/\/openbook.ums.edu.my\/essentialsofdatavisualizationwithtableau\/wp-content\/uploads\/sites\/190\/2024\/10\/image134.png\" alt=\"image\" width=\"397\" height=\"372\" \/><\/p>\n<p class=\"import-Normal\" style=\"text-align: justify\">Step 3: The bar graph displays the rank of each sub-category item. Based on the bar graph, bookcases ranked at the 16<sup>th<\/sup> position in terms of profitability.<\/p>\n<p class=\"import-Normal\" style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter\" src=\"https:\/\/openbook.ums.edu.my\/essentialsofdatavisualizationwithtableau\/wp-content\/uploads\/sites\/190\/2024\/10\/image135.png\" alt=\"image\" width=\"717\" height=\"367\" \/><\/p>\n<div id=\"h5p-17\">\n<div class=\"h5p-iframe-wrapper\"><iframe id=\"h5p-iframe-17\" class=\"h5p-iframe\" data-content-id=\"17\" style=\"height:1px\" src=\"about:blank\" frameBorder=\"0\" scrolling=\"no\" title=\"Quick table calculation\"><\/iframe><\/div>\n<\/div>\n<h2><a id=\"_Toc178253032\"><\/a><strong>Calculated <\/strong><strong>F<\/strong><strong>ield<\/strong><strong>s<\/strong><\/h2>\n<p class=\"import-Normal\" style=\"text-align: justify\">Tableau users have the option to process the current data within a data source to generate a new field, which may be necessary for further analysis. This new field, known as a calculated field, can be created using various mathematical functions available in Tableau. These functions fall into several categories, including basic arithmetic, statistical, logical, date, and string functions.<\/p>\n<h3><a id=\"_Toc178253033\"><\/a><strong>Exercise 21<\/strong><\/h3>\n<p class=\"import-Normal\" style=\"text-align: justify\">Create a calculated field using the existing data to represent the cost for each order. Note that, cost = sales \u2013 profit. Construct a bar chart to display the average cost per sub-category. Which sub-category item has the largest average cost?<\/p>\n<p class=\"import-Normal\" style=\"text-align: justify\"><strong>Solution \u2013 Exercise 21<\/strong><\/p>\n<p class=\"import-Normal\" style=\"text-align: justify\">Step 1: Click the down arrow at the top right corner of the <strong>D<\/strong><strong>ata <\/strong><strong>P<\/strong><strong>ane<\/strong> and choose <strong>Create Calculated Field<\/strong>.<\/p>\n<p class=\"import-Normal\" style=\"text-align: center\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter\" src=\"https:\/\/openbook.ums.edu.my\/essentialsofdatavisualizationwithtableau\/wp-content\/uploads\/sites\/190\/2024\/10\/image136.png\" alt=\"image\" width=\"201\" height=\"285\" \/><\/p>\n<p class=\"import-Normal\" style=\"text-align: justify\">Step 2: Name the new field <strong>C<\/strong><strong>ost<\/strong>, and enter the needed formula in the available calculation space. Note that the fields required in the formula appear as we type them. Tableau alerts us if the entered formula is invalid either because of illogical calculations or if its expression does not meet Tableau&#8217;s calculation language.<\/p>\n<p class=\"import-Normal\" style=\"text-align: center\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter\" src=\"https:\/\/openbook.ums.edu.my\/essentialsofdatavisualizationwithtableau\/wp-content\/uploads\/sites\/190\/2024\/10\/image137.png\" alt=\"image\" width=\"543\" height=\"257\" \/><\/p>\n<p class=\"import-Normal\" style=\"text-align: justify\">Step 3: Once clicking <strong>OK<\/strong>, the newly created calculated will appear in the <strong>D<\/strong><strong>ata <\/strong><strong>P<\/strong><strong>ane<\/strong>.<\/p>\n<p class=\"import-Normal\" style=\"text-align: center\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter\" src=\"https:\/\/openbook.ums.edu.my\/essentialsofdatavisualizationwithtableau\/wp-content\/uploads\/sites\/190\/2024\/10\/image138.png\" alt=\"image\" width=\"212\" height=\"148\" \/><\/p>\n<p class=\"import-Normal\" style=\"text-align: justify\">Step 4: To create the cost vs. sub-category graph, drag and drop the <strong>C<\/strong><strong>ost<\/strong> and <strong>S<\/strong><strong>ub-<\/strong><strong>C<\/strong><strong>ategory<\/strong> fields onto the <strong>C<\/strong><strong>olumn<\/strong><strong>s<\/strong> and <strong>Rows<\/strong> shelf, respectively. Name it <strong>VIZ<\/strong> <strong>16<\/strong>. Change the aggregation type of cost from sum to average. Also, drop the <strong>C<\/strong><strong>ost<\/strong> field to the <strong>L<\/strong><strong>abel <\/strong><strong>C<\/strong><strong>ard<\/strong> and ensure the aggregation is set to average. The graph points out machine has the highest average cost with $1616, followed by copiers, and Tables.<\/p>\n<p class=\"import-Normal\" style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter\" src=\"https:\/\/openbook.ums.edu.my\/essentialsofdatavisualizationwithtableau\/wp-content\/uploads\/sites\/190\/2024\/10\/image139.png\" alt=\"image\" width=\"700\" height=\"351\" \/><\/p>\n<h3><a id=\"_Toc178253034\"><\/a><strong>Exercise 22<\/strong><\/h3>\n<p class=\"import-Normal\" style=\"text-align: justify\">Create a calculated field to classify the sub-category items as &#8220;High profit&#8221;, &#8220;Moderate profit&#8221;, &#8220;Low profit&#8221;, and &#8220;Loss&#8221;. Apply the conditions listed in the following table for the classification. Also, generate a chart depicting the total profit versus sub-category, and integrate the classification information into the chart. What are the sub-category items that are classified as &#8220;Loss&#8221; items?<\/p>\n<table style=\"width: 685px\">\n<tbody>\n<tr class=\"ListTable2-Accent1-R\" style=\"height: 0\">\n<td class=\"ListTable2-Accent1-C\" style=\"border-top: 0.5pt solid #8eaadb;border-bottom: 0.5pt solid #8eaadb;width: 187.656px\">\n<div class=\"ListTable2-Accent1-firstCol\">\n<div class=\"ListTable2-Accent1-firstRow\">\n<p class=\"import-Normal\" style=\"text-align: justify\">Classification<\/p>\n<\/div>\n<\/div>\n<\/td>\n<td class=\"ListTable2-Accent1-C\" style=\"border-top: 0.5pt solid #8eaadb;border-bottom: 0.5pt solid #8eaadb;width: 470.094px\">\n<div class=\"ListTable2-Accent1-firstRow\">\n<p class=\"import-Normal\" style=\"text-align: justify\">Condition<\/p>\n<\/div>\n<\/td>\n<\/tr>\n<tr class=\"ListTable2-Accent1-R\" style=\"height: 0\">\n<td class=\"ListTable2-Accent1-C\" style=\"background-color: #d9e2f3;border-top: 0.5pt solid #8eaadb;border-bottom: 0.5pt solid #8eaadb;width: 187.656px\">\n<div class=\"ListTable2-Accent1-band1Horz\">\n<div class=\"ListTable2-Accent1-firstCol\">\n<p class=\"import-Normal\" style=\"text-align: justify\">High profit<\/p>\n<\/div>\n<\/div>\n<\/td>\n<td class=\"ListTable2-Accent1-C\" style=\"background-color: #d9e2f3;border-top: 0.5pt solid #8eaadb;border-bottom: 0.5pt solid #8eaadb;width: 470.094px\">\n<div class=\"ListTable2-Accent1-band1Horz\">\n<p class=\"import-Normal\" style=\"text-align: justify\">Total profit is $30,000 and above.<\/p>\n<\/div>\n<\/td>\n<\/tr>\n<tr class=\"ListTable2-Accent1-R\">\n<td class=\"ListTable2-Accent1-C\" style=\"border-top: 0.5pt solid #8eaadb;border-bottom: 0.5pt solid #8eaadb;width: 187.656px\">\n<div class=\"ListTable2-Accent1-firstCol\">\n<p class=\"import-Normal\" style=\"text-align: justify\">Moderate profit<\/p>\n<\/div>\n<\/td>\n<td class=\"ListTable2-Accent1-C\" style=\"border-top: 0.5pt solid #8eaadb;border-bottom: 0.5pt solid #8eaadb;width: 470.094px\">\n<p class=\"import-Normal\" style=\"text-align: left\">Total profit is $10,000 and above.<\/p>\n<\/td>\n<\/tr>\n<tr class=\"ListTable2-Accent1-R\" style=\"height: 0\">\n<td class=\"ListTable2-Accent1-C\" style=\"background-color: #d9e2f3;border-top: 0.5pt solid #8eaadb;border-bottom: 0.5pt solid #8eaadb;width: 187.656px\">\n<div class=\"ListTable2-Accent1-band1Horz\">\n<div class=\"ListTable2-Accent1-firstCol\">\n<p class=\"import-Normal\" style=\"text-align: justify\">Low profit<\/p>\n<\/div>\n<\/div>\n<\/td>\n<td class=\"ListTable2-Accent1-C\" style=\"background-color: #d9e2f3;border-top: 0.5pt solid #8eaadb;border-bottom: 0.5pt solid #8eaadb;width: 470.094px\">\n<div class=\"ListTable2-Accent1-band1Horz\">\n<p class=\"import-Normal\" style=\"text-align: justify\">Total profit is $0 and above.<\/p>\n<\/div>\n<\/td>\n<\/tr>\n<tr class=\"ListTable2-Accent1-R\">\n<td class=\"ListTable2-Accent1-C\" style=\"border-top: 0.5pt solid #8eaadb;border-bottom: 0.5pt solid #8eaadb;width: 187.656px\">\n<div class=\"ListTable2-Accent1-firstCol\">\n<p class=\"import-Normal\" style=\"text-align: justify\">Loss<\/p>\n<\/div>\n<\/td>\n<td class=\"ListTable2-Accent1-C\" style=\"border-top: 0.5pt solid #8eaadb;border-bottom: 0.5pt solid #8eaadb;width: 470.094px\">\n<p class=\"import-Normal\" style=\"text-align: justify\">Total profit is below $0.<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 187.656px\"><\/td>\n<td style=\"width: 470.094px\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p class=\"import-Normal\"><strong>Solution \u2013 Exercise 22<\/strong><\/p>\n<p class=\"import-Normal\" style=\"text-align: justify\">Step 1: Create a calculated field using the logical functions, e.g., IF, THEN, and ELSE, to classify the sub-category items based on the conditions given. Name the field <strong>Profit <\/strong><strong>C<\/strong><strong>lassification<\/strong>.<\/p>\n<p class=\"import-Normal\" style=\"text-align: center\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter\" src=\"https:\/\/openbook.ums.edu.my\/essentialsofdatavisualizationwithtableau\/wp-content\/uploads\/sites\/190\/2024\/10\/image140.png\" alt=\"image\" width=\"605\" height=\"301\" \/><\/p>\n<p class=\"import-Normal\" style=\"text-align: justify\">Step 2: Open a new worksheet and rename it to <strong>VIZ 17<\/strong>. Construct a bar graph depicting the total profit versus sub-category.<\/p>\n<p class=\"import-Normal\" style=\"text-align: justify\">Step 3: Drag and drop the <strong>Profit <\/strong><strong>Classification<\/strong> field to the <strong>C<\/strong><strong>olour<\/strong> and <strong>L<\/strong><strong>abel <\/strong><strong>C<\/strong><strong>ards<\/strong> to distinguish each sub-category according to its classification. The chart tells that bookcases, supplies, and tables are three sub-category items classified as &#8220;Loss&#8221;.<\/p>\n<p class=\"import-Normal\" style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter\" src=\"https:\/\/openbook.ums.edu.my\/essentialsofdatavisualizationwithtableau\/wp-content\/uploads\/sites\/190\/2024\/10\/image141.png\" alt=\"image\" width=\"726\" height=\"315\" \/><\/p>\n<div id=\"h5p-16\">\n<div class=\"h5p-iframe-wrapper\"><iframe id=\"h5p-iframe-16\" class=\"h5p-iframe\" data-content-id=\"16\" style=\"height:1px\" src=\"about:blank\" frameBorder=\"0\" scrolling=\"no\" title=\"Calculated fields\"><\/iframe><\/div>\n<\/div>\n<p class=\"import-Normal\" style=\"text-align: justify\">\n<\/div>\n","protected":false},"author":131,"menu_order":5,"template":"","meta":{"pb_show_title":"on","pb_short_title":"","pb_subtitle":"","pb_authors":[],"pb_section_license":""},"chapter-type":[],"contributor":[],"license":[],"class_list":["post-172","chapter","type-chapter","status-publish","hentry"],"part":3,"_links":{"self":[{"href":"https:\/\/openbook.ums.edu.my\/essentialsofdatavisualizationwithtableau\/wp-json\/pressbooks\/v2\/chapters\/172","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/openbook.ums.edu.my\/essentialsofdatavisualizationwithtableau\/wp-json\/pressbooks\/v2\/chapters"}],"about":[{"href":"https:\/\/openbook.ums.edu.my\/essentialsofdatavisualizationwithtableau\/wp-json\/wp\/v2\/types\/chapter"}],"author":[{"embeddable":true,"href":"https:\/\/openbook.ums.edu.my\/essentialsofdatavisualizationwithtableau\/wp-json\/wp\/v2\/users\/131"}],"version-history":[{"count":3,"href":"https:\/\/openbook.ums.edu.my\/essentialsofdatavisualizationwithtableau\/wp-json\/pressbooks\/v2\/chapters\/172\/revisions"}],"predecessor-version":[{"id":370,"href":"https:\/\/openbook.ums.edu.my\/essentialsofdatavisualizationwithtableau\/wp-json\/pressbooks\/v2\/chapters\/172\/revisions\/370"}],"part":[{"href":"https:\/\/openbook.ums.edu.my\/essentialsofdatavisualizationwithtableau\/wp-json\/pressbooks\/v2\/parts\/3"}],"metadata":[{"href":"https:\/\/openbook.ums.edu.my\/essentialsofdatavisualizationwithtableau\/wp-json\/pressbooks\/v2\/chapters\/172\/metadata\/"}],"wp:attachment":[{"href":"https:\/\/openbook.ums.edu.my\/essentialsofdatavisualizationwithtableau\/wp-json\/wp\/v2\/media?parent=172"}],"wp:term":[{"taxonomy":"chapter-type","embeddable":true,"href":"https:\/\/openbook.ums.edu.my\/essentialsofdatavisualizationwithtableau\/wp-json\/pressbooks\/v2\/chapter-type?post=172"},{"taxonomy":"contributor","embeddable":true,"href":"https:\/\/openbook.ums.edu.my\/essentialsofdatavisualizationwithtableau\/wp-json\/wp\/v2\/contributor?post=172"},{"taxonomy":"license","embeddable":true,"href":"https:\/\/openbook.ums.edu.my\/essentialsofdatavisualizationwithtableau\/wp-json\/wp\/v2\/license?post=172"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}