How to Filter Data for Yesterday with a Relative Time Filter in Oracle Analytics (Doc ID 2863662.1)

Last updated on NOVEMBER 03, 2023

Applies to:

Goal

In a DV Workbook (Project), a Relative Time filter can be created on a DATE column to enable the user to display data / return results for a specified time period based upon the current date. For reference, see: Apply Relative Time Filters

When the Relative Time filter is set with Type = Last, Increment = 2, Time Level = Day, Relative To = Today ... the results are filtered for yesterday and today's dates.

When the Relative Time filter is set with Type = Last, Increment = 1, Time Level = Day, Relative To = Today ... the results are filtered for today's date only.

How can the Relative Time filter be used to display data / return results for yesterday's date only?

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.