Oracle Analytics Expression Filter Returns All Values In a Workbook When An Attribute Is Used
(Doc ID 2974440.1)
Last updated on OCTOBER 04, 2024
Applies to:
Oracle Analytics Cloud - Version N/A and laterInformation in this document applies to any platform.
Symptoms
Oracle Analytics Expression filter function returns all values in a workbook when an attribute is used
For example, below are dataset value, and need identify a distinct count when a fields outcome is Fail in the workbook,
below is new "My Calculations" defined.
FILTER((COUNT(DISTINCT ID)) USING OUTCOME = 'REJECT')
| ID | Date | Outcome |
| 1 | 3/1/2023 | Pass |
| 2 | 3/2/2023 | Pass |
| 3 | 3/3/2023 | Pass |
| 4 | 4/1/2023 | Pass |
| 5 | 4/2/2023 | Pass |
| 6 | 4/3/2023 | Pass |
| 7 | 5/1/2023 | Fail |
| 8 | 5/2/2023 | Pass |
| 9 | 5/3/2023 | Pass |
| 10 | 5/5/2023 | Pass |
| 11 | 5/5/2023 | Pass |
| 12 | 5/6/2023 | Pass |
| 13 | 5/7/2023 | Pass |
| 14 | 6/1/2023 | Fail |
but it returns the total account of all fields outcomes.
| Date(Month of Year) | Filter Fails |
| March | 3 |
| April | 3 |
| May | 7 |
| June | 1 |
Changes
May patch applied
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |