1 Reply Latest reply on Mar 9, 2018 5:49 AM by Jim Dehner

    Missing dates as value 0

    jordina orcajo

      I want to build a line graph, and I have missing dates in my data. I would like to get value 0 for the missing dates.

      With the option 'Show Missing values', all dates are showed in the graph. But the missing dates does not have any value but they appear and the line pass over them. Values for missing dates are not real NULL. And therefore, I think I can not use functions like IFNULL or ZN to transform NULL value to 0, because it is not a real NULL. Do you know how to solve the problem?

      Thank you!

        • 1. Re: Missing dates as value 0
          Jim Dehner

          Good morning

           

          You can use this            ifNull(lookup(sum([Sales]),0),0)

           

          and it will return this

           

           

          Jim

           

          If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution.  Thank you.