Hi @Pragati_17, You can set a default date for your date range picker filter in Databricks Lakeview Dashboards.
Hereโs how:
1. Create a Lakeview Dashboard:
- Click New in the sidebar and select Lakeview Dashboard.
- Your new dashboard is automatically named with its creation timestamp and stored in your /Workspace/Users/<username> directory. You can also create a new Lakeview dashboard from the Dashboards listing page or the Add button in the Workspace menu.
2. Define Datasets:
- Use the Canvas tab to create and edit widgets like visualizations, text boxes, and filters.
- Use the Data tab to define the datasets used in your dashboard. You can write SQL queries or select a Unity Catalog table or view.
- For example, you can define a dataset called โTaxicab dataโ using a query that accesses publicly available taxicab data from New York City in 2016.
3. Create and Place a Visualization:
- Click the Canvas tab and create a visualization widget, then place it in the canvas.
4. Configure Your Visualization:
- From the Filter dropdown menu in the configuration panel, select Date range picker.
- Select the Title checkbox to create a title field on your filter.
- Click on the placeholder title and type โDate rangeโ to rename your filter.
- From the Filter on the menu, select Taxicab_data.tpep_pickup_datetime1.
Now, when you open your Lakeview Dashboard, the date range picker filter will have the default title โDate rangeโ and will be preconfigured to filter based on the specified dataset. You can adjust the default date range as needed! ๐
๐