Date Filter ​

The Date Filter allows users to filter data for a specific range of days using an intuitive calendar interface. This filter type is ideal for selecting date ranges without needing the animation and timeline visualization capabilities of the Time Slider.

For example, a restaurant chain could use the date filter to show sales only from the last month, or an e-commerce business could filter orders to compare performance between specific date ranges.

Overview ​

The date filter provides:

• A calendar-based user interface for selecting date ranges
• Quick preset options for common date ranges
• Simple filtering for date-type fields in your data

Configuration Options ​

Data Settings ​

Date Field ​

Select the date field from your data source that you want to filter by. This field must be one of Snowflake's Date & Time data types.

Title & Description ​

Add optional text to help users understand what they're filtering:

• Title: A short label for the filter (e.g., "Order Date Range")
• Description: Additional context or instructions

Selecting Date Ranges ​

The date filter supports two methods for selecting date ranges:

Calendar Selection ​

Click on the calendar interface to select specific start and end dates. You can:

• Click a start date, then click an end date to create a range
• Navigate between months using the arrow controls
• See the selected range highlighted on the calendar

Date Presets ​

For convenience, the date filter includes quick preset options:

• Today: Filter for today's date only
• Yesterday: Filter for yesterday's date
• This Month: Filter for the current month
• Last Month: Filter for the previous month
• This Year: Filter for the current year
• Last Year: Filter for the previous year

These presets automatically update based on the current date, making them useful for dashboards that should always show recent data.

Apply to Layers and Components ​

Select which map layers and data components should be filtered by the date filter:

• Any map layer using the same data source
• Data components (Big Numbers, Bar Charts, Histograms) using the same data source

This allows you to create focused date filters that only affect relevant visualizations on your map.

Saving Date Filter Settings ​

When you save a map with a date filter:

• The filter configuration (field, affected layers) is saved
• The current date range selection is preserved
• Users who load the map will see the same filtered date range
• Users can modify the date selection even in read-only mode

Date Filter vs. Time Slider ​

Choosing between the Date Filter and Time Slider depends on your use case:

Use Date Filter when:

• You want a simple, straightforward date range selector
• You don't need animation capabilities
• You're filtering by dates (not timestamps with times)
• Preset options like "Last Month" or "This Year" would be useful

Use Time Slider when:

• You need to visualize trends over time with a background chart
• Animation is important for showing temporal changes
• You're working with timestamp data (including times, not just dates)
• You want to show the continuous flow of time

Use Cases ​

Here are some examples of how the date filter can be used:

• Sales Analysis: Filter orders to compare specific months or quarters
• Event Management: Show events scheduled within a particular date range
• Service History: Display service appointments from the last 30 days
• Inventory Tracking: View inventory changes during a specific period
• Marketing Campaigns: Analyze campaign performance for a selected time frame

Best Practices ​

• Use clear, descriptive titles that explain what date is being filtered
• Consider using preset options for dashboards that should always show recent data
• Combine with other filters to create precise queries (e.g., "orders from last month for a specific product category")
• Remember that date filters affect all selected layers and components