Hello,
I have a "Fiscal Year" column prompt with an "is between" operator. Obviously, an user has to enter two values - "beginning of range" and "end of range". And there's also a presentation variable varRange being set by this prompt.
Now, I want to put a filter which is basically to only use Fiscal year between those "beginning of range" and "end of range" values entered by user. I know I don't need to have a presentation variable for this, and simply use "is prompted". But still, if I were to use the presentation variable's value for this filter, how do I do that? I mean, varRange variable now holds two values, so how do I split the varRange variable into two values - "beginning of range" and "end of range"? Can I use an array-like syntax, something like @{varRange}->[0] and @{varRange}->[1] ?