Add top 3 and bottom 3 per category

[danielcontente]

Hi, 

I am trying to add the top and bottom 3 "Campaign Type", according to the average "Pipeline Acceleration.Value" per "Old Stage".

The idea is to have a visual like the one below, but with the top/bottom three Campaign Type in

each stage (Y axis) being displayed, rathen then the total top/bottom 3 (in this case, if a Campaign Type doesnt happened in one of the stages, it will not appear).

Please contact me for the raw data.

Thanks, 

Daniel

[Preeti_Yadav]

Hi @danielcontente 

You might try add the Campaign Type in the filters pane and in filter type choose the option of TOP N =3  and Bottom N =3  and apply filter.

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!

Regards,

Preeti

[danielcontente]

Hi @Preeti_Yadav,

Thanks for helping, but this doesnt give the output i ma looking for.

I want to have the top/bottom three in each stage.

If i do the way you mentioned, it will give me the top/bottom 3 for all stages and the it will show them in each stage.

[lbendlin]

Should be possible with a concatenation of two RANKX results. Please provide sample data in usable format (not as a picture - maybe insert into a table?).

[danielcontente]

Hi,

Thank you.

The link with the sample data:

https://drive.google.com/drive/folders/1lvuBPe9kKCp4jRweNITQVaaxfZ-kOhZN

[lbendlin]

I have a hard time distinguishing between campaign type and campaign name in your source data. Please advise.

[danielcontente]

Hi, there is no campaign name.

I understand some of the "Types" look like a name, but they are classified as campaign type (column C)