7 Replies Latest reply on Aug 22, 2018 1:18 PM by Andrew Lloyd

    How do I create continuous line charts using integer months and integer years from separate columns?

    Andrew Lloyd

      I asked this question a while back and never got an adequate answer. In my organization, we have funky fiscal periods, so all reporting is done using integer values for fiscal week, month, quarter, year, etc. Excel has no issue with this:

      u2cK88P.png

      For 2017, we see fiscal months 1 thru 12, and then 2018 starts and we show thru fiscal month 7. When I attempt to do this in Tableau, the closest I can get is tabular data or bars or a disconnected line:

      Z2xaRNU.png

      FCLzmXd.png

      hNXouHy.png

       

      Is there an easy way to replicate this excel behavior in Tableau?