--- title: "Create Bar Chart Analysis of Shift Productivity" slug: "create-bar-chart-analysis-of-shift-productivity" updated: 2026-03-17T18:30:27Z published: 2026-03-17T18:30:27Z canonical: "support.tulip.co/create-bar-chart-analysis-of-shift-productivity" excludeFromSearch: true --- > ## Documentation Index > Fetch the complete documentation index at: https://support.tulip.co/llms.txt > Use this file to discover all available pages before exploring further. # Create Bar Chart Analysis of Shift Productivity This guide will walk you through setting up a count of completed lots by shift type over the last 7 days. 1\. Navigate to a station activity history table. ![](https://colony-recorder.s3.amazonaws.com/files/2026-03-03/8aa34295-2f23-4c8d-a1db-8b660ccaa616/ascreenshot_77cad8e86d724537a6402411e685a3fd_text_export.jpeg) 2\. Click this icon. ![](https://colony-recorder.s3.amazonaws.com/files/2026-03-03/8aa34295-2f23-4c8d-a1db-8b660ccaa616/ascreenshot_c2f0a07d504549f4a68f6bdd30814a84_text_export.jpeg) 3\. Click "View Table Analyses" ![](https://colony-recorder.s3.amazonaws.com/files/2026-03-03/24c7a456-d739-4c68-ad43-3083ed68b0fc/ascreenshot_5f4a5d942b8c4522a3e5b6b00f309ab0_text_export.jpeg) 4\. Click "Create Analysis" ![](https://colony-recorder.s3.amazonaws.com/files/2026-03-03/406aa2fd-219a-4669-a4e7-ab3f02931109/ascreenshot_e39fbf9872ac4223b4c8ff3fa7e126e9_text_export.jpeg) 5\. Click "No groupings" ![](https://colony-recorder.s3.amazonaws.com/files/2026-03-03/4afafd87-abea-48a2-949f-1306bbc68999/ascreenshot_4199abd7529d47dcbe71b11aeb70852a_text_export.jpeg) 6\. Click "Add a grouping" ![](https://colony-recorder.s3.amazonaws.com/files/2026-03-03/5c06c542-1825-4585-aa15-1071ce40f055/ascreenshot_ab9c0bde45af4b78aa44d459254a7731_text_export.jpeg) Tip: Groupings determine how you group your data 7\. Click "Table Fields" ![](https://colony-recorder.s3.amazonaws.com/files/2026-03-03/4222f14e-fabf-485b-9ef8-9e901db5c455/ascreenshot_330ed7ae82ea4b1298e65f6ed0de1790_text_export.jpeg) 8\. Click "(Log) Station Activity History Shift Type" ![](https://colony-recorder.s3.amazonaws.com/files/2026-03-03/3036e0f2-67fc-474c-8950-de44dce59c72/ascreenshot_29203197bfdc426393633f7b3b7be363_text_export.jpeg) 9\. Click "No Operations" ![](https://colony-recorder.s3.amazonaws.com/files/2026-03-03/bf43d15d-8218-423e-ac83-7e238c3e0dfb/ascreenshot_d49ecebfa4b64851af4e23dd48869ba1_text_export.jpeg) Tip: Operations are the numeric value you want to track 10\. Click "Add a new operation" ![](https://colony-recorder.s3.amazonaws.com/files/2026-03-03/b52c7391-fcaa-417b-80a8-e05c257f2d79/ascreenshot_ee856af07d4a41f78d9c53d2e697a3fa_text_export.jpeg) 11\. Click "Aggregation Functions" ![](https://colony-recorder.s3.amazonaws.com/files/2026-03-03/58b40870-72fc-4057-a9a4-e3af57c791f2/ascreenshot_ee5e9f295d8a41efb425eefc0ddaeec8_text_export.jpeg) 12\. Click "Count of Records" ![](https://colony-recorder.s3.amazonaws.com/files/2026-03-03/4e8d0a12-f64f-4625-b940-e5b059dcb067/ascreenshot_28470bb26b7942dfa54bd7d091a34161_text_export.jpeg) Tip: Count of Records is the count of records in a table that satisfies a certain condition 13\. Click "Table" ![](https://colony-recorder.s3.amazonaws.com/files/2026-03-03/07d99c0a-6a35-4322-9d34-99fc6748a0c4/ascreenshot_bc706cd2b529400e9ab5e50d28b85886_text_export.jpeg) 14\. Click "Bar" ![](https://colony-recorder.s3.amazonaws.com/files/2026-03-03/5d7903b0-43f0-4948-93a4-77ad8b437b38/ascreenshot_93099fbae8c44cec98cbb53dc211685c_text_export.jpeg) 15\. Click this icon. ![](https://colony-recorder.s3.amazonaws.com/files/2026-03-03/e768c90d-9358-4139-ad32-8a590cd60eee/ascreenshot_b20956e1b87645f1800bca144b023d12_text_export.jpeg) 16\. Click "Add field" ![](https://colony-recorder.s3.amazonaws.com/files/2026-03-03/364718e9-d243-4d6e-9231-f0da042b0c77/ascreenshot_b49696191c064a8494b2349c9bc271dc_text_export.jpeg) 17\. Click "Count of Records" ![](https://colony-recorder.s3.amazonaws.com/files/2026-03-03/cd4997c8-0057-4097-89f6-81d668b83b2d/ascreenshot_37b9a4560b574532993dabcc6eac7ecd_text_export.jpeg) 18\. Click "Add field" ![](https://colony-recorder.s3.amazonaws.com/files/2026-03-03/d857bd62-6ad2-4979-9173-476b07a2176e/ascreenshot_1357353120474878ae5291bd1b9156d0_text_export.jpeg) 19\. Click "Shift Type" ![](https://colony-recorder.s3.amazonaws.com/files/2026-03-03/00b886fa-6d34-4312-93be-732c1c837ebe/ascreenshot_a44e1fdedc70473a87edaf88e277b4c6_text_export.jpeg) 20\. Click "Unnamed Analysis" ![](https://colony-recorder.s3.amazonaws.com/files/2026-03-03/5aa43983-0434-45c0-a7e9-3243cfd38d5e/ascreenshot_8c9ff775a0774083a9617147c4990e1c_text_export.jpeg) 21\. Type "Count of Completed" 22\. Double-click this text field. ![](https://colony-recorder.s3.amazonaws.com/files/2026-03-03/34f0d98d-9242-4a94-8d97-af95c6333023/ascreenshot_e68106b1269a4932ab7fd4e14e6f68f0_text_export.jpeg) 23\. Type "Completed Lots by Shift, Weekly" 24\. Click "Save" ![](https://colony-recorder.s3.amazonaws.com/files/2026-03-03/95a2fc59-dafe-499e-bfee-c350b9d65ba9/ascreenshot_50146cce608c415999b8781681c20c2f_text_export.jpeg) 25\. Click "Last 30 Days" ![](https://colony-recorder.s3.amazonaws.com/files/2026-03-03/dfb7cbe9-ebae-4f50-b598-9ea0f132cae1/ascreenshot_d6e3641675cc427cb1e56e4fb7db9a40_text_export.jpeg) 26\. Select the "Last 7 Days" option. ![](https://colony-recorder.s3.amazonaws.com/files/2026-03-03/8be22fa0-7da7-4073-9d7d-ceb604defb9f/ascreenshot_a11003b6868d4172b71ae7a9752c936c_text_export.jpeg) 27\. Click "Save and Close" ![](https://colony-recorder.s3.amazonaws.com/files/2026-03-03/c738050a-b2d5-43b9-aec1-8e38797cc6a2/ascreenshot_259b32a2679845899096ddb148935c66_text_export.jpeg)