Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I need to plot the number of tickets resolved per month
I have added the master calendar and linked to the resolve dates but the dates are not gettting linked to show the tickets.
Can anybody please help? is this anything to do with timestamp issue?.
Try the attached. New Script:
TR_Dump:
LOAD [Date Raised],
[TR #],
Date(Floor([Resolved Date])) as [Resolved Date]
FROM
[Test Data.xlsx]
(ooxml, embedded labels, table is [TR Dump today]);
Try the attached. New Script:
TR_Dump:
LOAD [Date Raised],
[TR #],
Date(Floor([Resolved Date])) as [Resolved Date]
FROM
[Test Data.xlsx]
(ooxml, embedded labels, table is [TR Dump today]);
In your excel file date is not on proper order please check after correction you get right data.
Regards,
Anand
Thanks..This has worked..Can you please help me understand what floor has done in this expression? i tried using only date function and it didn't work
Also will you be able to help me with another query?
I need to create another master calendar to link the Date Raised field from the facts table. If i use the same master calendar script will it not disturb the data as Month is common in both the master calendar scripts?
Floor removes the time component from a date and time field. I think the connection between master calendar and your fact table broke because of time in the [Resolved Date] field. It would be good to read about dates here: