6 Replies Latest reply on Nov 15, 2016 2:01 PM by Sherzodbek Ibragimov

    Showing sums of zero on line graphs

    Howard Shen

      Question: How can I make aggregations that total to zero show up on a line graph?

       

      In the attached workbook, I'm trying to total how many of each type of grade exist throughout the year.  No one has an A prior to October 16.  How can I make Tableau extend the A line from the beginning of the graph until October 16 with a value of zero from the beginning of the year until Octoter 16th?

       

      All my searching is turning up questions of what to do when there is no data for a particular date, and it doesn't seem like ZN is the solution to my problem (or I'm using ZN at the wrong step).

       

      Thanks!