14 Replies Latest reply on Jul 21, 2017 4:55 PM by Zhouyi Zhang

    Not Show July Actual,Aug,Sept

    Sissi Du

      Hi,

       

      I am really new to tableau. I have a product  A which has a historical actual data from 2016/10/3-2017/7/19 and a full year 2017 daily forecast data. However, when I make the table below, the future July (date after 7/19/2017), Aug and Sept are not showing below. Could anyone help me what might go wrong? and what could be the reason causing it?

       

      The actual problem is that both FORECAST and ACTUAL are a SQL pull. (Attached file is an excel for illustration). It is hard to swap data source. Is there any ways to solve this problem by creating a calculated field?

       

      Thanks!!!