Decoding Dates in Tableau (Datepart and Datevalue)

Decoding Dates in Tableau (Datepart and Datevalue)

Today, we’ll explore the difference between DATEPART and DATEVALUE in Tableau. At times, we need to compare performance across specific time periods; other times, we simply want to observe trends over time. That’s where DATEPART and DATEVALUE come into play. DATEPART: DATEPART breaks a date into specific components like month, quarter, or year. It returns discrete…

Dual axis in Tableau

Dual axis in Tableau

A Dual Axis in Tableau lets you overlay two different measures – each with its own y-axis on the same chart. This is useful when comparing two different metrics such as Sales ($) and Profit Margin (%) over time. Here we are going to combine Bar Chart (for sales) with Line Chart (for profit). Below…