Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 53 Oracle Analytics and AI Sharing Center
- 25 Oracle Analytics and AI Lounge
- 306 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
Filtering data in Workforce Management – Documents of Record Real Time
I am joining the “Workforce Management – Worker Assignment Real Time” and “Workforce “Management – Documents of Record Real Time” Subject Areas, if I add a filter to identify Workers that do not have any records in “Documents of Record” (either filtering on “Document Count = 0” or “Document Type is null”) it returns no data, even though there are some Workers that do not have any Documents of Record.
Is this expected behaviour, is there a way of filtering on this?
Best Answer
-
Hi @C Hammond,
I've changed document count definition and it is now returning results for me with filter document count = 0.
Can you please check the following XML to see if it is working for you?
Hope this help.
Thank you.
2
Answers
-
Thank you @Bhaskar Konar - that has worked.
1 -
Hi @C Hammond,
Please find below the changes that I did on top of your report.
Replaced: "Workforce Management - Documents of Record Real Time"."Document of Record"."Document Count" With: IFNULL("Workforce Management - Documents of Record Real Time"."Document of Record"."Document Count", 0) And then added the filter on the new measure.
Thank you.
1