0

Custom user dimension linked to a specific e-mail account

Dear all

Irrespective of my attempts, I still need to succeed in creating a dimension of specific users/clients with a particular e-mail account suffix. In other words, to identify all the clients with, for example, a gmail.com e-mail.

I would appreciate any advice you can give me.

Thank you 

Dolf Jordaan

2 replies

null
    • Senior Director of Product
    • Ian_Macdonald
    • 1 yr ago
    • Reported - view

    Hi Dolf,

    You are sure you need to create a new dimension / hierarchy that only contains email address equal to "gmail.com"? Or are you rather looking to create a List of users with that suffix?

    LMK and I can help further.

    Ian

    • Senior Director of Product
    • Ian_Macdonald
    • 1 yr ago
    • Reported - view

    Hi Dolf,

    Here's how you might do it to create a list of names that have a specific email domain:

    First, create a list of emails that contain the domain you require. Open formulate against your model and select to create a List. Drag on  standard list and select your email attribute:

    Add a "Contains" filter block and set the string to look for, in this case "adventure-works.com":

    Save the dynamic list, in this case as AV.

    Create a new dynamic list, this time using the "Name" attribute:

    Then use a "Non-Empty" filter and pick the AV list we created previously. This will keep all the names that have "adventure-works.com" as their email domain.

    Save the list, in this case Names AV. This list can then be used in your rows / columns / slicers etc. as needed.

    Hope that helps.

    Ian

Content aside

  • Status Answered
  • 1 yr agoLast active
  • 2Replies
  • 23Views
  • 2 Following