Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Community,
Quick question about select in field..
I have a table with an expression that spits out a % in each row. I want users to be able to filter based on the % but the problem is that it is not a dimension...
i want to have a input box where they type the % they want to see and it selects those and displays only that in the table.
any ideas? i tried using variables and using this link but no luck .
are you using a st table or a pivot?
If you are using a st table
Then make the expression as a calculated dimension and goto presentation tab and hide the dimension column.
Now you should be good in making the selections and it reflects in the table too.
Thanks
You have to make a selection in chart dimension based on the same expression you use in the chart, comparing it against the variable of the input box.
See attached
the problem is i have to use an expression... You used a dimension for your search in field. How can you search inside expression?