I've tried using rank function in magic ETL, but it also counted the once without data. Please see output. Can someone help me on this.
