tbsheff

I was able to figure this out by creating a calculated running total field and using that as my comparison value. Thanks!

in Is there a way to dynamically select the nth row of a table? Comment by tbsheff October 2023

Yes, that makes sense. I do have it partitioned on 'Department' with a rank function ordered on 'Month Year' and 'Score'. My hope is that I could have it filter down to a specific department and a range of scores. Then I want the 'Month Year' that will match 'Number of Employees' for that department. The issue I run into…

in Is there a way to dynamically select the nth row of a table? Comment by tbsheff October 2023

I used magic ETL to partition by 'Department' asc and score desc. Then I used beast mode to create this rank field to dynamically count the rows in a filtered table: COUNT(Month Year) over (order by Month Year asc, Score desc) I have 2 filters on the data, 'Department' and 'Score'. I want to select the row number that is…

in Is there a way to dynamically select the nth row of a table? Comment by tbsheff October 2023

tbsheff Member

Comments