neilprobst Member

@verytiredgirl sorry for the late reply. I used the 'Maximum' aggregation In this example, "GDV Rank" is the field that contains the ranked values for each partition. This Group By transform gets the max value for each partition. I then merge this back with the main dataset so each row has a rank and a max rank that will…

Thanks, this solves my problem (though I used a Group By rather than a second Window function to get the max rank). I think my issue was more my own innumeracy with percentile calculations rather than the ETL process itself. Thanks for talking me though it

Thanks for you help. I didn't realize I had the ability to add a variable control directly to a dashboard in order to spend. I set it up with two controls as fill-in textboxes. This solution will work, though my original desire was to have a single slider control for selecting the start and end of the range. I am assuming…

@MichelleH In this case, the filter is not in set up within the card with the table, but rather a separate filter card tied to the same dataset and displayed on the same dashboard. I didn't try to doing it with a dynamic filter within the card until now, and it appears to work when I select the 'Sum' aggregation. That…