---
title: "Count Completed Lots by Oven, Last 30 Days"
slug: "count-completed-lots-by-oven-last-30-days"
updated: 2026-03-17T18:31:48Z
published: 2026-03-17T18:31:48Z
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.

# Count Completed Lots by Oven, Last 30 Days

<iframe src="https://scribehow.com/embed/Count_Completed_Lots_by_Oven_Last_30_Days__P4ZNx5_iSZqpE2ks4HUTcg" width="800" height="679" allow="fullscreen" style="aspect-ratio: 1 / 1; border: 0; min-height: 480px"></iframe>

Learn how to create a table analysis in Tulip to count completed lots for each oven over the last 30 days. This guide will walk you through setting up the necessary groupings and filters to gain valuable insights into your production data.

1\. Navigate to a station activity history table.

![](https://colony-recorder.s3.amazonaws.com/files/2026-03-03/daf16709-0555-479a-8237-4419964fb736/ascreenshot_7e43e1e42f0f443b8f024e4adb2d9780_text_export.jpeg)


2\. Click this button.

![](https://colony-recorder.s3.amazonaws.com/files/2026-03-03/daf16709-0555-479a-8237-4419964fb736/ascreenshot_51dee97be8d443bf960cadc6cb34916d_text_export.jpeg)


3\. Click "View Table Analyses"

![](https://colony-recorder.s3.amazonaws.com/files/2026-03-03/1b61747f-78ff-4cf4-8b9c-9865264bdbb1/ascreenshot_9b73c07faaa64a05aa2f44ded47f31b5_text_export.jpeg)


4\. Click "Create Analysis"

![](https://colony-recorder.s3.amazonaws.com/files/2026-03-03/d9faab4c-3258-4b36-b480-12bae726bee5/ascreenshot_6e3ddbca18eb4f3aac02336cf37975ca_text_export.jpeg)


5\. Click this button.

![](https://colony-recorder.s3.amazonaws.com/files/2026-03-03/ff5afe51-9095-49ef-aee1-389940eba1ac/ascreenshot_111d0d1f9f254557bf888ede229bbf7f_text_export.jpeg)


6\. Click this icon.

![](https://colony-recorder.s3.amazonaws.com/files/2026-03-03/24a5c1a8-db89-4307-8145-e77f94082ab6/ascreenshot_2c647fa273c04884bfbe33276bb96ff9_text_export.jpeg)


7\. Click "No groupings"

![](https://colony-recorder.s3.amazonaws.com/files/2026-03-03/e3d57d89-3eda-445a-8ea8-1349857eea44/ascreenshot_81e196aba8cd48e0abf4730a476328a6_text_export.jpeg)


8\. Click "Add a grouping"

![](https://colony-recorder.s3.amazonaws.com/files/2026-03-03/2b7524a4-41a3-4332-9966-943305485023/ascreenshot_e6478387a15745ce80f035aa71dae7d0_text_export.jpeg)


9\. Click "Table Fields"

![](https://colony-recorder.s3.amazonaws.com/files/2026-03-03/26ffa21a-5573-4933-a48f-e0c3797fc8fa/ascreenshot_7bd9821c55a8489480bad98ae083c22b_text_export.jpeg)


10\. Click "(Log) Station Activity History Oven Name"

![](https://colony-recorder.s3.amazonaws.com/files/2026-03-03/068498e5-799d-4344-9188-bc8d219fdfaf/ascreenshot_536e04d9a57a45cb890b0c846aac942e_text_export.jpeg)


11\. Click "operations"

![](https://colony-recorder.s3.amazonaws.com/files/2026-03-03/b551e8dc-58aa-439f-946f-94841501d35c/ascreenshot_3ba57b13eacb4fb5b6dd6ea3d285fb19_text_export.jpeg)


12\. Click "Add a new operation"

![](https://colony-recorder.s3.amazonaws.com/files/2026-03-03/daea5649-ac3e-4041-8578-de1622854fdf/ascreenshot_baebe4eaffe14efaa1a40eb78e240d7f_text_export.jpeg)


13\. Click "Aggregation Functions"

![](https://colony-recorder.s3.amazonaws.com/files/2026-03-03/2c345f23-150b-49cb-bdb4-9ed63644d890/ascreenshot_427748091a5c41e6800b3c12b830b316_text_export.jpeg)


14\. Click "Count of Records"

![](https://colony-recorder.s3.amazonaws.com/files/2026-03-03/8e3d0964-4f82-457e-a263-9b3ca48e813f/ascreenshot_4b1f9a245d0841c8a4dbbc51dc98f83d_text_export.jpeg)


15\. Click "filters"

![](https://colony-recorder.s3.amazonaws.com/files/2026-03-03/abb5d7eb-e28e-40e9-9d09-094b04e4c2e3/ascreenshot_66d9ccf0c5c34854a3a4be4e7f8a5906_text_export.jpeg)


16\. Click "Add a new filter"

![](https://colony-recorder.s3.amazonaws.com/files/2026-03-03/e2caa1af-950f-45d6-a228-2a0d2f4cfa5a/ascreenshot_5312fde660b24d04920fb593306f974d_text_export.jpeg)


Tip: This allows you to filter based on just completed lots by oven, ignoring ones that have been started but not completed


17\. Click "Fields"

![](https://colony-recorder.s3.amazonaws.com/files/2026-03-03/7e97475b-8ec2-4fdc-88c8-0de65915125d/ascreenshot_3e040a63b6424d8a90d645cd2726ee4e_text_export.jpeg)


18\. Click "(Log) Station Activity History End Date/Time"

![](https://colony-recorder.s3.amazonaws.com/files/2026-03-03/09a98ee7-b168-4a54-a4fe-9d3d39d7384b/ascreenshot_a41f8ea8e4244a67a4b1778708c1f39b_text_export.jpeg)


19\. Click "Equals"

![](https://colony-recorder.s3.amazonaws.com/files/2026-03-03/0e114535-3909-4176-bab6-2e410aca25c4/ascreenshot_e555d6a9259d4a968e7f88c622ad8945_text_export.jpeg)


20\. Click "Is Not Null"

![](https://colony-recorder.s3.amazonaws.com/files/2026-03-03/700ac8b2-04dd-4836-b4fa-71b241c62f0a/ascreenshot_d5c274589532403d807687536e8e84f3_text_export.jpeg)


21\. Click this icon.

![](https://colony-recorder.s3.amazonaws.com/files/2026-03-03/76db12da-8f6a-4f98-9a3b-c1e411c2d523/ascreenshot_fe39e2de2cd6421bbd67ea421321233d_text_export.jpeg)


22\. Type "Completed Lots by Oven, Last 30 Days"


23\. Click "Save"

![](https://colony-recorder.s3.amazonaws.com/files/2026-03-03/5223c44a-1403-41e0-9530-358ea5d2daf9/ascreenshot_d29d3362faaf4419a2a5227f1f139272_text_export.jpeg)


24\. Click "Save and Close"

![](https://colony-recorder.s3.amazonaws.com/files/2026-03-03/aaf1da43-1397-42b2-9b30-3daa4cb65a2c/ascreenshot_d70b5a271b2247929a6c50b735161a12_text_export.jpeg)