Tableau does not import all the dates in column from csv file

0 votes

I'm trying to import 'Dates' from a.csv file's 'Date column' into tableau. However, certain dates in the tableau are missing. In tableau, I don't have any filters.

Image below: Dates are grouped as 'Forecast' and 'Historical' in the Excel file. Only historical dates are displayed in Tableau, whereas forecast dates are imported as NULL. The dates column in the.csv file is all structured as a date.

Please assist me.

image

image

Apr 4, 2022 in Tableau by Vaani
• 7,020 points
247 views

1 answer to this question.

0 votes

Is it feasible to convert the csv data format to string? Or should you make the adjustment to the Tableau connection? It's simple to convert to a date in Tableau if you can obtain the "date" column into Tableau as a string.

Tableau's DATE, DATEPARSE, and MAKEDATE functions all convert non-dates to dates. (For additional information on the date conversions, see: https://tarsolutions.co.uk/blog/dates-in-tableau-the-ultimate-guide/#convert)

answered Apr 5, 2022 by Neha
• 8,940 points

Related Questions In Tableau

0 votes
1 answer

Can you please send me the file database.csv used in the Tableau training

Demo - US Crime Dataset READ MORE

answered Feb 15, 2021 in Tableau by Ibrahim
2,422 views
0 votes
1 answer

How to color code cells of a column based on the text value in Tableau

You can use the following steps to ...READ MORE

answered Mar 27, 2018 in Tableau by Atul
• 10,230 points
8,599 views
0 votes
1 answer

Not able to publish workbook in Tableau Server after upgrading it from Tableau 9.1 to 9.2

Following is a little hack that will ...READ MORE

answered Jun 19, 2018 in Tableau by xyz
• 1,560 points
645 views
0 votes
0 answers

Using Python and Tableau in conjunction with one another

Is it possible to mix Python visualisations ...READ MORE

Feb 28, 2022 in Tableau by Vaani
• 7,020 points
167 views
0 votes
0 answers

Tableau Desktop Inside Tableau Server

Is there an executable for Tableau Desktop ...READ MORE

Feb 28, 2022 in Tableau by Vaani
• 7,020 points
152 views
0 votes
0 answers

Tableau Map view Continent List

I've been attempting to tidy up my ...READ MORE

Feb 28, 2022 in Tableau by Vaani
• 7,020 points
176 views
0 votes
0 answers

Downloading tableau workbook from tableau server with data

I'm brand new to tableau server. I ...READ MORE

Feb 28, 2022 in Tableau by Vaani
• 7,020 points
200 views
0 votes
1 answer

How to fix spelling error in a field or column value using Tableau?

You should be able to use a ...READ MORE

answered Mar 10, 2022 in Tableau by Neha
• 8,940 points
253 views
0 votes
1 answer

How to share a workbook with client in Tableau who do not have Tableau account or tableau reader

It's possible that there isn't a way ...READ MORE

answered Apr 5, 2022 in Tableau by Neha
• 8,940 points
189 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP