Filter Dashboard Visualization by a Date Parameter

The following tutorial describes filtering a dashboard visualization by a date parameter.

This tutorial has been created using the Technology Dataset which can be downloaded here and uploaded to your Wyn instance.

TechnologyDataset.cdst

1. Create Column Chart

   Drag a column chart onto the canvas.

   
   

2. Bind Data

   Add the dataset in the data binding tab and set the Value axis to TicketsRaised and the Category axis to TicketRaisedDate.Month. Set the aggregation method of TicketsRaised to Count.

   
   

   
   

   
   

3. Create a Parameter

   Click Document Settings in the toolbar or click anywhere on the canvas to show the Dashboard properties in the Inspector Panel. In the Inspector Panel, click the + next to the Parameters property under the General property group to add a parameter.

   
   

4. Configure the Parameter

   In the parameters window, set the Data Type to Integer and set its value to 10 (for October). In the Binding Tab, set the Source Type to Selected Value and bind to TicketRaisedDate(Month)

   
   

   
   

   
   

   
   

   
   

5. Filter By Parameter

   Select the chart and locate the Filter button in the scenario's action toolbar. Under the General tab, click the edit button next to the search box and select Parameter1 from the dropdown.

   
   

   
   

   
   

6. Preview Dashboard

   The chart is filtered for the parameter set to October.