Managing Date and Time Fields
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.
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:
- 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:
- Navigate to Admin > System Management > Configuration > click the Sisense logo five times > Base Configuration > Filters.
- Activate the Time level support parameter.
Dashboard Viewers have the option to drill down the widget according to the Date level as shown in the following image:
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.