My Oracle Support Banner

Oracle Analytics Filtering Not Working In Workbook (Doc ID 2974440.1)

Last updated on NOVEMBER 03, 2023

Applies to:

Oracle Analytics Cloud - Version N/A and later
Information in this document applies to any platform.

Symptoms

Filtering function not working as expected in the workbook.

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')

Dataset Value
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.

Wrong Result
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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.