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

Question

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.

Answer 1

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.

Elevate your data visualization skills with our Tableau Course and unleash the power of insightful analytics.