Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 54 Oracle Analytics and AI Sharing Center
- 26 Oracle Analytics and AI Lounge
- 311 Oracle Analytics and AI News
- 57 Oracle Analytics and AI Videos
- 16.4K Oracle Analytics and AI Forums
- 6.7K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 117 Oracle Analytics and AI Trainings
- 24 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
How to code two fields with dates at the same time?
User_LGSZT
Rank 1 - Community Starter
Currently in my query that I have set up I have two date data points that I want to use separate but at the same time. One for MTD (Month to Date) and the other is YTD (Year to date). Each date needs to be in it's own separate column.
The field original formula is "OE_Lines"."SHIPPED_QUANTITY" (but I want to code this in a way that I can also pull the Date measurement with it for each date.) How would this be possible?
I can specify the date by using a filter. However since this is just a filter, it sets this for both fields in the query instead of each date measurement. Example this allows me to see last month:
"OE_Lines"."SHIPPING_DATE" >= EVALUATE('prior_month_begin_date') and "OE_Lines"."SHIPPING_DATE"< = EVALUATE('prior_month_end_date)
0