Google Data Studio FUNCTION: YEAR
With Google Data Studio, visualising, chaining and interacting with your data has never been easier. Among several immensely useful functions, the
YEARThe
YEARYEARThe
YEAR1) Accessing the year from a Date value:
YEAR(date_expression)2) Obtaining the year from compatibility mode Date values:
YEAR(X [,Input Format])It’s important to recognise that the
XThe
YEARLet’s imagine our organisation's sales records for an example.
Assume our data has a column ‘Date_of_Sale’, formatted in the 'DEFAULT_DASH' style (%Y-%m-%d). If we want to determine the sales year, we would specifically utilise the
YEARYEAR(Date_of_Sale)This would give us the year of each sale in the form of '2018', '2019', '2020', and onwards.
Now, consider a scenario where our data is being stored in milliseconds since the epoch. Using the syntax mentioned previously, obtaining the sales year would appear as follows:
YEAR(sales_time, 'MILLIS')This formula would return the same year data, despite the varying time storage methods, proving the versatility of the
YEARWhile being extremely beneficial, the
YEARFurthermore, the
YEARMake sure you are familiar with the syntax to get the most out of the
YEARFurthermore, be mindful of your organisation's data privacy regulations when using dates. Showing the complete date could inadvertently reveal sensitive information. Using the
YEARIn summary, the
YEARYEAR
