Categories
- All Categories
- 104 Oracle Analytics News
- 9 Oracle Analytics Videos
- 14.3K Oracle Analytics Forums
- 5.3K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 58 Oracle Analytics Trainings
- 60 Oracle Analytics Data Visualizations Gallery
- 5 Oracle Analytics Data Visualizations Challenge
- 4 Oracle Analytics Career
- 4 Oracle Analytics Industry
- Find Partners
- For Partners
Report to display data based on dates comparison.

Hi All,
I have requirement to display data based on dates comparison.
I have two dates supply date and ship date in my report. I have a dashboard prompt (variable prompt - PV_Supply) Supply which consists of value 'Yes'.
If user selects 'Yes' then my report should display data based on the condition (supply date < ship date)
How to filter report based on this condition?
regards,
ram.
Answers
-
You can convert Filter to SQL and try something like this ...
@{PV_Supply} ='Yes' and supply date < ship date
or @{PV_Supply} ='No' and supply date > ship date
0 -
Hi All,
For the column "Supply Date" i have added filter and converted to SQL, written the formula like this
"Supply Date" < "Ship Date" and '@{PV_Supply}{Yes}'='Yes'
but without selecting dashboard prompt value to 'Yes', the report is filtering data ("Supply Date" < "Ship Date").
Please correct me.
regards, ram.
0 -
You can set default value to 'Something Else' or can change it like ...
"Supply Date" < "Ship Date" and '@{PV_Supply}{SometingElse }'='Yes'
You can also update default value of the dashboard prompt
0 -
Hi all,
The requirement is like this: Initially my report should display all the records.
My dashboard prompt is have only Yes value as shown below.
As when user selects 'yes' then my report should filter based on the condition (Supply date < Ship date).
My report should display records Supply date < ship date.
For this i have created a variable prompt (PV_Supply) with value 'Yes'.
The above written formula fails and it does not display any data, Please advice suitable answer.
Regards,
ram.
0 -
Try this ..
'@{PV_Supply}{SometingElse}'='SometingElse'
or "Supply Date" < "Ship Date" and '@{PV_Supply}{SometingElse}'='Yes'
0