1 Reply Latest reply on Sep 14, 2016 12:51 AM by Mahfooj Khan

    Qq yyyy not working as date

    Simon Kuestenmacher

      Hi folks,

       

      I am totally lost on this one (even after reading forum posts on date formats for over an hour now). I have a very straight forward set of data with a column for Quarter, a column for Year and another column for Quarter and Year. Whatever I tried I can't get Tableau to plot a decent date axis. I am afraid I will need a fool proof explanation on this one as I am really lost beyond hope...

       

      The attached dashboard plots the date as a string but I want to plot a trendline which I apparently can only do once Tableau accepts my data as date.

      Is there an ideal way to write the date (when I only have quarter and year) in excel so Tableau picks it up easily?

       

      Any help with this will be most highly appreciated!

       

      Cheers,

       

      Simon K