1 Reply Latest reply on Aug 29, 2016 8:15 AM by Joshua Milligan

    Query on Line Chart

    Niranjan Banarjee



      Is there any possibility to have a dropdown which has break up by YTD,3MMT,Monthly.


      I have all data in columns as string.


        • 1. Re: Query on Line Chart
          Joshua Milligan



          So, if you have a string like "3 MMT-Aug 2015", then I wonder if you additionally have values such as "YTD-Aug 2015" and how that data is structured.  That might help in knowing some of the options you have.


          If you can convert your strings to a date, then you'll have a lot of flexibility with Tableau's built-in date features.  You could get dates with code like this:


          DATEPARSE(REPLACE([date string], "3 MMT-", ""), "MMM yyyy")


          Hope this helps!