Oracle Communities

Oracle Analytics and AI

Child Item

We need a way to default date filters to the current day/month/Year while opening date range filter

We need functionality that allows date filters to automatically default to the current day/ month/ year. This will help streamline reporting, reduce manual input, and ensure users always see the most relevant data by default.

Currently , if DB has 10+ years data, filter will sit in 2009( if this is starting year) while opening the filter in date range. If I restrict data with a unknown filter(year greater than 2016) , user can not find old data

Find more posts tagged with

Analytics

Analysis and Data Visualization

Filters

Needs Votes

Date

Status: Needs Votes

Comments

Michal Zima

@Ancy Paul-Oracle Why don't you simply bind date/datetime column (which you want to default to current date) in dashboard filter with system defined parameters Current Date/Current DateTime ( https://docs.oracle.com/en/middleware/bi/analytics-server/user-oas/system-parameters.html ) - those parameters are having values, you need for you filtering. And this (I hope) can be done by not very experienced author (no logical SQL knowledge needed).

Michal

Pablo Moreno

Hello,

I have defined a date filter with parameters with from current_date-7 to current_Date:

I expect this values will be displayed for all users but there is only visible for my user. The other users by default see the full range.

This is a bug? We need to be able to define default values.

Thanks and regards.