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 |