{"id":7830,"date":"2022-04-05T14:31:54","date_gmt":"2022-04-05T14:31:54","guid":{"rendered":"https:\/\/www.nimblework.com\/knowledge-base\/nimble\/?post_type=article&#038;p=7830"},"modified":"2025-02-06T18:50:52","modified_gmt":"2025-02-06T18:50:52","slug":"dual-axis-bar-line-graph","status":"publish","type":"article","link":"https:\/\/www.nimblework.com\/knowledge-base\/nimble\/article\/dual-axis-bar-line-graph\/","title":{"rendered":"Dual Axis Bar Line Graph"},"content":{"rendered":"<p>This article will familiarize you with the overview, and configuration of the Dual Axis Bar Line Graph.<\/p>\n<table style=\"line-height: 10px; height: 77px; width: 99.2704%; border-collapse: collapse; background-color: #f7f7f7;\">\n<tbody>\n<tr style=\"height: 108px;\">\n<td style=\"width: 100%; height: 77px;\">\n<p style=\"text-align: left;\"><strong>Skip Ahead to:<\/strong><\/p>\n<p style=\"line-height: 10px; text-align: left;\"><a href=\"#Overview\">Overview<\/a><\/p>\n<p style=\"text-align: left;\"><a href=\"#Configuration\">Configuration<\/a><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h2><a id=\"Overview\"><\/a>Overview<\/h2>\n<p>A dual-axis bar line graph shares a horizontal axis (time) across two chart types: the bar chart and line chart. It is useful when the variables plotted with each chart type are related, but are on different numeric scales.<\/p>\n<p><a href=\"https:\/\/www.nimblework.com\/knowledge-base\/nimble\/wp-content\/uploads\/2022\/04\/Dual_axis_bar_line.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-9120\" src=\"https:\/\/www.nimblework.com\/knowledge-base\/nimble\/wp-content\/uploads\/2022\/04\/Dual_axis_bar_line.jpg\" alt=\"\" width=\"561\" height=\"383\" srcset=\"https:\/\/www.nimblework.com\/knowledge-base\/nimble\/wp-content\/uploads\/2022\/04\/Dual_axis_bar_line.jpg 561w, https:\/\/www.nimblework.com\/knowledge-base\/nimble\/wp-content\/uploads\/2022\/04\/Dual_axis_bar_line-300x205.jpg 300w\" sizes=\"(max-width: 561px) 100vw, 561px\" \/><\/a><\/p>\n<h2><a id=\"Configuration\"><\/a>Configuration<\/h2>\n<p>To plot chart, perform the following steps &#8211;<\/p>\n<p>1. Open the Analytics page and click the <b>Add Widget<\/b> icon. The Analytics Builder appears.<\/p>\n<p>2. Click the\u00a0<b>Dual Axis Bar Line Graph<\/b>. The\u00a0<b>Settings<\/b>\u00a0page appears.<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-18133\" src=\"https:\/\/www.nimblework.com\/knowledge-base\/nimble\/wp-content\/uploads\/2022\/04\/Dual-line.png\" alt=\"Dual Axis Bar Line Graph\" width=\"1800\" height=\"982\" srcset=\"https:\/\/www.nimblework.com\/knowledge-base\/nimble\/wp-content\/uploads\/2022\/04\/Dual-line.png 1800w, https:\/\/www.nimblework.com\/knowledge-base\/nimble\/wp-content\/uploads\/2022\/04\/Dual-line-300x164.png 300w, https:\/\/www.nimblework.com\/knowledge-base\/nimble\/wp-content\/uploads\/2022\/04\/Dual-line-1024x559.png 1024w, https:\/\/www.nimblework.com\/knowledge-base\/nimble\/wp-content\/uploads\/2022\/04\/Dual-line-768x419.png 768w, https:\/\/www.nimblework.com\/knowledge-base\/nimble\/wp-content\/uploads\/2022\/04\/Dual-line-1536x838.png 1536w\" sizes=\"(max-width: 1800px) 100vw, 1800px\" \/><\/p>\n<p>3. Enter the given information in the Data Criteria and Dimension and Settings as per your requirements.<\/p>\n<ul>\n<li class=\"whs1\"><b>Widget Name<\/b>\u00a0&#8211; Modify the widget name if required.<\/li>\n<\/ul>\n<p class=\"whs2\"><b>Data Criteria<\/b><\/p>\n<ul>\n<li class=\"whs1\"><b>Select Workitem type<\/b>\u00a0&#8211; Select the workitem type for which you want to plot the chart. You can select any number of workitems for a scatter chart. If the selected workitem type has no instances in it, a message is displayed on the screen.<br \/>\n<strong>Note:\u00a0<\/strong>If you select the My Workitem option, the Release, Sprint, and Task Plan options won&#8217;t be selected as they are dependent on the form&#8217;s execution.<\/li>\n<li><strong>Select workitem status &#8211;<\/strong> Select the workitem status such as All, Open, Closed, etc. for the workitem types.<\/li>\n<li class=\"whs1\"><b>Select Filter<\/b>\u00a0&#8211; Select the filter that you want to apply on the workitems for the scatter chart. You can also create a new filter.<\/li>\n<li class=\"whs1\"><strong>Date Range &#8211;<\/strong> The Date Range section provides flexible options for selecting date-based criteria and ranges:\n<ul>\n<li><strong>Select Date Criteria<\/strong>: Use the dropdown menu to choose how data is fetched. Options include <strong>Created on<\/strong>, <strong>Closed on<\/strong>, and <strong>Last modified on<\/strong>.<\/li>\n<li><strong>Select Date Range<\/strong>: Choose dynamic or custom date ranges to automatically display data based on the selected period. The options include &#8211; <strong>Custom dates<\/strong> ( Requires additional selection of Start Date and End Date), <strong>Current month<\/strong>, <strong>Current quarter<\/strong>, <strong>Current week<\/strong>, <strong>Current year<\/strong> and many more.<\/li>\n<li>If &#8220;Custom dates&#8221; is selected, two additional dropdowns will appear to specify the Start Date and End Date.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p><strong>Note<\/strong>: For Organization Analytics and Personal Analytics, the Date Range section will only display Start Date and End Date options.<\/p>\n<p class=\"whs2\"><b>Dimensions and Settings<\/b><\/p>\n<ul>\n<li class=\"whs1\"><b>Select aggregation<\/b> &#8211; You can plot the chart based on the numeric field of the selected workitem type such as count, sum, percentage, etc.<\/li>\n<li class=\"li1\"><strong>Show Data Labels<\/strong> &#8211; Enable this option to view the data labels\/values on the chart.<\/li>\n<\/ul>\n<p class=\"whs3\"><strong>Select Axis on the chart<\/strong><\/p>\n<ul>\n<li class=\"whs1\"><b>X Axis<\/b>\u00a0&#8211; Select the attribute (and its values) which you want to be plotted on the X axis of the chart. The attribute field shows all the fields which are common in the selected workitem types.<\/li>\n<li class=\"whs1\">\u00a0<b>Y Axis<\/b>\u00a0(Line chart)- Select the attribute (and its values) which you want to be plotted on the Y axis of the Line chart.<\/li>\n<li class=\"whs1\">\u00a0<b>Y Axis<\/b>\u00a0(Bar chart) &#8211; Select the attribute (and its values) which you want to be plotted on the Y axis of the Bar chart.<\/li>\n<\/ul>\n<div class=\"helpful-block-content wth-theme-thumbs\" data-title=\"\" >\n<ul>\n<li><span class=\"wth-title\">Was this helpful?<\/span><\/li>\n<li><a data-post=\"7830\" data-post-url=\"https:\/\/www.nimblework.com\/knowledge-base\/nimble\/article\/dual-axis-bar-line-graph\/\" data-post-title=\"Dual Axis Bar Line Graph\" data-response=\"1\" href=\"#\" class=\"wth-green-btn icon-thumbsup\">Yes<\/a>&nbsp; &nbsp;<a data-response=\"0\" data-post=\"7830\" data-post-url=\"https:\/\/www.nimblework.com\/knowledge-base\/nimble\/article\/dual-axis-bar-line-graph\/\" data-post-title=\"Dual Axis Bar Line Graph\" href=\"#\" class=\"wth-red-btn icon-thumbsdown\">No<\/a><\/li>\n<\/ul>\n<\/div>","protected":false},"author":1,"featured_media":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","multi-rating":{"mr_rating_results":[]},"_links":{"self":[{"href":"https:\/\/www.nimblework.com\/knowledge-base\/nimble\/wp-json\/wp\/v2\/article\/7830"}],"collection":[{"href":"https:\/\/www.nimblework.com\/knowledge-base\/nimble\/wp-json\/wp\/v2\/article"}],"about":[{"href":"https:\/\/www.nimblework.com\/knowledge-base\/nimble\/wp-json\/wp\/v2\/types\/article"}],"author":[{"embeddable":true,"href":"https:\/\/www.nimblework.com\/knowledge-base\/nimble\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.nimblework.com\/knowledge-base\/nimble\/wp-json\/wp\/v2\/comments?post=7830"}],"version-history":[{"count":10,"href":"https:\/\/www.nimblework.com\/knowledge-base\/nimble\/wp-json\/wp\/v2\/article\/7830\/revisions"}],"predecessor-version":[{"id":20527,"href":"https:\/\/www.nimblework.com\/knowledge-base\/nimble\/wp-json\/wp\/v2\/article\/7830\/revisions\/20527"}],"wp:attachment":[{"href":"https:\/\/www.nimblework.com\/knowledge-base\/nimble\/wp-json\/wp\/v2\/media?parent=7830"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}