InetSoft Documentation: Dashboard Date Range

Users can filter large data sets by date range using InetSoft's award-winning dashboard software - a comprehensive real-time analytical reporting solution that has been used across several industries worldwide.

View the example below to learn more about the Style Intelligence solution.

You can define two different kinds of date range, described in the following sections:

  • A sliding date range is an interval of dates defined relative to the current date, for example, “this week,” “last month,” or “last November.” The actual calendar dates included in the range are automatically computed at runtime.
  • A fixed date range is a range of dates defined by fixed beginning and end dates.

Date ranges are used together with the 'in range' filtering condition, which is available only for Date fields. Worksheets also provide a wide range of built-in date ranges.

#1 Ranking: Read how InetSoft was rated #1 for user adoption in G2's user survey-based index Read More

To create a custom date range, follow the steps below:

  1. Click the 'New Object' button in the toolbar, and select 'Date Range'. This opens the 'Date Range' dialog.
  2. Enter a name for the date range.
  3. Select the 'Sliding Range' button at the top of the dialog box.
  4. Select an item from the 'Available Date Ranges' list, and click 'Add' to add the range to the 'Selected Date Ranges' list.
  5. Repeat the previous step to add additional date ranges as desired. The final custom date range is the union of the added date ranges.
  6. Click 'OK' to close the dialog box.

To create a custom period, follow the steps below:

  1. Click the 'New Object' button in the top toolbar, and select 'Date Range'. This opens the 'Date Range' dialog box.
  2. Enter a name for the date range.
  3. Select the 'Fixed Range' radio button at the top of the dialog box.
  4. In the 'Conditions' panel, select the start and end dates of the desired period.
  5. Click 'OK' to close the dialog box.
why select InetSoft
“Flexible product with great training and support. The product has been very useful for quickly creating dashboards and data views. Support and training has always been available to us and quick to respond.
- George R, Information Technology Specialist at Sonepar USA

Previous: Dashboard Data Grouping