Custom Fiscal Year filter setup in DataBrain

This guide provides a straightforward method for setting up an Indian Fiscal Year filter in DataBrain, allowing users to analyze data more effectively according to the Indian financial calendar.

1. Configure the Date filter

• Navigate to the dashboard where you want to set up the Fiscal Year filter.

• Then, add a Date filter and select preset options: Last Year and This Year.

• In the "Apply On" section, choose the date column, then click "Save" to apply the filter to your dashboard.

1. View the changes in Dashboard

By default, the "Last Year" filter displays data from January 1, 2024 to December 31, 2024, and the "This Year" filter shows data from January 1, 2025 to December 31, 2025.

1. Enable Indian Fiscal Year

To enable the Indian Fiscal Year, add the following option to the embed settings:

calendar-type='ind'

Refer to the documentation for more details:

✅Options

1. View the changes in dashboard

After enabling the Indian Fiscal Year filter, the date ranges adjust as follows:

• "Last Year" now displays data from April 1, 2023 to March 31, 2024.

• "This Year" now displays data from April 1, 2024 to March 31, 2025.

Yearly and quarterly time-series charts will automatically follow the Indian Fiscal Year (April to March)