I would start by right clicking on the data source and do "Edit datasource filters". See if you have any defined there.
What happens when you make a fresh sheet and do a viz showing exact dates? Don't add any filters. Just drag your date field to rows and set it to exact date. Drag on some measure. Do you get a full range of data?
Thank you Joe for the reply. It shows all dates from the past all well as the current dates when I just bring Ldate (Original attribute). See screenshot below:
But it seems to me there is something wrong with Date Calculated Field where I used DateParse to convert date from string to Date field. Here is calculated field screenshot:
Is there any better way to convert date from string to date field. Thanks
1 of 1 people found this helpful
MAKEDATE( INT(MID([Ldate],1,4)), INT(MID([Ldate],5,2)),INT(MID([Ldate],7,2)) )
MAKEDATE() takes 3 integer values and makes a date. Argument order is year, month, day. Output is a date field. (If you end up with a date-time field, just wrap the whole thing in DATE() to force it to date only.)
MID is tableau's substring function.
INT takes a character string and converts it to an integer (if valid, of course.)
See if that does the trick for you.
PS: I just typed in the syntax above off the top of my head. You may need to clean up parentheses or other syntax.
Thank you again Joe. I used Makedate in the calculation, it states that "MakeDate" is Unknown function in this calculation. I am using 9.3 Tableau and live connection with Oracle server. Thanks
I also read somewhere that MakeDate only works with Extract data not with the live data. So, I extracted the data and it is working. Now I am good with the dates. Tons of thanks again.