Forum Discussion
Using rank as filter
bo_afk ,
So what role the column "device type" would play here ?
Just trying to understand to think about the measure.
Hi camargos88, the issue I have is the following:
I am trying to rank on the Channel only and not device type. So 'direct load' has total of 2 visits for this customer and therefore it should be ranked 1 and 'paid search' should then be ranked 2 but as you see below, they're both ranked 1.
When I copied your formula (count customers with rank 1) it shows the following, which is wrong because as mentioned above, only direct load should appear here.
Any ideas?
Thanks again!
Hi camargos88, thanks for this!
Weirdly, it doesnt seem to work with my dataset and I'm not too sure why...it's still showing rank 1 for customer E for both 'direct load' and 'paid search'.
But I can definitely see that it's worked with the one I gave you. Maybe I need to reload my data back into my report or something. Will try to figure out what's caused this.
Hi camargos88, see below the data
Customer Channel Device Total visits A Direct Load Tablet 3 A Email Mobile Phone 2 A Natural Search Tablet 1 A Paid Search Tablet 43 B Direct Load Desktop 17 B Direct Load Tablet 9 B Paid Search Desktop 3 B Paid Search Tablet 2 C Direct Load Tablet 3 C Natural Search Tablet 1 C Paid Search Desktop 8 C Paid Search Tablet 8 C Referring Sites Tablet 1 D Direct Load Mobile Phone 1 D Paid Search Desktop 2 D Paid Search Mobile Phone 2 D Paid Social Desktop 1 E Direct Load Desktop 1 E Direct Load Mobile Phone 1 E Paid Search Mobile Phone 1 Hi camargos88, thanks for the file!
Numbers are still slightly off and I think this is because of customer E. As you can see below, the total number of visits for "Direct Load" for this customer is 2 (1 on mobile and 1 on desktop), but the total visits for "Paid search" is 1 (just 1 for mobile). Therefore, "Direct load" should have a rank of 1 and "Paid search" a rank of 2, but here both are ranked as 1.
Is theere a way to 'ignore' the device type?
bo_afk ,
Direct Load has customer with 1 for customer B and E.
I am a little bit confused here:
"Therefore, "Direct load" should have a rank of 1 and "Paid search" a rank of 2, but here both are ranked as 1."The measure gets the highest visits for each channel/customer and filter the ranking number 1.
What do you mean with rank of 2 ?
camargos88 Sorry I should say that "Paid search" shouldn't have a rank of 1 because the total number of visits for customer E through this channel is 1, whereas the total number of visits for customer E through "Direct load" is 2. Does this make sense?
bo_afk ,
Keep in mind that if you have the ties, the values are gonna be the same, so you need to break it.