Explain the DATE Function ' YEAR' in Tableau with Example?

 In Tableau, the YEAR function is used to extract the year component from a given date. It returns an integer representing the year.

The syntax of the YEAR function in Tableau is as follows:

YEAR(date)

• date is the date value from which you want to extract the year.

Here's an example to illustrate the usage of the YEAR function in Tableau:

Suppose you have a dataset with a date field called "Order Date" containing various date values. To extract the year component from the "Order Date" field, you can use the YEAR function as follows:

YEAR([Order Date])

In this example, the YEAR function is applied to the "Order Date" field. It will return an integer representing the year for each date value in the "Order Date" field.

The resulting output will be a column of integers representing the year for each corresponding date in the "Order Date" field.

The YEAR function in Tableau is useful when you need to analyze or group data based on the year component. You can use it to create visualizations or calculations that depend on the year, such as analyzing yearly sales performance, comparing trends across different years, or calculating aggregates for each year.