In Analytics Builder I am struggling to understand how I might recreate a filtering technique I've used in the past. In order to get a dataset of current credit instructors and their courses, I'd use the Rank & Window function to get a number on the most recent action found in the Enrollment Details dataset (instructors often get re-assigned before the term begins). Then I could create a filter where the rank = 1 and the action = Enroll.
When I try to add a Calculated field in Analytics builder using the Table Calculation functions, the results are not able to be filtered in the new dataset. A message tells me I can filter them in the Analysis, but that won't be very helpful if I am planning to use this dataset to combine with others.
I can't help but feel I'm missing something fundamental in understanding how QuickSight works differently. Like maybe I ought not be creating these sub datasets to feed other datasets? Or perhaps there is a way to filter on a grouping within the data prep that I am missing?
Any pointers are much appreciated.
PS. I'm also not seeing a DOES NOT START WITH as a filter option in QuickSight Data Prep. Is that not a thing?
