Hi,
Goal: User inputs number and field : currentPrice_EUR filters ONLY bottom (user inputed value) rows.
What I have:
- I have a dimension called currentPrice_EUR
- I have a variable called vPriceRange for the user to input.
- I have a variable called vMaxRank where shows max rank of currentPrice_EUR.
- I have vBottomValues where is vMaxRank-vPriceRange. (This is to rank bottom, so if user inputs 5 it will show higher than vBottomValues and get the lower values.)
I need to make a dimension expression to show and select only values that are higher than vBottomValues. I am having issues because It is not removing all those that don't match the criteria, instead it is keeping them and just showing me bottom ones first.
What I've tried:
=aggr(
if(rank(currentPrice_EUR) > $(vBottomValues), currentPrice_EUR),
currentPrice_EUR
)
This shows bottom first but keeps all the rows..
Tried looking for this everywhere can't seem to understand why shows all rows instead of just bottom ones picked.
