What these calculated fields do is concatenate the month and day with the year and then use theDATE()function to convert the string into a date value. Indeed, Tableau recognizes the resulting fields as dates (with all the features of a date field, such as built-in hierarchies). A quick ...
To extract user_name, we will split out the string on user_id and then split it on “-” to get the user. After replacing “-” with a space, we get the user name “abid”. Finally, we will concatenate user_id with user_name. This unique id will be used in the next section ...