Adding Future Date Options to a Date Filter

By default, Knowi's date filter picklist includes options like "Last 7 Days" or "Last Month." To add both past and future facing options such as "Next 30 Days" or "Next Quarter," you can populate the picklist with custom values from a dataset using the auto suggest feature.

Step 1: Create Your Custom Date Options File

Create a CSV file with two columns, date_value and date_label. The column names are flexible. You only need one column for the value and one for the label.

Use Knowi $c9_ date tokens to define the start and end of each range. https://docs.knowi.com/hc/en-us/articles/115006665927-Date-Operators#01J7243HJFQXAA9M0S4JAERA09

Future facing examples:

date_value	date_label

$c9_today - $c9_today+7d Next 7 Days

$c9_today - $c9_today+30d Next 30 Days

$c9_today - $c9_today+90d Next 90 Days

$c9_thisweek+7d - $c9_thisweek+13d Next Week

$c9_thismonth+1M - $c9_thismonth+2M-1d Next Month

$c9_thisquarter+3M - $c9_thisquarter+6M-1d Next Quarter

You can include past and present options in the same file alongside future ones.

Step 2: Upload the File as a Dataset

Go to Datasources and upload the file using the Upload File option. This creates a dataset that Knowi can reference.

Step 3: Connect the Dataset to Your Date Filter

After uploading the dataset, connect it to the filter.

Open the dashboard, click the Filters icon, then click the Edit icon on your date filter.
Set the condition type to Range and the filter control to Date Picker.
Toggle on Auto Suggestions from another Dataset and select the dataset you just uploaded.
Set Value to date_value and Label to date_label.
Click Save.

Below is an example CSV file. You can customize this file and include only the rows you want users to see.

date_value,date_label
$c9_today - $c9_today,Today
$c9_yesterday - $c9_yesterday,Yesterday
$c9_today+1d - $c9_today+1d,Tomorrow
$c9_thisweek - $c9_thisweek+6d,This Week
$c9_thismonth - $c9_thismonth+1M-1d,This Month
$c9_thisquarter - $c9_thisquarter+3M-1d,This Quarter
$c9_thisyear - $c9_thisyear+364d,This Year
$c9_today-7d - $c9_today,Last 7 Days
$c9_today-30d - $c9_today,Last 30 Days
$c9_today-90d - $c9_today,Last 90 Days
$c9_lastweek - $c9_thisweek-1d,Last Week
$c9_lastmonth - $c9_thismonth-1d,Last Month
$c9_thisquarter-3M - $c9_thisquarter-1d,Last Quarter
$c9_lastyear - $c9_thisyear-1d,Last Year
$c9_today - $c9_today+7d,Next 7 Days
$c9_today - $c9_today+30d,Next 30 Days
$c9_today - $c9_today+90d,Next 90 Days
$c9_thisweek+7d - $c9_thisweek+13d,Next Week
$c9_thismonth+1M - $c9_thismonth+2M-1d,Next Month
$c9_thisquarter+3M - $c9_thisquarter+6M-1d,Next Quarter

Your date filter picklist will now display your custom labels while passing the correct date token ranges into the underlying query.