# Filter/ Data Control

### **Date range filter** <a href="#od_0ca98877" id="od_0ca98877"></a>

#### **Create a date range filter**

Date range filter allows you to filter your report data based on **a date and time range.**

1. Click on the ![](/files/AFKtVFP4GsMA3BaZXSTC)icon on the left toolbar to show the list of available filters

<img src="https://api.filerobot.com/opendocs-global/v1/get/521139a2-4520-5a43-89c2-a34332950000" alt="Photo alt #responsive" width="188">

1. Select **Date range filter** to begin adding this type of filter to the canvas
2. Drag select an area on the canvas to place the filter on the dashboard&#x20;

<img src="https://api.filerobot.com/opendocs-global/v1/get/7ffe738a-1222-50be-aa22-5a0fbb050000" alt="Photo alt #responsive" width="375">

1. In the right panel, fill out the following fields in **Filter** tab to customize the functionality of the filter
2. **Label:** enter the name you want to name the filter
3. **Key:** select the parameters you’d like to use for the filter
4. **Default value:** select the from and to date range for the date filter
5. **Show time select:** select when you’d like to show the filter for time in addition to the date range
6. **Hide when exist on URL:** You can show or hide filter when you share via URL

#### **Style a date range filter**

1. **Search:** Search option you want to appear by text in the box
2. &#x20;**Label font size:** Choose the size for label
3. **Data font size:** Choose the size for Data
4. **Line break between and input:** Allow to break a line between label and data\
   a. Tick box to enable\
   b. Untick box to disable

<img src="https://api.filerobot.com/opendocs-global/v1/get/5ab62194-4e97-54ad-b0af-7a5f35150000" alt="Photo alt #responsive" width="375">

5. **Show description:** Note on the box, then you can see the question mark on the top right corner of filter

**Like style your chart, you can style your filter box by looking at the bottom toolbar below**

**From the left to the right:**

1. **Font:** Choose font for your filter
2. **Font size:** Choose size for your filter
3. **Format:** Bold, Italic
4. **Text color:** Color the filter text
5. **Fill color:** Fill color to the filter box
6. **Vertical alignment:** align the filter to top, center, bottom
7. **Border:**

* Weight: choose weight for the line of filter box
* Radius: Choose to round filter box
* Style: Style the line of filter box
* Color: Color the line of filter box

<img src="https://api.filerobot.com/opendocs-global/v1/get/4cd62560-54e8-589a-9336-4690d7650000" alt="Photo alt #responsive" width="375">

8. **Box alignment:**

Align the content inside the filter box to the side you want to set

<img src="https://api.filerobot.com/opendocs-global/v1/get/e71bda26-ce0e-5eb9-bc3a-9ccf47850000" alt="Photo alt #responsive" width="375">

9. **Box shadow:**\
   Tick box to enable box shadow Untick box to unable box shadow

<img src="https://api.filerobot.com/opendocs-global/v1/get/ec15c409-98f9-5759-9ebb-d41892a50000" alt="Photo alt #responsive" width="188">

### **Text filter** <a href="#od_7a2666ee" id="od_7a2666ee"></a>

Filter for matching text.

#### **Create a text filter**

1. Click on the **"filter"** to show the list of available filters

<img src="https://api.filerobot.com/opendocs-global/v1/get/26e5ad49-7ba8-59d7-9516-2b6a2ee50000" alt="Photo alt #responsive" width="188">

2. Select **“Text”** to begin adding this type of filter to the report canvas
3. Drag select an area on the canvas to place the filter on the report
4. In the right panel, fill out the following fields in **“Filter”** tab to customize the functionality of the filter

* **Label:** enter the name you want to name the filter
* **Key:** select the parameters you’d like to use for the filter c. Hide when exist on URL:\
  When enabled, this filter will be hidden when its param exists on the URL.<br>

Ex: filter is using params @my\_param&#x20;

Case 1: url is <https://app.dataflake.co/s/xxx/?my_param=value> => Filter is hidden&#x20;

Case 2: url is <https://app.dataflake.co/s/xxx>=> Filter is visible&#x20;

Case 3: url is <https://app.dataflake.co/s/xxx/?not_my_param=value> => Filter is visible

* **Select input:** if enabled, set settings for the following&#x20;

**Multiple select:** enabled if you want to allow viewers to apply multiple filter options at once\
**Default all options:** set default to all when using options from a datasource&#x20;

**Enabled** **Disabled:** will need to set **“Default value”** if disabled&#x20;

**Condition:** set the condition to be check against the value input

<img src="https://api.filerobot.com/opendocs-global/v1/get/f7018f3d-7bbc-56e7-831f-ad85d9250000" alt="Photo alt #responsive" width="375">

&#x20;**Options source**

**Manual:** input filter options by hand

* Click “Add an option” to manually add an option
* All added options are listed under “Options”

**Data source:** pull filter options from data through queries

<img src="https://api.filerobot.com/opendocs-global/v1/get/b10a4b09-dba8-5b4b-b958-2ce387e50000" alt="Photo alt #responsive" width="375">

* Choose database connection you would like to pull options from
* Choose a query from an already existing query
* Click **"+"** icon to add a new query

#### **Style a text filter** <a href="#od_1855638a" id="od_1855638a"></a>

To style the look of the filter, click on **Style** tab

1. **Search**: Search option you want to appear by text in the box
2. **Label font size**: Choose the size for label
3. **Data font size:** Choose the size for Data
4. **Line break between and input:** Allow to break a line between label and data

* Tick box to enable
* Untick box to disable

5. **Show description:** Note on the box, then you can see the question mark on the top right corner of filter

<img src="https://api.filerobot.com/opendocs-global/v1/get/2b6c2f3b-8ce3-5a14-a358-422825250000" alt="Photo alt #responsive" width="375">

**Like style your chart, you can style your filter box by looking at the bottom toolbar below:**

From the left to the right:

1. **Font:** Choose font for your filter
2. **Font size:** Choose size for your filter
3. **Format:** Bold, Italic
4. **Text color:** Color the filter text
5. **Fill color:** Fill color to the filter box
6. **Vertical alignment:** align the filter to top, center, bottom
7. **Border:**
8. **Weight:** choose weight for the line of filter box
9. **Radius:** Choose to round filter box
10. **Style:** Style the line of filter box
11. **Color:** Color the line of filter box

<img src="https://api.filerobot.com/opendocs-global/v1/get/bd9c6d9d-49a6-5bd9-9441-5e3a0d950000" alt="Photo alt #responsive" width="375">

12. **Box alignment**

Align the content inside the filter box to the side you want to set

<img src="https://api.filerobot.com/opendocs-global/v1/get/654a8ff2-d1ad-5dc0-9af4-943b7a850000" alt="Photo alt #responsive" width="188">

13. **Box shadow:**\
    Tick box to enable box shadow Untick box to unable box shadow

<img src="https://api.filerobot.com/opendocs-global/v1/get/8b66ab30-ae49-5b25-9267-82a332350000" alt="Photo alt #responsive" width="188">

### **Absolute time range** <a href="#od_ff16cef9" id="od_ff16cef9"></a>

#### **Create an absolute time range**

Use this filter if you would like to use something similar to **“Date range”** filter but with advanced customization options.

1. Click on the![](/files/fcFJKjEvBJ9ItXBZ9nfo)to show the list of available filters

<img src="https://api.filerobot.com/opendocs-global/v1/get/4c25c392-e286-5249-8cf9-31134bb50000" alt="Photo alt #responsive" width="188">

1. Select **Absolute time range** to begin adding this type of filter to the report canvas
2. Drag select an area on the canvas to place the filter on the report
3. In the right panel, fill out the following fields in **Filter** tab to customize the functionality of the filter

* **Label:** enter the name you want to name the filter
* **Key:** select the parameters you’d like to use for the filter&#x20;

**Default value**&#x20;

a. **Absolute time range:** enter the custom days from now () for from and to you would like to set&#x20;

b. **Around fixed value:** the day you would like to use as “now()”&#x20;

c.**Relative time range:** select a relative time range from now, Ex: when select “last 5 minutes” query params will have values “now()” and “now() - 5 minutes”

<img src="https://api.filerobot.com/opendocs-global/v1/get/63164c01-432e-5474-b31d-85a82f850000" alt="Photo alt #responsive" width="375">

#### **Style an absolute time range filter**

To style the look of the filter, click on **“Style”** tab

1. **Search:** Search option you want to appear by text in the box
2. **Label font size:** Choose the size for label
3. **Data font size:** Choose the size for Data
4. **Line break between and input:** Allow to break a line between label and data Tick box to enable Untick box to disable
5. **Description note:** Note on the box, then you can see the question mark on the top right corner of filter

<img src="https://api.filerobot.com/opendocs-global/v1/get/81309e20-5fef-5b35-bb34-b3c6e9750000" alt="Photo alt #responsive" width="375">

**Like style your chart, you can style your filter box by looking at the bottom toolbar below:**

From the left to the right:

1. **Font:** Choose font for your filter
2. **Font size:** Choose size for your filter
3. **Format:** Bold, Italic
4. **Text color:** Color the filter text
5. **Fill color:** Fill color to the filter box
6. **Vertical alignment:** align the filter to top, center, bottom
7. **Border:**
8. **Weight:** choose weight for the line of filter box
9. **Radius:** Choose to round filter box
10. **Style:** Style the line of filter box
11. **Color:** Color the line of filter box

<img src="https://api.filerobot.com/opendocs-global/v1/get/bd70d8e8-7077-5d71-b6a4-cedf53850000" alt="Photo alt #responsive" width="375">

12. **Box alignment**

Align the content inside the filter box to the side you want to set

<img src="https://api.filerobot.com/opendocs-global/v1/get/e7ce07de-f388-5555-aac3-30f301a50000" alt="Photo alt #responsive" width="375">

13. **Box shadow:**\
    Tick box to enable box shadow Untick box to unable box shadow

<img src="https://api.filerobot.com/opendocs-global/v1/get/f1b0917d-5859-532e-8722-074f31650000" alt="Photo alt #responsive" width="375">


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://doc.dataflake.co/drilldowns/filter-data-control.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.
