{"id":382,"date":"2025-04-30T11:54:33","date_gmt":"2025-04-30T18:54:33","guid":{"rendered":"https:\/\/sarahpallett.com\/?p=382"},"modified":"2025-04-30T11:54:35","modified_gmt":"2025-04-30T18:54:35","slug":"two-for-one-one-bar-chart-with-two-types-of-numerical-data","status":"publish","type":"post","link":"https:\/\/sarahpallett.com\/index.php\/2025\/04\/30\/two-for-one-one-bar-chart-with-two-types-of-numerical-data\/","title":{"rendered":"Two for One: One bar chart with two types of numerical data"},"content":{"rendered":"\n<p>Looking for a simple way to boost interactivity and pack more analytic value into a single bar chart? <\/p>\n\n\n\n<p>In this Help Desk Dashboard, we wanted to track the weekly number of tickets <em>and<\/em> the percentage each week contributed to the total. At first, we used two separate bar charts, one for the raw counts and one for the percentages, but this felt redundant and took up too much space, especially since the bar sizes were nearly identical. That challenge sparked a creative solution: a single bar chart powered by a parameter action that toggles between ticket count and percent of total.<\/p>\n\n\n\n<p><\/p>\n\n\n\n<figure class=\"wp-block-video\"><video controls src=\"https:\/\/sarahpallett.com\/wp-content\/uploads\/2025\/04\/ezgif.com-gif-to-mp4-converter.mp4\"><\/video><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p>Adding toggle buttons enhanced the end-user experience \u2013 we all love having buttons to press! Read on to learn how to deploy this technique on your dashboards.&nbsp;<\/p>\n\n\n\n<p><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"233\" height=\"304\" src=\"https:\/\/sarahpallett.com\/wp-content\/uploads\/2025\/04\/Screenshot-2025-04-29-204219.png\" alt=\"\" class=\"wp-image-409\" srcset=\"https:\/\/sarahpallett.com\/wp-content\/uploads\/2025\/04\/Screenshot-2025-04-29-204219.png 233w, https:\/\/sarahpallett.com\/wp-content\/uploads\/2025\/04\/Screenshot-2025-04-29-204219-230x300.png 230w\" sizes=\"auto, (max-width: 233px) 100vw, 233px\" \/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p>The first step is to identify the two measures. In this example, we needed [ # of Tickets] and [% of Tickets], both of which I chose to set up as calculated fields.<\/p>\n\n\n\n<p><\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"493\" height=\"301\" src=\"https:\/\/sarahpallett.com\/wp-content\/uploads\/2025\/04\/Screenshot-2025-04-29-205801.png\" alt=\"\" class=\"wp-image-383\" style=\"width:472px;height:auto\" srcset=\"https:\/\/sarahpallett.com\/wp-content\/uploads\/2025\/04\/Screenshot-2025-04-29-205801.png 493w, https:\/\/sarahpallett.com\/wp-content\/uploads\/2025\/04\/Screenshot-2025-04-29-205801-300x183.png 300w\" sizes=\"auto, (max-width: 493px) 100vw, 493px\" \/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"489\" height=\"332\" src=\"https:\/\/sarahpallett.com\/wp-content\/uploads\/2025\/04\/Screenshot-2025-04-29-205815.png\" alt=\"\" class=\"wp-image-384\" style=\"width:473px;height:auto\" srcset=\"https:\/\/sarahpallett.com\/wp-content\/uploads\/2025\/04\/Screenshot-2025-04-29-205815.png 489w, https:\/\/sarahpallett.com\/wp-content\/uploads\/2025\/04\/Screenshot-2025-04-29-205815-300x204.png 300w\" sizes=\"auto, (max-width: 489px) 100vw, 489px\" \/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p>Next, create the\u00a0[Show # or % of Tickets] parameter that will act as the framework for your toggle. Set it up as an empty string parameter.\u00a0\u00a0<br><\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"559\" height=\"523\" src=\"https:\/\/sarahpallett.com\/wp-content\/uploads\/2025\/04\/Screenshot-2025-04-29-214247.png\" alt=\"\" class=\"wp-image-385\" style=\"width:441px;height:auto\" srcset=\"https:\/\/sarahpallett.com\/wp-content\/uploads\/2025\/04\/Screenshot-2025-04-29-214247.png 559w, https:\/\/sarahpallett.com\/wp-content\/uploads\/2025\/04\/Screenshot-2025-04-29-214247-300x281.png 300w\" sizes=\"auto, (max-width: 559px) 100vw, 559px\" \/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p>Now we are ready to use this parameter in new calculated field. I named it [Display # or % of Tickets]<br><\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"484\" height=\"321\" src=\"https:\/\/sarahpallett.com\/wp-content\/uploads\/2025\/04\/Screenshot-2025-04-29-210009.png\" alt=\"\" class=\"wp-image-386\" style=\"width:413px;height:auto\" srcset=\"https:\/\/sarahpallett.com\/wp-content\/uploads\/2025\/04\/Screenshot-2025-04-29-210009.png 484w, https:\/\/sarahpallett.com\/wp-content\/uploads\/2025\/04\/Screenshot-2025-04-29-210009-300x199.png 300w\" sizes=\"auto, (max-width: 484px) 100vw, 484px\" \/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p>Our next step?&nbsp; Build the bar chart. One a new sheet, bring your date field to columns and the [Display # or % of Tickets] calculation to rows. <\/p>\n\n\n\n<p><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"697\" height=\"656\" src=\"https:\/\/sarahpallett.com\/wp-content\/uploads\/2025\/04\/Screenshot-2025-04-29-221406.png\" alt=\"\" class=\"wp-image-406\" srcset=\"https:\/\/sarahpallett.com\/wp-content\/uploads\/2025\/04\/Screenshot-2025-04-29-221406.png 697w, https:\/\/sarahpallett.com\/wp-content\/uploads\/2025\/04\/Screenshot-2025-04-29-221406-300x282.png 300w, https:\/\/sarahpallett.com\/wp-content\/uploads\/2025\/04\/Screenshot-2025-04-29-221406-600x565.png 600w\" sizes=\"auto, (max-width: 697px) 100vw, 697px\" \/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p>You will notice we used two different calculations on the Text marks card. Unfortunately we cannot use the [Display # or % of Tickets] calculation to display the labels because want to show the # of Tickets as a whole number, and the Percent of Total as a percentage. This means we will need calculations for the labels to allow for custom formatting. Create two new calculations and adjust the Default Properties for each calculation to have the corresponding number formats. These calculations tell Tableau which value to display and the number format to display the value. Place both calculations on the Text Marks Card.&nbsp; I named these calculations [Label # of Tickets] and [Label % of Tickets]<\/p>\n\n\n\n<p><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1003\" height=\"364\" src=\"https:\/\/sarahpallett.com\/wp-content\/uploads\/2025\/04\/Screenshot-2025-04-29-210644.png\" alt=\"\" class=\"wp-image-387\" srcset=\"https:\/\/sarahpallett.com\/wp-content\/uploads\/2025\/04\/Screenshot-2025-04-29-210644.png 1003w, https:\/\/sarahpallett.com\/wp-content\/uploads\/2025\/04\/Screenshot-2025-04-29-210644-300x109.png 300w, https:\/\/sarahpallett.com\/wp-content\/uploads\/2025\/04\/Screenshot-2025-04-29-210644-768x279.png 768w, https:\/\/sarahpallett.com\/wp-content\/uploads\/2025\/04\/Screenshot-2025-04-29-210644-600x218.png 600w\" sizes=\"auto, (max-width: 1003px) 100vw, 1003px\" \/><\/figure>\n\n\n\n<p><br><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1011\" height=\"364\" src=\"https:\/\/sarahpallett.com\/wp-content\/uploads\/2025\/04\/Screenshot-2025-04-29-210716.png\" alt=\"\" class=\"wp-image-388\" srcset=\"https:\/\/sarahpallett.com\/wp-content\/uploads\/2025\/04\/Screenshot-2025-04-29-210716.png 1011w, https:\/\/sarahpallett.com\/wp-content\/uploads\/2025\/04\/Screenshot-2025-04-29-210716-300x108.png 300w, https:\/\/sarahpallett.com\/wp-content\/uploads\/2025\/04\/Screenshot-2025-04-29-210716-768x277.png 768w, https:\/\/sarahpallett.com\/wp-content\/uploads\/2025\/04\/Screenshot-2025-04-29-210716-600x216.png 600w\" sizes=\"auto, (max-width: 1011px) 100vw, 1011px\" \/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"569\" height=\"533\" src=\"https:\/\/sarahpallett.com\/wp-content\/uploads\/2025\/04\/Screenshot-2025-04-29-210830.png\" alt=\"\" class=\"wp-image-390\" srcset=\"https:\/\/sarahpallett.com\/wp-content\/uploads\/2025\/04\/Screenshot-2025-04-29-210830.png 569w, https:\/\/sarahpallett.com\/wp-content\/uploads\/2025\/04\/Screenshot-2025-04-29-210830-300x281.png 300w\" sizes=\"auto, (max-width: 569px) 100vw, 569px\" \/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"458\" height=\"340\" src=\"https:\/\/sarahpallett.com\/wp-content\/uploads\/2025\/04\/Screenshot-2025-04-29-210736-1.png\" alt=\"\" class=\"wp-image-391\" srcset=\"https:\/\/sarahpallett.com\/wp-content\/uploads\/2025\/04\/Screenshot-2025-04-29-210736-1.png 458w, https:\/\/sarahpallett.com\/wp-content\/uploads\/2025\/04\/Screenshot-2025-04-29-210736-1-300x223.png 300w\" sizes=\"auto, (max-width: 458px) 100vw, 458px\" \/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"458\" height=\"340\" src=\"https:\/\/sarahpallett.com\/wp-content\/uploads\/2025\/04\/Screenshot-2025-04-29-210754.png\" alt=\"\" class=\"wp-image-392\" srcset=\"https:\/\/sarahpallett.com\/wp-content\/uploads\/2025\/04\/Screenshot-2025-04-29-210754.png 458w, https:\/\/sarahpallett.com\/wp-content\/uploads\/2025\/04\/Screenshot-2025-04-29-210754-300x223.png 300w\" sizes=\"auto, (max-width: 458px) 100vw, 458px\" \/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p>Now we have our parameter, calculations, and bar chart\u2026.next up is building the toggle sheet. This may seem tricky, but it\u2019s actually quite straight forward with the use of Measure Names and Measure Values.&nbsp; Follow these steps:<\/p>\n\n\n\n<p>On a new sheet, change the Mark Type of this sheet to Shape.&nbsp;<\/p>\n\n\n\n<p>Next, bring Measure Names on to the Filter shelf, and select the two measures used in the toggle\u00a0[# of Tickets] and [% of Tickets]\u00a0<\/p>\n\n\n\n<p>Place a second copy of Measure Names on the Shape marks card and a third copy to the Columns Shelf. We won\u2019t need the header, so we can access the drop-down menu and uncheck \u201cShow header\u201d now.<\/p>\n\n\n\n<p><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"528\" height=\"386\" src=\"https:\/\/sarahpallett.com\/wp-content\/uploads\/2025\/04\/Screenshot-2025-04-29-212212.png\" alt=\"\" class=\"wp-image-393\" srcset=\"https:\/\/sarahpallett.com\/wp-content\/uploads\/2025\/04\/Screenshot-2025-04-29-212212.png 528w, https:\/\/sarahpallett.com\/wp-content\/uploads\/2025\/04\/Screenshot-2025-04-29-212212-300x219.png 300w\" sizes=\"auto, (max-width: 528px) 100vw, 528px\" \/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p>Click on the Shape marks card to select the shapes you wish to use. For the Help Desk Dashboard, I imported custom shapes (Andy Kriebel has a great video on how-to add custom shapes <a href=\"https:\/\/www.youtube.com\/watch?v=xcTtU2if7bs\">here<\/a>)<\/p>\n\n\n\n<p>Next, add Measure Values to the Details Shelf. This should only bring two measures into the view because we filtered Measure Names in an earlier step.<\/p>\n\n\n\n<p>Remove the row dividers by accessing Format &gt; Borders, and setting Row Dividers to None.&nbsp;<\/p>\n\n\n\n<p><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"604\" height=\"710\" src=\"https:\/\/sarahpallett.com\/wp-content\/uploads\/2025\/04\/Screenshot-2025-04-29-212431.png\" alt=\"\" class=\"wp-image-394\" srcset=\"https:\/\/sarahpallett.com\/wp-content\/uploads\/2025\/04\/Screenshot-2025-04-29-212431.png 604w, https:\/\/sarahpallett.com\/wp-content\/uploads\/2025\/04\/Screenshot-2025-04-29-212431-255x300.png 255w, https:\/\/sarahpallett.com\/wp-content\/uploads\/2025\/04\/Screenshot-2025-04-29-212431-600x705.png 600w\" sizes=\"auto, (max-width: 604px) 100vw, 604px\" \/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p>Lastly, set the layout to be Entire View and name the sheet \u201c# or %\u201d<\/p>\n\n\n\n<p><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"292\" height=\"129\" src=\"https:\/\/sarahpallett.com\/wp-content\/uploads\/2025\/04\/Screenshot-2025-04-29-212457.png\" alt=\"\" class=\"wp-image-395\"\/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"718\" height=\"659\" src=\"https:\/\/sarahpallett.com\/wp-content\/uploads\/2025\/04\/Screenshot-2025-04-29-211333.png\" alt=\"\" class=\"wp-image-396\" srcset=\"https:\/\/sarahpallett.com\/wp-content\/uploads\/2025\/04\/Screenshot-2025-04-29-211333.png 718w, https:\/\/sarahpallett.com\/wp-content\/uploads\/2025\/04\/Screenshot-2025-04-29-211333-300x275.png 300w, https:\/\/sarahpallett.com\/wp-content\/uploads\/2025\/04\/Screenshot-2025-04-29-211333-600x551.png 600w\" sizes=\"auto, (max-width: 718px) 100vw, 718px\" \/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p>With our bar chart and our # or % toggle sheet ready to go, we can build our dashboard. Go to a new dashboard and drag both sheets on to the dashboard.\u00a0 To enable the interactivity, we need a Dashboard Parameter Action. From the Menu bar, select Dashboard > Actions to open the Actions dialog box.\u00a0\u00a0<\/p>\n\n\n\n<p><br><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"368\" height=\"324\" src=\"https:\/\/sarahpallett.com\/wp-content\/uploads\/2025\/04\/Screenshot-2025-04-29-213740.png\" alt=\"\" class=\"wp-image-397\" srcset=\"https:\/\/sarahpallett.com\/wp-content\/uploads\/2025\/04\/Screenshot-2025-04-29-213740.png 368w, https:\/\/sarahpallett.com\/wp-content\/uploads\/2025\/04\/Screenshot-2025-04-29-213740-300x264.png 300w\" sizes=\"auto, (max-width: 368px) 100vw, 368px\" \/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p>From the Action drop down menu, select Change Parameter.<\/p>\n\n\n\n<p><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"602\" height=\"442\" src=\"https:\/\/sarahpallett.com\/wp-content\/uploads\/2025\/04\/Screenshot-2025-04-29-213716.png\" alt=\"\" class=\"wp-image-398\" srcset=\"https:\/\/sarahpallett.com\/wp-content\/uploads\/2025\/04\/Screenshot-2025-04-29-213716.png 602w, https:\/\/sarahpallett.com\/wp-content\/uploads\/2025\/04\/Screenshot-2025-04-29-213716-300x220.png 300w, https:\/\/sarahpallett.com\/wp-content\/uploads\/2025\/04\/Screenshot-2025-04-29-213716-600x441.png 600w\" sizes=\"auto, (max-width: 602px) 100vw, 602px\" \/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p>A new dialog box appears to set the configurations for this dashboard action.&nbsp; Give the parameter a meaningful name \u2013 I called mine [Parameter # of %].&nbsp; The source sheet is our Toggle Sheet. We want the action to run on Select. The Target Parameter is our&nbsp; [Show # or % of Tickets] parameter. The source field is Measure Names.&nbsp; We want to Keep the Current Values when Clearing the Selection. Click OK.&nbsp;<\/p>\n\n\n\n<p><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"496\" height=\"484\" src=\"https:\/\/sarahpallett.com\/wp-content\/uploads\/2025\/04\/Screenshot-2025-04-29-213648.png\" alt=\"\" class=\"wp-image-399\" srcset=\"https:\/\/sarahpallett.com\/wp-content\/uploads\/2025\/04\/Screenshot-2025-04-29-213648.png 496w, https:\/\/sarahpallett.com\/wp-content\/uploads\/2025\/04\/Screenshot-2025-04-29-213648-300x293.png 300w\" sizes=\"auto, (max-width: 496px) 100vw, 496px\" \/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p>Test the parameter action by clicking on one of the custom shapes, and notice if the bar chart labels update. Volia! One bar chart with a toggle for two numerical values. Space-saver and fun interactivity all rolled up into one creative solution!&nbsp; Feel free to take my dashboard for a test drive on <a href=\"https:\/\/public.tableau.com\/views\/HelpDeskDashboard_17208227327660\/Dashboard?:language=en-US&amp;:sid=&amp;:redirect=auth&amp;:display_count=n&amp;:origin=viz_share_link\">Tableau Public<\/a>, and download it to take a look under the hood if you wish!&nbsp;<\/p>\n\n\n\n<p>Happy Vizzing!&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Looking for a simple way to boost interactivity and pack more analytic value into a single bar chart? In this Help Desk Dashboard, we wanted to track the weekly number of tickets and the percentage each week contributed to the total. At first, we used two separate bar charts, one for the raw counts and&#8230; <a class=\"more-link\" href=\"https:\/\/sarahpallett.com\/index.php\/2025\/04\/30\/two-for-one-one-bar-chart-with-two-types-of-numerical-data\/#more-382\">Continue Reading &rarr;<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[8],"tags":[4,3,21,16],"class_list":["post-382","post","type-post","status-publish","format-standard","hentry","category-the-inside-scoop","tag-dataviz","tag-tableau","tag-tableaupublic","tag-tableautip","clear"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.8 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Two for One: One bar chart with two types of numerical data - Sarah Pallett<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/sarahpallett.com\/index.php\/2025\/04\/30\/two-for-one-one-bar-chart-with-two-types-of-numerical-data\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Two for One: One bar chart with two types of numerical data - Sarah Pallett\" \/>\n<meta property=\"og:description\" content=\"Looking for a simple way to boost interactivity and pack more analytic value into a single bar chart? In this Help Desk Dashboard, we wanted to track the weekly number of tickets and the percentage each week contributed to the total. At first, we used two separate bar charts, one for the raw counts and... Continue Reading &rarr;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/sarahpallett.com\/index.php\/2025\/04\/30\/two-for-one-one-bar-chart-with-two-types-of-numerical-data\/\" \/>\n<meta property=\"og:site_name\" content=\"Sarah Pallett\" \/>\n<meta property=\"article:published_time\" content=\"2025-04-30T18:54:33+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-04-30T18:54:35+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/sarahpallett.com\/wp-content\/uploads\/2025\/04\/Screenshot-2025-04-29-204219.png\" \/>\n\t<meta property=\"og:image:width\" content=\"233\" \/>\n\t<meta property=\"og:image:height\" content=\"304\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Sarah\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Sarah\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/sarahpallett.com\/index.php\/2025\/04\/30\/two-for-one-one-bar-chart-with-two-types-of-numerical-data\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/sarahpallett.com\/index.php\/2025\/04\/30\/two-for-one-one-bar-chart-with-two-types-of-numerical-data\/\"},\"author\":{\"name\":\"Sarah\",\"@id\":\"https:\/\/sarahpallett.com\/#\/schema\/person\/dce769f945c604f38bb244e91205abe8\"},\"headline\":\"Two for One: One bar chart with two types of numerical data\",\"datePublished\":\"2025-04-30T18:54:33+00:00\",\"dateModified\":\"2025-04-30T18:54:35+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/sarahpallett.com\/index.php\/2025\/04\/30\/two-for-one-one-bar-chart-with-two-types-of-numerical-data\/\"},\"wordCount\":768,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/sarahpallett.com\/index.php\/2025\/04\/30\/two-for-one-one-bar-chart-with-two-types-of-numerical-data\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/sarahpallett.com\/wp-content\/uploads\/2025\/04\/Screenshot-2025-04-29-204219.png\",\"keywords\":[\"DataViz\",\"Tableau\",\"TableauPublic\",\"TableauTip\"],\"articleSection\":[\"The Inside Scoop\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/sarahpallett.com\/index.php\/2025\/04\/30\/two-for-one-one-bar-chart-with-two-types-of-numerical-data\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/sarahpallett.com\/index.php\/2025\/04\/30\/two-for-one-one-bar-chart-with-two-types-of-numerical-data\/\",\"url\":\"https:\/\/sarahpallett.com\/index.php\/2025\/04\/30\/two-for-one-one-bar-chart-with-two-types-of-numerical-data\/\",\"name\":\"Two for One: One bar chart with two types of numerical data - Sarah Pallett\",\"isPartOf\":{\"@id\":\"https:\/\/sarahpallett.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/sarahpallett.com\/index.php\/2025\/04\/30\/two-for-one-one-bar-chart-with-two-types-of-numerical-data\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/sarahpallett.com\/index.php\/2025\/04\/30\/two-for-one-one-bar-chart-with-two-types-of-numerical-data\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/sarahpallett.com\/wp-content\/uploads\/2025\/04\/Screenshot-2025-04-29-204219.png\",\"datePublished\":\"2025-04-30T18:54:33+00:00\",\"dateModified\":\"2025-04-30T18:54:35+00:00\",\"author\":{\"@id\":\"https:\/\/sarahpallett.com\/#\/schema\/person\/dce769f945c604f38bb244e91205abe8\"},\"breadcrumb\":{\"@id\":\"https:\/\/sarahpallett.com\/index.php\/2025\/04\/30\/two-for-one-one-bar-chart-with-two-types-of-numerical-data\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/sarahpallett.com\/index.php\/2025\/04\/30\/two-for-one-one-bar-chart-with-two-types-of-numerical-data\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/sarahpallett.com\/index.php\/2025\/04\/30\/two-for-one-one-bar-chart-with-two-types-of-numerical-data\/#primaryimage\",\"url\":\"https:\/\/sarahpallett.com\/wp-content\/uploads\/2025\/04\/Screenshot-2025-04-29-204219.png\",\"contentUrl\":\"https:\/\/sarahpallett.com\/wp-content\/uploads\/2025\/04\/Screenshot-2025-04-29-204219.png\",\"width\":233,\"height\":304},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/sarahpallett.com\/index.php\/2025\/04\/30\/two-for-one-one-bar-chart-with-two-types-of-numerical-data\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/sarahpallett.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Two for One: One bar chart with two types of numerical data\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/sarahpallett.com\/#website\",\"url\":\"https:\/\/sarahpallett.com\/\",\"name\":\"Sarah Pallett\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/sarahpallett.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/sarahpallett.com\/#\/schema\/person\/dce769f945c604f38bb244e91205abe8\",\"name\":\"Sarah\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/sarahpallett.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/4ded2c9e00b6c56390986018adbae452?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/4ded2c9e00b6c56390986018adbae452?s=96&d=mm&r=g\",\"caption\":\"Sarah\"},\"sameAs\":[\"https:\/\/sarahpallett.com\/wp\"],\"url\":\"https:\/\/sarahpallett.com\/index.php\/author\/admin_sp\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Two for One: One bar chart with two types of numerical data - Sarah Pallett","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/sarahpallett.com\/index.php\/2025\/04\/30\/two-for-one-one-bar-chart-with-two-types-of-numerical-data\/","og_locale":"en_US","og_type":"article","og_title":"Two for One: One bar chart with two types of numerical data - Sarah Pallett","og_description":"Looking for a simple way to boost interactivity and pack more analytic value into a single bar chart? In this Help Desk Dashboard, we wanted to track the weekly number of tickets and the percentage each week contributed to the total. At first, we used two separate bar charts, one for the raw counts and... Continue Reading &rarr;","og_url":"https:\/\/sarahpallett.com\/index.php\/2025\/04\/30\/two-for-one-one-bar-chart-with-two-types-of-numerical-data\/","og_site_name":"Sarah Pallett","article_published_time":"2025-04-30T18:54:33+00:00","article_modified_time":"2025-04-30T18:54:35+00:00","og_image":[{"width":233,"height":304,"url":"https:\/\/sarahpallett.com\/wp-content\/uploads\/2025\/04\/Screenshot-2025-04-29-204219.png","type":"image\/png"}],"author":"Sarah","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Sarah","Est. reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/sarahpallett.com\/index.php\/2025\/04\/30\/two-for-one-one-bar-chart-with-two-types-of-numerical-data\/#article","isPartOf":{"@id":"https:\/\/sarahpallett.com\/index.php\/2025\/04\/30\/two-for-one-one-bar-chart-with-two-types-of-numerical-data\/"},"author":{"name":"Sarah","@id":"https:\/\/sarahpallett.com\/#\/schema\/person\/dce769f945c604f38bb244e91205abe8"},"headline":"Two for One: One bar chart with two types of numerical data","datePublished":"2025-04-30T18:54:33+00:00","dateModified":"2025-04-30T18:54:35+00:00","mainEntityOfPage":{"@id":"https:\/\/sarahpallett.com\/index.php\/2025\/04\/30\/two-for-one-one-bar-chart-with-two-types-of-numerical-data\/"},"wordCount":768,"commentCount":0,"image":{"@id":"https:\/\/sarahpallett.com\/index.php\/2025\/04\/30\/two-for-one-one-bar-chart-with-two-types-of-numerical-data\/#primaryimage"},"thumbnailUrl":"https:\/\/sarahpallett.com\/wp-content\/uploads\/2025\/04\/Screenshot-2025-04-29-204219.png","keywords":["DataViz","Tableau","TableauPublic","TableauTip"],"articleSection":["The Inside Scoop"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/sarahpallett.com\/index.php\/2025\/04\/30\/two-for-one-one-bar-chart-with-two-types-of-numerical-data\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/sarahpallett.com\/index.php\/2025\/04\/30\/two-for-one-one-bar-chart-with-two-types-of-numerical-data\/","url":"https:\/\/sarahpallett.com\/index.php\/2025\/04\/30\/two-for-one-one-bar-chart-with-two-types-of-numerical-data\/","name":"Two for One: One bar chart with two types of numerical data - Sarah Pallett","isPartOf":{"@id":"https:\/\/sarahpallett.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/sarahpallett.com\/index.php\/2025\/04\/30\/two-for-one-one-bar-chart-with-two-types-of-numerical-data\/#primaryimage"},"image":{"@id":"https:\/\/sarahpallett.com\/index.php\/2025\/04\/30\/two-for-one-one-bar-chart-with-two-types-of-numerical-data\/#primaryimage"},"thumbnailUrl":"https:\/\/sarahpallett.com\/wp-content\/uploads\/2025\/04\/Screenshot-2025-04-29-204219.png","datePublished":"2025-04-30T18:54:33+00:00","dateModified":"2025-04-30T18:54:35+00:00","author":{"@id":"https:\/\/sarahpallett.com\/#\/schema\/person\/dce769f945c604f38bb244e91205abe8"},"breadcrumb":{"@id":"https:\/\/sarahpallett.com\/index.php\/2025\/04\/30\/two-for-one-one-bar-chart-with-two-types-of-numerical-data\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/sarahpallett.com\/index.php\/2025\/04\/30\/two-for-one-one-bar-chart-with-two-types-of-numerical-data\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/sarahpallett.com\/index.php\/2025\/04\/30\/two-for-one-one-bar-chart-with-two-types-of-numerical-data\/#primaryimage","url":"https:\/\/sarahpallett.com\/wp-content\/uploads\/2025\/04\/Screenshot-2025-04-29-204219.png","contentUrl":"https:\/\/sarahpallett.com\/wp-content\/uploads\/2025\/04\/Screenshot-2025-04-29-204219.png","width":233,"height":304},{"@type":"BreadcrumbList","@id":"https:\/\/sarahpallett.com\/index.php\/2025\/04\/30\/two-for-one-one-bar-chart-with-two-types-of-numerical-data\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/sarahpallett.com\/"},{"@type":"ListItem","position":2,"name":"Two for One: One bar chart with two types of numerical data"}]},{"@type":"WebSite","@id":"https:\/\/sarahpallett.com\/#website","url":"https:\/\/sarahpallett.com\/","name":"Sarah Pallett","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/sarahpallett.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/sarahpallett.com\/#\/schema\/person\/dce769f945c604f38bb244e91205abe8","name":"Sarah","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/sarahpallett.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/4ded2c9e00b6c56390986018adbae452?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/4ded2c9e00b6c56390986018adbae452?s=96&d=mm&r=g","caption":"Sarah"},"sameAs":["https:\/\/sarahpallett.com\/wp"],"url":"https:\/\/sarahpallett.com\/index.php\/author\/admin_sp\/"}]}},"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/sarahpallett.com\/index.php\/wp-json\/wp\/v2\/posts\/382","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sarahpallett.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sarahpallett.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sarahpallett.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sarahpallett.com\/index.php\/wp-json\/wp\/v2\/comments?post=382"}],"version-history":[{"count":8,"href":"https:\/\/sarahpallett.com\/index.php\/wp-json\/wp\/v2\/posts\/382\/revisions"}],"predecessor-version":[{"id":411,"href":"https:\/\/sarahpallett.com\/index.php\/wp-json\/wp\/v2\/posts\/382\/revisions\/411"}],"wp:attachment":[{"href":"https:\/\/sarahpallett.com\/index.php\/wp-json\/wp\/v2\/media?parent=382"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sarahpallett.com\/index.php\/wp-json\/wp\/v2\/categories?post=382"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sarahpallett.com\/index.php\/wp-json\/wp\/v2\/tags?post=382"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}