
Contributor
2021-03-11
10:25 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Dynamic row-based calculation
Hi everyone!
I'm trying to calculate the H-Index for a set of data where H-Index of x means that an individual has x entries each with at least x cites (a score).
In the dataset below:
The overall H-Index would be 6 (there are at least 6 entries in the table above each with cite value of 6 or above) and the H-Indexes for A and B would be 5 and 4 respectively.
I'm able to compute the overall using a measure:
Count( DISTINCT aggr( NODISTINCT if(Cites.Cites>=NUM(RANK(TOTAL Cites.Cites,4,1)),[Entry]),[Entry]))
However, each row only shows the share of counts for the total.
I would like each row to be updated with the correct H-Index for each person.
Is there any way I can achieve this?
469 Views
0 Replies
