Zoomdata Version

Working With Time and Filters

You can add time attributes when you create a new filter and control the filter from the time bar. This allows you to narrow the scope of the data by time. You can also set a filter directly in the time bar.

Filters applied in the Filters menu override any filters you set in the time bar.

The filters you create and the actions you set with the time bar influence the visualized data on your chart. Depending on the settings and how they interact, it is possible that the combined result returns no data. This is because the time filters that you set and the filters in the time bar are mutually exclusive. As a result, there is no data to display, so the intersection of the two time filters provides no result.

When you select a Time attribute, you can set the time range that you want displayed on a chart.

To set a time range for a filter:

  1. In the Filters menu, select an attribute from Time.
  2. In the Filter by Range section, specify a date and time in the From and To fields.

With From and To dates you can:

  1. Select the time from the calendar.

  2. Set a dynamic time.


    • Use the calendar to set the day, month, or year as a start or end date.

    • If you set a month (or year) as a start date, your chart data displays starting from 12:00:00.000 a.m. of the first day of the selected month (or year).

    • If you set a month (or year) as an end date, your chart data displays through 11:59:59.999 p.m. of the last day of the selected month (or year).

    • To use a predefined time period, expand the Time Presets section and select the required time period.

For available time presets, see the table below:

Preset type Start date End date
CURRENT
Max Available Range Min time value in the data set known to Zoomdata Max time value in the data set known to Zoomdata
Current Year First day of the current year (01/01/2015 12:00:00 AM) Last day of the current year (12/31/2015 11:59:59 PM)
Current Year-to-Date First day of the current year (01/01/2015 12:00:00 AM) Current date and time
Current Quarter First day of the current quarter (07/01/2015 12:00:00 AM) Last day of the current quarter (09/30/2015 11:59:59 PM)
Current Quarter-to-Date First day of the current quarter (07/01/2015 12:00:00 AM) Current date and time
Current Month First day of the current month (08/01/2015 12:00:00 AM) Last day of the current month (08/31/2015 11:59:59 PM)
Current Month-to-Date First day of the current month (08/01/2015 12:00:00 AM) Current date and time
Current Week Sunday of the week with current day (Sun, 08/16/2015 12:00:00 AM) Saturday of the week with current day (08/22/2015 11:59:59 PM)
Current Week-to-Date Sunday of the week with current day (Sun, 08/16/2015 12:00:00 AM) Current date and time
Today Start of the current day (08/20/2015 12:00:00 AM) Current date and time
Current Hour Beginning of the current hour Current time
ROLLING
Rolling 365 days 365 days before current date/time (08/202014 1:00:00 PM) Current date and time
Rolling 90 days 90 days before current date/time (05/22/2015 1:00:00 PM) Current date and time
Rolling 30 days 30 days before current date/time (07/21/2015 1:00:00 PM) Current date and time
Rolling 7 days 7 days before current date/time (08/13/2015 1:00:00 PM) Current date and time
Rolling 24 hours 24 hours before current date/time (08/19/2015 1:00:00 PM) Current date and time
Rolling hour 60 minutes before current date/time (08/20/2015 12:00:00 PM) Current date and time (08/20/2015 1:00:00 PM)
HISTORIC
Previous Year First day of the previous year (01/01/2014 12:00:00 AM) Last day of the previous year (12/31/2014 11:59:59 PM)
Previous Year-to-Date First day of the previous year (01/01/2014 12:00:00 AM) Same date and time last year (08/20/2014 1:00 PM)
Previous Quarter First day of the previous quarter (04/01/2015 12:00:00 AM) Last day of the previous quarter (06/30/2015 11:59:59 PM)
Previous Quarter-to-Date First day of the previous quarter (04/01/2015 12:00:00 AM) Same date and time last quarter (07/20/2015 1:00:00 PM) or last day of corresponding month last quarter
(if, for example, today is 07/20/2015 1:00:00 PM, the end date will be 06/30/2015 11:59:59 PM)
Previous Month First day of the previous month (07/01/2015 12:00:00 AM) Last day of the previous month (07/31/2015 11:59:59 PM)
Previous Month-to-Date First day of the previous month (07/01/2015 12:00:00 AM) Same date and time last month (07/20/2015 1:00:00 PM) or last day of previous month
( if, for example, today is 07/31/2015 1:00:00 PM, the end date will be 06/30/2015 11:59:59 PM )
Previous Week Sunday of the previous week (08/09/2015 12:00:00 AM) Saturday of previous the week (08/15/2015 11:59:59 PM)
Previous Week-to-Date Sunday of the previous week (08/09/2015 12:00:00 AM) 7 days before current day (08/132015 1:00:00 PM)
Yesterday Beginning of the previous day (08/19/2015 12:00:00 AM) End of the previous day (08/19/2015 11:59:59 PM)
Previous Hour Beginning of the previous hour (Aug 20 2015 12:00:00 PM) End of the previous hour (Aug 20 2015 12:59:59 PM)

Was this topic helpful?