3 Replies Latest reply: Dec 30, 2011 7:11 PM by Deepak Vadithala RSS

    Rain average by month over a period of years, when there is no data in a month?

    Ignacio Larrechea

      I need to make a chart with the rain average by month, for a period of years. The only Dimension is Month and the average should be for the period of years including those that didn't rain.

      I can not use the avg function, because on several years no rain has fallen. Which functions should I use ??

      Thank you !!