Forum Discussion

bo_afk's avatar
bo_afk
Post Patron
5 years ago

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...
Need Help
bo_afk's avatar
bo_afk
Post Patron
5 years ago

Thanks camargos88 for your suggestion!

 

I have another column in my data, "device type", so it's possible for channel to appear on multiple rows for each customer if they browse on several devices. How do I amend the formula to take this column into account?

camargos88's avatar
camargos88
Community Champion
5 years ago

bo_afk ,

 

How do you want to show this information (visual) ?

  • bo_afk's avatar
    bo_afk
    Post Patron
    5 years ago

    Hi camargos88 ,

    Eventually I want to show this in a stacked column chart with customer counts as the value and 'channel' as the legend.

    • camargos88's avatar
      camargos88
      Community Champion
      5 years ago

      bo_afk ,

       

      So what role the column "device type" would play here ? 

      Just trying to understand to think about the measure.

      • bo_afk's avatar
        bo_afk
        Post Patron
        5 years ago

        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!