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

    Query on Line Chart

    Niranjan Banarjee

      Hi,

       

      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

          Niranjan,

           

          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!

          Joshua