Hi, in my dataset, the date variable is stated as weekly based, and they are failed to recognized as date when I change the type as date.
The dataset looks like
201901,201902, 201903, 201904,.... 201936, and so on.
I tried them with the change as Week 1, Week 2... but it still cannot be recognized in the system.
I would like to use it as date type to draw line graph.
Can anyone know what I should do to use it as a date type?
Thanks in adanve!
Tableau date format needs a day, month and year.
Is there any way you can provide the date associated with the week ?
Create a calculated field set to DATEPARSE("yyyyww",STR([Week]))
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...