can anyone please guide me on this.........
is this not possible in tableau..? if possible can anyone please help me to get this done.
is there any way based on parameter filter option can filter the data.
something like this, if parameter value enter as 10 then automatically filter option can filter 1 to 10 and if parameter change to 20 then 11 to 20 and so on....
write the below calculation and drop on to filter shelf (Make sure Top Value parameter is 10 )
IF INDEX() >= ([Top Value] -9) AND INDEX() <= [Top Value] THEN ATTR([Categeory 1]) END
once you drop you will get pop up, select all and click ok
Now increase the Top Value to 20 and the view will be as shown below, go to filter and uncheck Null value and click apply, you will get the required result.
please check attached workbook.
Parameter testing.twbx 168.2 KB
thanks for the great response !
its work perfectly , however its showing result based on order measures.
but i have to based top, next top......soon based on value measures.
hopping for the response from you
thank you !
I tried changing your formula with below
RANK(SUM([Value])) >= ([Top Value] -9) AND
RANK(SUM([Value])) <= [Top Value] THEN
thank you so much its work perfect now
just one more thing want to know here is
is there any possibility to get top value parameter list automatically based on the row data no.of rows
like if in row data suppose we have 50 rows then top value parameter list should have 10 to 50 something like this.....
In Tableau for now Parameters are not dynamic.
please check the below link, hope this might help you.