Forum Discussion

vixignus's avatar
vixignus
Regular Visitor
7 years ago

Dynamic ranking based on columns (dimensions)

Hi everyone,

 

I am trying to get the top advertisements or placements from digital marketing data based on different metrics like clicks, impressions, CTR(click through rate), etc. Below is the data I have:

 

AdvertisementPlacementClicksImpressionsCTR
Ad 1Pl 1100200000.50%
Ad 1Pl 2200222220.90%
Ad 1Pl 3150187500.80%
Ad 2Pl 47557691.30%
Ad 2Pl 56050001.20%
Ad 2Pl 65550001.10%

 

There are 2 slicers - one to select (Advertisement or Placement) and other to select (Clicks, Impressions or CTR). Based what is selected in the 2 slicers, I would like to see the ranked table of values with 2 columns one for dimension selected (Ad or placement) other for metrics selected (Clicks, Impressions or CTR). I have seen other examples for ranking in the forum, but none of them seem to address this particular problem.

2 Replies