multiple rows per ID but need a unique count by ID
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I think I'm having trouble explaining my situation in a few words which is why I can't find the answer, which I'm sure is somewhere. Here's my data view situation:
ID Sent Email Date
1 1-2-2019
1 1-8-2019
1 1-15-2019
2 1-2-2019
2 1-8-2019
3 1-2-2019
3 1-8-2019
3 1-15-2019
3 1-22-2019
So you can see person 1 got 3 emails on 3 dates, person 2 got 2 emails, and person 3 got 4 emails. I don't even care about the sent dates but I want my data to look like this and cannot figure it out
ID EmailNumber
1 1
1 2
1 3
2 1
2 2
3 1
3 2
3 3
3 4
How do I do this?
Solved! Go to Solution.
- Labels:
- Transformation
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
thank you so much!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Another option is the Tile tool
