3 Replies Latest reply on Mar 9, 2019 10:50 PM by Mahfooj Khan

    Problem with line chart having missing segments

    Brent Evans

      Hi All,

      I'm trying to create a dual axis line chart in which I've combined several different hunting seasons. Some of the seasons have NULL values in the original data. I tried using the ZN function to turn the NULL values into zeros. This did work in the table. Unfortunately, I still have broken lines. This is especially true with dates earlier than 2001 for combined Canada goose harvest (see last worksheet). I created several calculated fields.


      I believe my error may be in using the ZN function? I tried to follow the guidelines found here: https://community.tableau.com/docs/DOC-1344


      Please take a look at the attached workbook and point out my error.