Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 54 Oracle Analytics and AI Sharing Center
- 25 Oracle Analytics and AI Lounge
- 308 Oracle Analytics and AI News
- 57 Oracle Analytics and AI Videos
- 16.4K Oracle Analytics and AI Forums
- 6.6K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 118 Oracle Analytics and AI Trainings
- 22 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Calculated column with interval between start and end dates selected in prompt
Summary:
When i select the start and end dates in a prompt, i want to have a calculated column that shows the interval between the start and end dates, i want to use this calculated interval for another calculation. Any idea, how i can have this?
Content (required):
Version (include the version you are using, if applicable):
Code Snippet (add any code snippets that support your topic, if applicable):
Answers
-
Hi @Mohamed Hasan ,
You can try prompting the Start and End dates separately in your prompt. You can then create two presentation variables to receive each date.
Receiving those dates through Presentation variables will allow you to pass them to a report and get the Date Diff between them. Here is the column formula:
TIMESTAMPDIFF(SQL_TSI_DAY, @{pvStartDate}{CURRENT_DATE}, @{pvEndDate}{CURRENT_DATE})
Hope this help.
Cheers,
0
