OBIEE 12c: In a Stacked Graph, When the Last Value of a Column in Color Section Has No Corresponding Measure Value, Total May Not Be Displayed (Doc ID 2563542.1)

Last updated on DECEMBER 11, 2020

Applies to:

Symptoms

Data Visualization

In a Stacked Graph, Total value may not be displayed in the certain bar chart.

• Horizontal Stacked Bar Graph 
• When the last value of a column in color section has no corresponding measure Value

This symptom can be reproduced with 12.2.1.4 Data Visualization with "Sample Sales Lite."

1. Log in to DV (http://hostname:9502/dv).

2. Click "Create > Project" to create a new project.

3. Select Sample Sales Lite as the data set.

4. Select the following columns and use Horizontal Stacked:

Horizontal Stacked
Values (X-Axis): Actual Unit Price
Category (Y-Axis): Product Type
Color: Department

5. Turn on the Data Values, you'll see the total values, but not all bars have the total values. In this example, Product Type, e.g. "Install", "LDC", "Maintenance", and "Plasma".

Cause

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