on 07-07-2015 4:20 PM
I'm in the Edit Initial View of the Data Source screen and want to use the Filter by Input String to limit the values for a dimension. I have figured out how to code it for a single value, multiple values, and to exclude single or multiple values. I can't seem to figure out how to include or exclude a range of values. So keeping it simple, say I want to limit the dimension City (which has many values) to return the range of Miami to Orlando. Is there any way to do this using the Filter by Input String?
Note: I do know there are other ways of accomplishing this, but I specifically want to know if it can be done with the Filter by Input String function.
I'm using version 1.5
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
regarding to this topic may I have a question about the performance?
when the filter is set for a dimension in the initial view, what is the data loading process?
variant 1: first all data content from this data source is loaded, then filtered to specific values.
variant 2: only filtered values are loaded.
which variant is the corresponding loading process? Is there any difference between loading the data source directly and loading the data source in script?
best regards,
Zhijian
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi William,
Sorry, I was too quick to read your original question and now see that you want to include or exclude ranges rather than individual values. I'll have to look into that to see if it's possible. In the meantime, I'd be interested to know the notation you worked out for excluding individual values.
Thanks,
Mustafa.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi William,
I had the same experience when I first tried this and with some trial and error worked out that the filter values need to be separated by a semicolon as shown below:
I haven't found a way to exclude values though. I think with the input string you can only include values.
Hope that helps,
Mustafa.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.