Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
=date([Fab Out Dt] + $(vDate)) .
I am able to generate date using this in calculated dimension in table...but as soon as I convert it in line chart i get numbers instead of date...
I have attached both chart and table image
table shows fine but as soon as I click on line chart it shows internal numbers. Is there a way to convert them to date on line chart?
What is comming on your variable vDate?
I did this same test here (with the same calculated dimension) and it worked fine.
If possible, upload here your qvw.
Regards,
Gabriel
please upload your qvw
Hi Ria,
Can you try: =date([Fab Out Dt] + $(vDate),'M/D/YYYY')
Thanks all!
I did below and it worked
Settings - Document Properties - tab Number. Select the date field and choose Date at the Number format settings