1 of 1 people found this helpful
You need to drag this calculation, you'll get your desired outcome
Calculated field- STR([user id]) + "@gmail.com"
Hope it helps.
I have used the below logic: please help me out. I am getting NULL value.
User id: Koushik123
Email:STR([user id) + "@gmail.com"
The above calculated field is giving me NULL
Can you please share the workbook, so that i can look into it.
First of all you have to tell us clearly whether your userid field is containing "email@example.com" or "koushik123"
because as per the formula shared above is showing that ur userid field is containing "firstname.lastname@example.org" and you want to compare with the user logging in system with their userid. If it is show then no need to do this kind of formula, instead you can use split function in Tableau by using this you can split your dimension using "@". After that you can use the split dimension created by tableau in your above formula for your further calculation.
Hello yash & Sandip,
Thanks a lot for the quick response.
This particular Issue has been resolved.