I’m working on a dashboard and need data for the past 20 weeks, with each week starting on Monday.
When I run my query, it correctly pulls data for the past 14 weeks, starting on Monday, but the day get changed if I change the number from 14 to any other number.
Hi @cijod
can you share a sample what data you have and what output you expect?
Do you like to use today date and go 20 weeks back? So today it is week 43, go back 20 week, will be week 23, week start will lead to data since 3 June?
BR