Grand total instead of running total with Count in Rank & Window?
I was trying to get a total number using Count with Rank & Window in Magic ETL but I can only get a running total instead of the grand total repeated across the rows. My output looks like this: jane doe, item a, 1 jane doe, item b, 2 jane doe, item c, 3 But I wanted this: jane doe, item a, 3 jane doe, item b, 3 jane doe,…