Managing Date and Time Fields
  • 09 Jun 2022
  • 1 Minute to read
  • Contributors
  • Dark
    Light
  • PDF

Managing Date and Time Fields

  • Dark
    Light
  • PDF

Many widgets include data that is relative to date and time fields. Sisense enables you to apply date and time filters so you can easily identify trends in your data.

When you create a widget in your dashboard that includes a date field, Sisense automatically breaks the data down by year, however, you can change this to a shorter resolution. For example, a Date field included in a widget can be separated into Years, Quarters, Months, Weeks, and Days, Hours, or 15 Minutes from your widget’s filter.

8-6tdateandtime1thumb0300.png

Time-Level Support

When the Analytical Engine is used for live models on Redshift, Snowflake, or BigQuery, time-level support for widgets can be activated to offer an extended time-level hierarchy of time slicing of the data. 

This will enable the following continuous options for time-related filters:

  • Years
  • Quarters
  • Months
  • Weeks
  • Days
  • Date & Time (including Hour, and 15 Minutes)

and the following aggregated options (which ignores dates) for time-related filters:

  • Time of day

To activate time-level support:

  1.  Navigate to Admin > System Management > Configuration > click the Sisense logo five times > Base Configuration > Filters.
  2.  Activate the Time level support parameter.

Drilling Down

Dashboard Viewers have the option to drill down the widget according to the Date level as shown in the following image:

8-6v7time3thumb0300.png

Viewers can drill down into the lowest date or time resolution available in your data. The highest resolution available is by Year and the lowest resolution is Time, which includes Day intervals.

8-6v7time2thumb0300.png

For more information about filters, see Creating Dashboard Filters and Drilling Down in a Widget.


Was this article helpful?