1 Reply Latest reply on Nov 28, 2018 8:31 PM by Shinichiro Murakami

    Display last months of the year in bar chart with no data

    Ignacio Aguirre

      Hi there,

       

      I want to display a bar chart that show when projects were paid for all the months in the year even though I may be in the middle of the year and therefore I won't have data for the last months. Still, I want to show all months in the header. In this example, my data is until November. I also have data points with no dates (that means they haven't been paid yet)

       

      I created a calculation as follows and set the table layout to show empty columns. Still, December doesn't show up in the graph. Any suggestions?

       

      I left an excel doc with the necessary data.

       

      Thanks!

      Ignacio