Table field association

[awigham]

Hi all,

I've got an app with two tables:

• A csv file showing all user interactions with a website
• An xlsx file showing all user profiles associated with that website

The csv file has a field  "User Affected Email" which lists the email address of the user account affected by the interation. The xlsxfile has a field " Email" which lists the email address associated with a user account.

If a associate the tables, I get an association "Email-User Affected Email" which then comes through into the app as a dimension "Email-User Affected Email".

The issue I have is trying to be able to show the number of appearances of an email address on the interaction sheet (ie number of time interacted with in last month) compared to the number of user profiles held for a particular client (a  field on the xlsx file). If I count by "Email-User Affected Email" I only ever get the count of addresses from the xlsx, whereas I need the count by the csv.

[awigham]

Good spot.....! Thanks.

That helps me get a total count of the number of events from the first table but I need the number of unique users (from the email address) that participated in those events. For example:

Count([Client) gives me the number of user accounts a client has = 10558

Sum(Count) gives me the number of interactions from that client = 5555 for August.

However, I don't know if those 5555 interactions we for 1 user 5555 times, 9 users 556 times & 1 user 551 times or any combination in between.

Any ideas?

Thanks for your help so far!