Oracle Analytics Cloud and Server Idea Lab

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

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

Needs Votes
1
Views
5
Comments

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.



2
2 votes

Needs Votes · Last Updated

Welcome!

It looks like you're new here. Sign in or register to get started.

Comments

  • 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.


  • Rank 6 - Analytics Lead

    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?



  • Rank 5 - Community Champion

    Hi,

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

    Best regards,

    Jorge

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

  • Rank 6 - Analytics Lead

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

Welcome!

It looks like you're new here. Sign in or register to get started.