This document explains how to filter data on a dashboard using custom date filters such as: the current week, month or year, the last 7 days. We will leverage the filter tables (link) and show how to link them to a dashboard.
STEP-BY-STEP GUIDE
- Copy the two tables containing the date filters (please follow the procedure described in this document). The FilterTable contains the different filters with the corresponding start and end date.
...
Date >= StartDateTime and Date <=EndDateTime
Create a dashboard linked to this worksheet
- Create a dashboard linked with the data worksheet you have just created
- Create a combo box to allow the user to select a custom filter
- Select Query as List Values. Select the FilterTable table, set the label with the column term and value with the column type
- In the Data tab set the target property to the variable filter type, this will allow to update the parameter value every time the user changes the selection and so update the queried table
- Create some charts based on the filtered table and you should see that data changes accordingly to the filter selection.