Forum Discussion
Using rank as filter
Hi, I have a table below which shows the number of visits to a web site for each customer based on the channel. I've also created a measure to rank the channel for each customer (using RANKX). What...
Hi camargos88 ,
Eventually I want to show this in a stacked column chart with customer counts as the value and 'channel' as the legend.
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!