% of Total
Hey there, I'm trying to create a % of total column for my dataset with various domains.
Issue is, there's multiple rows with the same values as others.
Tried to perform a group by domain then rank by video plays with a partition by url, but it is not working.
Thought maybe a window function could work, but I would need it to be distinct since each url is different.
I don't think it's possible to do for each domain individually cause my original dataset has 937k rows and about 30+ domains, but if I have to...
I also wanted to know, is there a way to perform rank if you have multiple rows with the same value?
Similar Example of my table
I think down the road, I will need to separate the domains from each other and locate % of total that way too, but that may be asking for too much.