CRM On Demand - Reports and Dashboards (MOSC)

MOSC Banner

Dashboard Prompt Not Filtering Data by Year

edited Mar 4, 2013 8:57AM in CRM On Demand - Reports and Dashboards (MOSC) 2 commentsAnswered
In my report, I included a Created Date column.  I've formatted column to only show month, day, and year (exclude time).  In my report, I set filter to Created Date "is prompted."

So on the dashboard I created a prompt so users can control data they see by year:

EXTRACT (YEAR FROM Created Date) is equal to or is in  Multi-Select   All Values    Report Defaults

When I tested prompt,  it is not filtering data at all. It just shows all data from all years. 

Thanks. 

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center