Data Source Filter

1. What is a Data Source Filter?

A Data Source Filter in Sintel BI allows you to apply filters directly at the data source level. This ensures that only the required data is loaded into the dashboard, improving performance and data security.

This filtering method is recommended for:

• Large datasets, as it reduces the volume of queried data.
• Sensitive data, as it ensures that users only see relevant information before it reaches the dashboard.

2. How to Add and Configure a Data Source Filter

Example: Date Filter

In this scenario, I have a dataset that includes the price of McDonald’s Big Macs around the world and the date when the price was last changed. I only want to display data for countries where prices were updated after 2021.

1. Navigate to the Data Source.
2. Click on the three dots ‘…’ and select ‘Edit’.
3. Select the Filter button.
4. Choose Date as the filter field.
5. Set the condition to ‘After’.
6. Select Specific Date (e.g., 31st January 2021).
7. Click Apply.

🎥 To see this in action, watch the video below.

Example: User Filter

In this scenario, I have a dataset containing travel expenses. I want a dashboard where users only see their own travel requests.

1. Navigate to the Data Source.
2. Click on the three dots ‘…’ and select ‘Edit’.
3. Select the Filter button.
4. Choose Requester as the filter field.
5. In the second box, type @me.
6. Click Apply, then Save & Exit.

Now, when a user logs in, they will only see their submitted requests.

🎥 To see this in action, check out the video below.

After configuring your Data Source Filter, ensure you save your work so that changes take effect.

Learn More

If you found this guide helpful and want to explore other components, click here.

• Discover more about Sintel BI features or testimonials.
• Interested in Sintel Forms or Sintel BI?  book a no-obligation demo.
• Stay updated by following us on LinkedIn/Twitter & YouTube.