The Google Data Studio offers a myriad of diverse, effective functions for data manipulation, and one such proficient tool is the YEARWEEK function. An essential component in dealing with date-related data, this function facilitates a seamless extraction of the year and respective week number from a provided date.
In its essence, YEARWEEK follows a simplistic design that can be applied in two different manners, depending on the date details received.
1)
YEARWEEK(date_expression)date_expression2)
YEARWEEK(X [,Input Format])XInput FormatXXThe modus operandi of YEARWEEK lies in its ability to interpret and interact with dates. It converts a date expression or a compatibility mode Date value into a year-week format.
For date expressions, YEARWEEK simply breaks down the date and extricates the year and week number, presenting it as a combined output.
For compatibility mode dates, the function first interprets the provided input, depending on its type (text, number, or date) and optional format. Post this, it performs the same extraction as mentioned earlier.
Let's walk through a few examples to better understand the application of YEARWEEK, using a sales scenario. Assume our dataset captures sales transactions for an online store which primarily sells clothing items.
Suppose we have a date '2022-08-18' for a particular sale and we want to retrieve the year and week number:
markdown
Formula: YEARWEEK(Date)
Input: 2022-08-18
Output: 202233Consider another example where we have this date in compatibility mode with input as text:
markdown
Formula: YEARWEEK("2022-08-18", 'DEFAULT_DASH')
Input: "2022-08-18"
Output: 202233The function assumes great strength in its flexibility of accepting multiple formats, which also serves as its limitation. Inaccuracy in formatting, especially in compatibility mode dates, may result in incorrect output or errors.
1) Even though input format is optional, it's always better to define it accurately when dealing with compatibility mode dates.
2) Understanding the difference between the two types of syntaxes can help fetch the desired result with ease.
Become a Looker Studio expert
for free
Learn all the secrets of data analysis and create beautiful and effective dashboards thanks to our 30-second video courses! Join Catchr's community on YouTube.
Get more video lessons
All your data on Looker Studio
Build Looker Studio dashboard easily with your marketing data from all platforms and track your essential KPIs! No-code integration.
Start free trial now!
Optimize your data analysis
Get free Looker Studio dashboard template among a large collection of +50 stunning template! Elevate your data visualization.
Get free templates!.png)
