Filter By Rank() Column

Question & Answer
1

Hey,
I am trying to create a filter that exclude all top users with the highest revenue partitioned by experiment_id and experiment_version (Test Group).
This is the calculated field:
rank([sum({REV_DT}) DESC],[{EXPERIMENT_ID},{EXPERIMENT_VERSION}]).

The Problem is that the field presents properly/can works as a filter only when the columns {EXPERIMENT_ID},{EXPERIMENT_VERSION} exist in the visualize.

Is there any way to bypass this requirement?

2

Hi @Eldad_Levi - Can you try to filter this data at data set level so that before analysis, the data will be filtered. and if you do not want to expose this data, you can also add in excluded field as well.

Regards - Sanjeeb