{"id":17217,"date":"2023-08-18T14:19:45","date_gmt":"2023-08-18T14:19:45","guid":{"rendered":"https:\/\/www.nimblework.com\/knowledge-base\/nimble\/?post_type=article&#038;p=17217"},"modified":"2024-10-18T08:11:30","modified_gmt":"2024-10-18T08:11:30","slug":"timesheet-data-analytics","status":"publish","type":"article","link":"https:\/\/www.nimblework.com\/knowledge-base\/nimble\/article\/timesheet-data-analytics\/","title":{"rendered":"Timesheet Data Analysis"},"content":{"rendered":"<p>Start with the video first to get a better grasp of the topic!<br \/>\n<iframe loading=\"lazy\" title=\"Learn to Plot Timesheet Analysis using Nimble Analytics\" src=\"https:\/\/player.vimeo.com\/video\/948608428?dnt=1&amp;app_id=122963\" width=\"500\" height=\"269\" frameborder=\"0\" allow=\"autoplay; fullscreen; picture-in-picture; clipboard-write\"><\/iframe><\/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=\"#ConfiguringCharPivotTable\">Configuring Timesheet Data Analysis<\/a><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h2><a id=\"Overview\"><\/a>Overview<\/h2>\n<p>The Timesheet Data Analysis is a powerful data summarization feature that you can use to quickly summarize the timesheet data of your team in a tabular or chart format. You can refine the data based on date filter or <a href=\"https:\/\/www.nimblework.com\/knowledge-base\/nimble\/article\/how-to-filter-the-list-views\/#AdvancedFilter\">advanced filter<\/a> or both, and design the analytics based on various attributes such as Resource, Card ID, Card Name, Timelog date, Release, Sprint etc.<\/p>\n<p>You can also change the table or chart format from the drop-down list. You can plot a Timesheet Data Analysis in Table, Pie chart, Bar chart, Horizontal bar chart, and Line chart. <strong>Note:<\/strong> By default, a Table is selected.<\/p>\n<p>Moreover, you can export the table into Microsoft\u00ae Excel, Word, and PDF to view them offline. The Timesheet Analysis widget is available at the project level as well as My Analytics.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-17249\" src=\"https:\/\/www.nimblework.com\/knowledge-base\/nimble\/wp-content\/uploads\/2023\/08\/Timesheet-Data-Analysis.png\" alt=\"Timesheet Data Analysis\" width=\"1658\" height=\"1204\" srcset=\"https:\/\/www.nimblework.com\/knowledge-base\/nimble\/wp-content\/uploads\/2023\/08\/Timesheet-Data-Analysis.png 1658w, https:\/\/www.nimblework.com\/knowledge-base\/nimble\/wp-content\/uploads\/2023\/08\/Timesheet-Data-Analysis-300x218.png 300w, https:\/\/www.nimblework.com\/knowledge-base\/nimble\/wp-content\/uploads\/2023\/08\/Timesheet-Data-Analysis-1024x744.png 1024w, https:\/\/www.nimblework.com\/knowledge-base\/nimble\/wp-content\/uploads\/2023\/08\/Timesheet-Data-Analysis-768x558.png 768w, https:\/\/www.nimblework.com\/knowledge-base\/nimble\/wp-content\/uploads\/2023\/08\/Timesheet-Data-Analysis-1536x1115.png 1536w\" sizes=\"(max-width: 1658px) 100vw, 1658px\" \/><\/p>\n<h2><a id=\"ConfiguringCharPivotTable\"><\/a>Configuring Timesheet Data Analysis<\/h2>\n<p>The Timesheet Data Analysis is plotted as per the data condition values set on its settings page. To interpret a Timesheet Data Analysis:<\/p>\n<ol class=\"whs4\" type=\"1\">\n<li class=\"p\">Navigate to Analytics Builder, and select the Timesheet Analysis widget.<\/li>\n<li class=\"p\">Or you can skip to the Standard widgets. and from the <strong>Workitem Analytics <\/strong>section, click the <strong>Timesheet Data Analysis<\/strong>. The Settings page appears.<\/li>\n<li class=\"p\">Select the required criteria such as team members, filter, and date range. If you are plotting Timesheet Analysis at the <strong>My Analytics<\/strong> level, then select the required projects.<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-17250\" src=\"https:\/\/www.nimblework.com\/knowledge-base\/nimble\/wp-content\/uploads\/2023\/08\/Timesheet-Settings-.png\" alt=\"Timesheet Data Analysis Settings\" width=\"2106\" height=\"1094\" srcset=\"https:\/\/www.nimblework.com\/knowledge-base\/nimble\/wp-content\/uploads\/2023\/08\/Timesheet-Settings-.png 2106w, https:\/\/www.nimblework.com\/knowledge-base\/nimble\/wp-content\/uploads\/2023\/08\/Timesheet-Settings--300x156.png 300w, https:\/\/www.nimblework.com\/knowledge-base\/nimble\/wp-content\/uploads\/2023\/08\/Timesheet-Settings--1024x532.png 1024w, https:\/\/www.nimblework.com\/knowledge-base\/nimble\/wp-content\/uploads\/2023\/08\/Timesheet-Settings--768x399.png 768w, https:\/\/www.nimblework.com\/knowledge-base\/nimble\/wp-content\/uploads\/2023\/08\/Timesheet-Settings--1536x798.png 1536w, https:\/\/www.nimblework.com\/knowledge-base\/nimble\/wp-content\/uploads\/2023\/08\/Timesheet-Settings--2048x1064.png 2048w\" sizes=\"(max-width: 2106px) 100vw, 2106px\" \/><\/li>\n<li>Select the chart settings such as aggregation (Sum or Average), and chart type from the drop-down list and select whether to show or not the total of the rows and columns.<\/li>\n<li>The applicable attributes appear. Drag the attributes that you want to plot in your Timesheet Analysis to the right pane. You can also filter the value of the attributes by clicking the filter icon on the attribute and specifying the correct values.<\/li>\n<li class=\"p\">If there are no total rows or columns to be displayed in the table, then the respective toggle under the Chart Settings will turn off. To see the total of rows\/columns, place the respective attribute in the top row or left column respectively.<\/li>\n<li class=\"p\">Select the required chart type from the drop-down list. You can plot a Timesheet Data Analysis in Table, Pie chart, Bar chart, Horizontal bar chart, and Line chart.<\/li>\n<li class=\"p\">Click the\u00a0<b>Save<\/b> button.<\/li>\n<\/ol>\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=\"17217\" data-post-url=\"https:\/\/www.nimblework.com\/knowledge-base\/nimble\/article\/timesheet-data-analytics\/\" data-post-title=\"Timesheet Data Analysis\" data-response=\"1\" href=\"#\" class=\"wth-green-btn icon-thumbsup\">Yes<\/a>&nbsp; &nbsp;<a data-response=\"0\" data-post=\"17217\" data-post-url=\"https:\/\/www.nimblework.com\/knowledge-base\/nimble\/article\/timesheet-data-analytics\/\" data-post-title=\"Timesheet Data Analysis\" href=\"#\" class=\"wth-red-btn icon-thumbsdown\">No<\/a><\/li>\n<\/ul>\n<\/div>","protected":false},"author":2,"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\/17217"}],"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\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.nimblework.com\/knowledge-base\/nimble\/wp-json\/wp\/v2\/comments?post=17217"}],"version-history":[{"count":14,"href":"https:\/\/www.nimblework.com\/knowledge-base\/nimble\/wp-json\/wp\/v2\/article\/17217\/revisions"}],"predecessor-version":[{"id":19776,"href":"https:\/\/www.nimblework.com\/knowledge-base\/nimble\/wp-json\/wp\/v2\/article\/17217\/revisions\/19776"}],"wp:attachment":[{"href":"https:\/\/www.nimblework.com\/knowledge-base\/nimble\/wp-json\/wp\/v2\/media?parent=17217"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}