#calculated field

#WoW S02 E39 :Vertical Label in Tableau

Do you enjoy working with Tableau? Are you looking for an additional challenge? Workout Wednesday might be what you need. WorkoutWednesday a set of weekly challenges from Andy Kriebel and Emma Whyte (for 2017) and Rody Zakovich and Luke Stanke. (For 2018) designed to test your knowledge of Tableau and help you improvise your development skills. The idea is to replicate the challenge that they…

Tableau: Format Date As String mm/dd/yyyy hh:mm

gah.

Why is some of this stuff so challenging in Tableau?  You have a date and you want to format it as a string? Why? So you can concatenate it with another string perhaps? Maybe you’re creating a calculated field to use in a label (that’s what I was doing).

Unfortunately, when you convert a datetime to a string in Tableau it uses the format yyyy-mm-dd hh:mm:ss. Fine for a lot of cases, not fine…

Create Calculated Field with the below code.

YTD Sales:

IF [Order Date] <= TODAY() AND DATEDIFF('year',[Order Date],Today())= 0 THEN [Sales] END

change the field ‘year’ to ‘month’ and you get your MTD

MTD Sales:

IF [Order Date] <= TODAY() AND DATEDIFF('month',[Order Date],Today())= 0 THEN [Sales] END

Three columns:

Date Received - Date Only

Due in # Days - Number, no decimals, greater than 0, not required, default value 14

Deadline - Calculated column

Formula: =IF([Due in # Days]>0,[Date Received]+[Due in # Days]," ")

Whatever is entered in the Due in # Days column is added to the Date Received column to calculate the Deadline.

Great reference for calculated fields.

For Date, the return type of the calculated column must be set to Date and Time.

Column1: 6/9/2007

Column2: 3

Formula: =[Column1]+[Column2]