Reply
Topic Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Ranking for multiple entries
11-30-2023
09:13 PM
Hi,
I have multiple entries as you can see below screenshot the number should have MonthUnique Count as 1, 2 but it is showing up as 1
https://drive.google.com/file/d/1Y_qQCdj5pxf2Pvn8zMIzJxeMw4lMYGGk/view?usp=drivesdk
Solved! Go to Solution.
1 ACCEPTED SOLUTION
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-01-2023
05:14 AM

@Ahmedx I was able to get the work done by
MonthUniqueCount =
RANKX(
FILTER(
WeekUniqueTicketTable,
WeekUniqueTicketTable[Month Unique Ticket] = EARLIER(WeekUniqueTicketTable[Month Unique Ticket])
),
WeekUniqueTicketTable[EDITED_DATE],
,
ASC
4 REPLIES 4
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-30-2023
09:57 PM

can you explain the logic - why 1,2,3 on the basis of what it should be like one example
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-01-2023
01:23 AM

Just wanted to add this as a screenshot because for some weird reason, the reply is not saving.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-01-2023
05:14 AM

@Ahmedx I was able to get the work done by
MonthUniqueCount =
RANKX(
FILTER(
WeekUniqueTicketTable,
WeekUniqueTicketTable[Month Unique Ticket] = EARLIER(WeekUniqueTicketTable[Month Unique Ticket])
),
WeekUniqueTicketTable[EDITED_DATE],
,
ASC
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-01-2023
05:50 AM

@Ahmedx can I accept my own solution as a solution? Is it possible and not violate any rules. If not could you please accept it as solution for me.

Helpful resources
Featured Topics
Top Solution Authors (Last Month)
User | Count |
---|---|
73 | |
70 | |
38 | |
24 | |
23 |
Top Kudoed Authors (Last Month)
User | Count |
---|---|
96 | |
93 | |
50 | |
41 | |
40 |