I need to concat or aggregate two similar values so they show up as one

[Bubskim]

Hi all,

How do I concat this example?

Email - example@gmail.com

email- example

both emails are the same the one has the @gmail.com at the end. I need to join them to display as one in my chart. This can be in the load or in the expression. 

Aggr(If((Count(DISTINCT)["example", "example@gmail.com"]) = ERROR

Count(DISTINCT)["example", "example@gmail.com"]) = ERROR

capture shows the issue

[Arthur_Fong]

Hi,

Attached is the requirement you looking for:

Thanks and regards,

Arthur Fong