Dynamic date level selection

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 :tada:

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!