I want to add a dynamic date level selection for my analysis with the options of week, quarter and month. Quarter and month works fine but I am not able to add week level.
Hi @mavil ,
welcome to the community ![]()
Have you tried something like: truncDate(‘WK’, orderDate)
Best regards,
Nico
Hi @mavil,
It’s been awhile since we last heard from you. Did you have any additional questions or were you able to find a work around for your case?
If we do not hear back within the next 3 business days, I’ll go ahead and close out this topic.
Thank you!
Hi @mavil,
Since we haven’t heard back, I’ll go ahead and close out this topic. However, if you have any additional questions, feel free to create a new topic in the community.
Thank you!