Home page and System dashboards

Data visualisation - Filtering data based on dates

As of our July 2024 release, we have introduced the ability to visualise important insights powered by date columns. This will enable users to stay ahead of emerging trends with instant data visualisations powered by up-to-the-second date columns that deliver real-time accuracy.
Once a date column is selected, the user will be able to choose from:
  • Between two specified days
  • Today
  • Exactly on a specified date
  • An exact time span before or after a specified date
  • Any date before or after a specified date
  • Within the last/next number of days/weeks
Within your site (in this example we are using a matter site), click
Edit
 to edit your dashboard:
And click
New panel
. Scroll down and click
Select
 next to
Advanced date filter:
The
Select - Advanced date filter
 screen is displayed:
Here you can select which piece of data you would like your filter to be between or by:
The options available are:
  • Between
     - This is between two selected dates
  • Today
     - This will be todays date
  • Exactly
    on
     - This is an exact date for the filter
  • Exactly
     - This allows you to specify an exact amount of days or time span before or after a certain date
  • Any
    date
     - This will return results for any dates
  • With
    in
     - This allows you select within the next or last chosen amount of days
Click
Save
 to save your changes.
As long as you have relevant data within your site, a new chart will be displayed. For example:

This article applies to:

  • Product: HighQ
  • Subject: Dashboards