Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
10 years ago

Stacked area chart

Hi,   I want to use a stacked area chart with dates on the X-axes, but the rendering is off with crossing lines and gaps. I guess it is caused by missing null or zero values for each categroy at a ...
fbrossard's avatar
fbrossard
Kudo Commander
10 years ago

It's not a bug.

In all cubes technologies Null values are eliminated to optimize the number of cell-set return by a query.

In most cases, null values doesn't have anay sense for analytics.

But you have to view the missing point, you have to replace null by 0. This can be done directly from your query by replacing null by 0 (not recommended depending on high number of rows) or by using a calculated measure

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    10 years ago

    Ok, too bad...

     

    My problem is, I have no data points for certain dates in certain categories(not even null values). How can I create these missing datapoints?

     

    cat A - 1/1/2016 - 10

    cat A - 2/1/2016 - 12

     

    cat A - 3/1/2016 - 14

     

    cat A - 4/1/2016 - 16

    cat B - 1/1/2016 - 14

    cat B - 4/1/2016 - 12

     

    In the example above I'm missing records for

    cat B - 2/1/2016 - 0

     

    cat B - 3/1/2016 - 0

     

    Thanks!

    • Anonymous's avatar
      Anonymous
      Not applicable
      10 years ago

      I am experiencing the exact same issue, as it seems.

       

       

      Any news on this matter?

       

      Were you able to sort it?