This was for some reason harder than it should have been. Needed to create the number of weeks from the beginning of the year to today. Re-posting this really because there are not a lot of examples out on the web. date_diff(“week”,toDate(“2018-01-01″,”yyyy-MM-dd”), now()) as ‘YearlyGoal’ I will go back later to make the start of the year…
Wave / EA: Counting the number of weeks, months, days, etc. in SAQL
Posted on