BI Publisher (MOSC)

MOSC Banner

How do I account for Missing Values in a Chart in RTF

edited Oct 3, 2017 4:06PM in BI Publisher (MOSC) 4 commentsAnswered ✓

I have a set of data showing project status.  There are 4 possible values for the status (Completed, Major Delay, Minor Delay, On Track).  In any given run of the report all, some or none of the status's might be applicable.  How can I do the following in a chart:

1) Color the status consistently.  (Generally you assign colors to a series, but it there isn't a value in a series then the order can shift)  I.e  Completed - Blue, Major Delay - Red, Minor Delay - Yellow, On-Track - Green

2) Show in the chart legend all of the values.

What makes this difficult is I am not guaranteed to have all of the status values in a particular report run.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center