2 Replies Latest reply: May 6, 2015 3:13 AM by Maarten Van Damme RSS

    Average of '0' results in dimension not being displayed

      Hi,

       

      Can somebody help me out?

      I want to view the average of 'total time' per 'month year' dimension.

      Now, this seems to work just fine, except when all the values for a dimension row are 0.

      In that case it looks like the dimension row is not displayed at all, while the outcome should be 'the average is of al the 0 rows is 0'.

       

      avg.png

      What is displayed is entirely correct, but I want to see the '2015-Mar' with value '0' row as well.

      In fact, in the end I want to see this in a graphical chart, but I tried to get the solution first with the tabular chart.

       

      An example attached.

       

      Regards,

      Maarten