Average of '0' results in dimension not being displayed

Wed, 06 May 2015 07:01:26 GMT

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

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

Re: Average of '0' results in dimension not being displayed

antoniotiman — Wed, 06 May 2015 07:10:46 GMT

Hi Maarten,

uncheck in tab Grafic

Regards,

Antonio

Wed, 06 May 2015 07:13:59 GMT

Thanks a lot Antonio! That seems to do the job just fine!!

Have a nice day!