---
title: "Create a New Query With Filters and Aggregations"
slug: "create-a-new-query-with-filters-and-aggregations"
updated: 2026-03-25T01:56:19Z
published: 2026-03-25T01:56:19Z
canonical: "support.tulip.co/create-a-new-query-with-filters-and-aggregations"
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 a New Query With Filters and Aggregations

[Embedded content](https://scribehow.com/embed/Create_a_New_Query_With_Filters_and_Aggregations__i6Mt6i3yTfKeOeAS-mIbSw)

Learn how to build a new query in Tulip by adding filters and aggregations. This guide walks you through setting up a query to identify specific data points within your Tulip tables, ensuring you can access and analyze the information you need efficiently.

1. Click "Queries"

![](https://colony-recorder.s3.amazonaws.com/files/2026-03-24/53538eca-481d-401d-ad9a-5510cef806dd/ascreenshot_69f33c1b68f142069dadd2bffbdc0620_text_export.jpeg)

2. Click "Create New Query"

![](https://colony-recorder.s3.amazonaws.com/files/2026-03-24/d298c80a-b6e2-4523-92b8-fa27ce46fbf7/ascreenshot_23b5e1c2c7354c27bd32aeeaf9fa274d_text_export.jpeg)

3. Click the "Query Name" field.

![](https://colony-recorder.s3.amazonaws.com/files/2026-03-24/bccd8405-420d-4c74-bb97-c3e6b678e8fe/ascreenshot_9c723433f75948dfb661150b6d6933be_text_export.jpeg)

4. Type "Current Inspection"

5. Click "Filters (0)"

![](https://colony-recorder.s3.amazonaws.com/files/2026-03-24/234a4fc5-e9d0-4d21-b56a-646c50af4232/ascreenshot_3114046bad5146f59c9e922e37035894_text_export.jpeg)

6. Click "+ Add Filter"

![](https://colony-recorder.s3.amazonaws.com/files/2026-03-24/a9357850-f7db-45a6-af04-4406dd9dc06e/ascreenshot_24175ed18c5a46f794063fa89548fdf6_text_export.jpeg)

7. Click this icon.

![](https://colony-recorder.s3.amazonaws.com/files/2026-03-24/77bce613-fad3-4a58-af22-e65c007fe02b/ascreenshot_8026f428793a4f6085ab79146a267fb6_text_export.jpeg)

8. Click "Measurement"

![](https://colony-recorder.s3.amazonaws.com/files/2026-03-24/f2cedd9b-369d-414b-91e6-0f52baebdd08/ascreenshot_65c67972f2874e9ead38a61107647cbe_text_export.jpeg)

9. Click "Static value"

![](https://colony-recorder.s3.amazonaws.com/files/2026-03-24/b52d1f12-3a92-4a80-97bc-1891d7002195/ascreenshot_fd121f384d4d47ad93d5b79d8341b430_text_export.jpeg)

10. Click "App input"

![](https://colony-recorder.s3.amazonaws.com/files/2026-03-24/94564aae-16e0-493a-b48b-9955339d21ac/ascreenshot_9072b9f58d164d5c9ce03ce75514bf6c_text_export.jpeg)

11. Click "Limit (1000)"

![](https://colony-recorder.s3.amazonaws.com/files/2026-03-24/77c104f3-8737-4549-829a-4f9bbdc794cb/ascreenshot_0e9f94adf35541adbb76bcf8b6dfeb1d_text_export.jpeg)

12. Click this text field.

![](https://colony-recorder.s3.amazonaws.com/files/2026-03-24/145c8eac-97b1-48c1-be6b-8ac4a5ded205/ascreenshot_6c6a9b325aac4ae693a4e5d059beab6e_text_export.jpeg)

13. Click this text field.

![](https://colony-recorder.s3.amazonaws.com/files/2026-03-24/e7661b04-b68d-4dfb-853c-0df00b647ffd/ascreenshot_8f6a732f89d7473fb0415880f5fb7dd1_text_export.jpeg)

14. Type " [[Backspace]]"

15. Click "Save"

![](https://colony-recorder.s3.amazonaws.com/files/2026-03-24/0dd16e5d-ad16-43da-ac2f-0ef5ae14bccf/ascreenshot_9580ff8ad7094681b6b960d5c8fcce63_text_export.jpeg)

16. Click "Aggregations"

![](https://colony-recorder.s3.amazonaws.com/files/2026-03-24/e0c44d28-0638-4d83-8245-75b82b201629/ascreenshot_a232850a855a418d8f370d88544ca238_text_export.jpeg)

17. Click "Edit"

![](https://colony-recorder.s3.amazonaws.com/files/2026-03-24/63c67f4d-3d52-4443-8638-04606e2241d8/ascreenshot_53aa30a14df14083aa378af748274384_text_export.jpeg)

18. Click "+Add aggregation"

![](https://colony-recorder.s3.amazonaws.com/files/2026-03-24/bfb4bce7-9f88-4567-96db-39d6a1eac329/ascreenshot_2f8c0d0f0506462bb5eded683752209a_text_export.jpeg)

19. Click the "Aggregation Name" field.

![](https://colony-recorder.s3.amazonaws.com/files/2026-03-24/249a7de7-d3e6-46dd-8d11-fbc26f3ebd58/ascreenshot_9fe11f45f2cb4e4ba0d5d46ab8071928_text_export.jpeg)

20. Type "Active Inspection"

21. Click "Select an option"

![](https://colony-recorder.s3.amazonaws.com/files/2026-03-24/6e723596-157e-4585-951e-dca626729a28/ascreenshot_7a1f4bc9be1c45d2bede7609ebe621da_text_export.jpeg)

22. Click "Mode"

![](https://colony-recorder.s3.amazonaws.com/files/2026-03-24/f8a9749f-1d83-4387-8291-c08ec9215cb7/ascreenshot_d9f562d706df4a5581cae98b94e32fc2_text_export.jpeg)

23. Click "Select an option"

![](https://colony-recorder.s3.amazonaws.com/files/2026-03-24/0036c785-5b64-4bf3-8e8b-3e37914a632b/ascreenshot_714cfe47cceb44fda869194288743aac_text_export.jpeg)

24. Click "ID"

![](https://colony-recorder.s3.amazonaws.com/files/2026-03-24/39ed7f53-0b28-4028-9b49-09a8ecee1d46/ascreenshot_5cf7d530ad074fca8afa2429d75771d8_text_export.jpeg)

25. Click "Save"

![](https://colony-recorder.s3.amazonaws.com/files/2026-03-24/9938acd3-beea-4e0d-b410-d8b686a17834/ascreenshot_94804d97488a4098a2f5b85d21a48599_text_export.jpeg)