Oracle Communities

Oracle Analytics and AI

Child Item

When we add multiple measures, chart should not display if there is no values.

We should have option not show the line for null values.

In Line diagram it is showing all values for all measures even though we don't have values for it. In the attached example, after week 20 , there is no value for green lines. But it is showing continuous line.

In overlay diagram it is showing zero. No option to not to show as Gap.

Find more posts tagged with

Needs Votes

Status: Needs Votes

Comments

Gabby Rubin-Oracle

Have you tried this option? but I think your request is not for Gap, you are asking that it use the same value as the previous value in case there is a Null. It is different from Gap and should be solved in the definition of the measure/calculations.

Rajakumar Burra

Yes , My issue is using same value even though it is Null.

If I plot two different line DVs, it looks below.

But If I add same measures in one DV, It is not ignoring nulls.

Can you suggest how it can be solved in Calculation/Measure definition?

Jorge Olmeda

Hi,

Same happened to me as well. It would be good to have a solution.

Best regards,

Jorge

Gabby Rubin-Oracle

@Rajakumar Burra can you share an example dataset? I was not able to create the same outcome.

Rajakumar Burra

@Jorge Olmeda Do you have any quick example. I am unable to reproduce now.