You cannot use table calculations to "Set from field" in a parameter. Have you tried using the table calculation on the filters shelf? Then you can use the filter as a slider or a drop down menu.
Hope this helps!
Please mark this answer as correct or helpful if it helps solve your question.
Items are added to the parameter values on daily basis, so technically I can't give the parameter an upper range unless the upper range is dynamic. I tried using "All" for allowable values but then I'm not able to change the parameter to slider (only "Type In" option is available for "All" allowable values) . I was wondering if there's a workaround to this limitation.
Please upload your workbook.
I fixed that problem by adding a field to my custom query and linking the parameter to that field.
In my solution I used a parameter and calculated field to create a paging solution. The problem is that when I use a filter (say continent filter in the attached example) the number of records and subsequently number of pages remains unchanged. For instance when I choose only Africa in the continent filter, even though its records fill only the first 2 pages, all 8 pages show up in the parameter dropdown options and the last pages show empty.
Can you suggest a solution to dynamically change the number of pages shown in the parameter (even if it means creating additional fields in the query for my actual dataset). Alternatively, can you think of a way to use a combination of filters and calculation fields in lieu of the current solution? I attached my sample workbook to the original post.