Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

1 Solution

Accepted Solutions
antoniotiman
Master III
Master III

Hi Maarten,

uncheck in tab Grafic

Img11.png

Regards,

Antonio

View solution in original post

2 Replies
antoniotiman
Master III
Master III

Hi Maarten,

uncheck in tab Grafic

Img11.png

Regards,

Antonio

Not applicable
Author

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

Have a nice day!