1 Reply Latest reply on Jan 31, 2019 9:44 AM by Deepak Rai

    Create Trendline if dates are as column heads

    Varun Garg

      Hi All,

       

      I have some data which shows sales for each account throughout the year. I want to create a trendline to be able to project how much sales will I get in the next 6 months on the basis of the past data.

      However, I am unable to do it in Tableau as everytime I try to create a trendline it says atleast one axis should be a date. I am attaching the screenshot of the data for the reference here.

       

       

      The column heads have the months and then each row represents sales for each account across different months. Can I create the trendline chart for this data in Tableau.

       

      Thanks for all the help in advance!