2 Replies Latest reply on Dec 5, 2018 11:04 AM by Chandresh Mehta

    Data in Dates column converts to Asterisks

    Chandresh Mehta

      Hi Folks,

       

      I am kind of newbie on Tableau Dash boarding.

       

      I am having issues with the dates that are converting to asterisk when i try to plot a line and area graph in the sheet 1.

       

      See attached is the tableau TWBX with excel sheet and the snapshot of the data view after the graph is plotted, right click on the plot area and click on view data and the date column has all the asterisks instead of actual dates, it only takes few dates from the date columns...any idea?

       

      Thanks

       

      Regards

       

      Chintu...

        • 1. Re: Data in Dates column converts to Asterisks
          Michael Gillespie

          Chandresh, asterisks in Tableau means "more than one value was returned by the query for this element".  I can't look at your workbook right now, but it's likely that whatever you are doing with the data means that Tableau WANTS to show a single date in that spot, but it has multiple dates to choose from, all of which are correct.

          • 2. Re: Data in Dates column converts to Asterisks
            Chandresh Mehta

            Hi Michael,

             

            Thanks for your reply and thanks for taking time to look at the issue that i am having.

             

            The date column has data from 1st Feb 2018 to 30th April 2018, Tableau is able to only pick dates from 29th March to 30th April and it is converting to " * " for the dates from 1st Feb to 28th March, not sure why

             

            I tried to reformat the dates in excel sheet but no luck...Is there a way creating a calculated field or parameter??

             

            Thanks

             

            Chintu