|
This feature allows you to generate URL with filters on the report containing questions with text responses. Thus report viewer can preview and filter a report without accessing your account directly.
Click the Publish button for the selected custom report on the Reports home page and then:
- Under the first step the link to your report resides. Copy that link.
- Using any external text editor add filter logic at the end of your report link and specify parameters of your filters.
- Insert the customized report URL in your website.
Let us take a look at a short example
Here is a customized report URL with parameters for filter logic and filters:
http://keysurvey.com/report/38345/-1/35cc?afterVoting=d651cb1abceb&LOGIC=F1 OR (F2 AND F3)&F1=[Q1.A2][M]text&F2=[Q2.A7][M]header&F3=[Q3.A5][C]topic
Original report link is in red.
Start of filter logic (this will always be the same) is in green.
Filter logic is in purple.
Parameters of the filters are in brown.
Parameter LOGIC describes filter logic. You can use AND, OR and combined filter logics.
LOGIC=F1 AND F2 means that you will see the report on those respondents who meet the conditions of all your filters.
LOGIC=F1 OR F2 means that you will see the report on those respondents who meet the conditions of at least one of your filters.
LOGIC=F1 OR (F2 AND F3 ) means that you will see the report on those respondents who meet the conditions of F1 or F2 and F3 filters.
The same filter logic is used in our Advanced Filter, for details consult the 'Advanced Filter' and 'Filter Logic' help chapters.
This report URL contains a set of parameters describing filters. For example, F1=[Q1.A2][M]text, where:
F1 - filter,
Q1 - question number,
A2 - answer number,
text - text response.
You can use [M] or [C] tokens before the text response.
For example F2=[Q2.A7][M]header - means that the responses that contain the exact line string indicated next to [M] in the report URL will be included in the report.
F3=[Q3.A5][C]topic - means that the responses that contain all of the words indicated next to [C] in the report URL regardless of their order will be included in the report.
You can use [DS] and [DE] tokens to specify Start Date and End Date for the filtering.
For example LOGIC=F1 AND F2&F1=[DS]2005-08-25&F2=[DE]2005-09-23 - means that the report will contain only those responses that were received between the dates specified next to [DS](start date) and [DE] (end date) tokens in the report URL.
Note
- For the 'Single Line' question type you should specify not only the question number but the answer choice number as well. For example: F1=[Q2.A1][C]comments.
- The text response specified next to [M] or [C] tokens is case-insensitive.
- URL filters may be saved by means of cookies within the same browser session. To open blank report following the default report URL it is strongly recommended closing all current sessions and opening new browser window or using different browser.
- If you want to open report without clearing browser cache or restarting browser please use the &resetFilters=true parameter at the end of your default report URL. In this case each time you open report link it will be reset to the default status.
Here is the example of how your report link should look like:
http://keysurvey.com/report/38345/-1/35cc?afterVoting=d651cb1abceb&resetFilters=true
|