8 Replies Latest reply on Dec 9, 2015 12:40 AM by max dl

    How to add a calculation that takes into consideration "show missing values"?

      On a simple bar graph my x-axis is a date dimension, but there isn't data for every date.   I'm using the "show missing values" option to show all the dates.    I'd like an average calculation of my measure in the y-axis, but it only averages for the values on dates I have data for.  I'd like to treat those "missing values" as zeros for the purpose of this calculation.     The purpose of this is to just draw an average reference line.   Thanks!