Difference between revisions of "Blue Folder Lookup"
m (→Introduction) |
(→Introduction) |
||
| Line 16: | Line 16: | ||
* '''Print''' - Print the summary details that make up the KPI. | * '''Print''' - Print the summary details that make up the KPI. | ||
| − | [[File:cl_BFL_1.png | + | [[File:cl_BFL_1.png|none|The Blue Folder Lookup screen. The screen shot shows an example of what you get if you click the blue folder on a "number of referrals" KPI from the [[KPI Report Designer]] output.]] |
Revision as of 08:20, 15 June 2018
Contents
Introduction
The Blue Folder Lookup page allows you to see the details behind that make up the numbers on a report. For example, if you ask for "number of contacts" using the KPI Report Designer, you will get a total number of contacts; next to the number is a blue folder, which will allow you to see the full details of the contacts counted towards that number.
In the blue folder you are able to do the following:
- Mail Merge - This process will allow sending emails, letters from the system to the people/organisations or extract the data to a third party application.
- Map View - Se the location of the people/organisations on a map.
- Extract the data - You are able to extract the data into a spreadsheet for analysis. The extraction can include:
- Additional fields from the person/organisation record.
- Additional information linked to the record, like benefits, disabilities, project record, extension databases (bespoke fields) and more.
- Additional information about the referrals (referral based KPI's), including assessments, extension databases and outcome.
- Use spread sheet templates that can be used for built in analysis for other members of staff.
- Print - Print the summary details that make up the KPI.
Export Results Through Mailmerge
This section will allow you to put together the output of your report with a mail merge, which you have previously set up (see Mail Merge for more information about mail merges). The people displayed in the grid at the bottom of the screen will be sent to the mail merge. If you have reached the Blue Folder Lookup page from a report on Contacts, Referrals etc (where people may appear more than once in the report, because they've had more than one Contact in the date range, for example) then the system will de-duplicate for you, i.e. it will only create one letter per person.
Map View
The map view relies on postcodes to place the clients/people, so if there is no postcode entered on their record, the map view will discard them. This is one of the reasons we advise that a name and a postcode should always be a minimum for data capture.
Export Options
All of the options in the middle section relate to outputting the data on a spreadsheet.
- If no extra data is selected, the table at the bottom of the page will be output as a spreadsheet.
- If any extra data is selected, the table at the bottom of the page will be output as a spreadsheet, with the extra data displayed in extra columns to the right of the basic data.
Add Data Extraction Formats
Any Data Extractions on your system can be added to a reporting output. The fields you have selected on the Data Extraction itself (using the "2. Choose What to Print" button) will be output as extra columns on the spreadsheet.
- Note: if you select a Data Extraction here which is configured to be a Mail Merge, it will act as a normal data extraction - i.e. letters will not be produced.
- Note: Data Extraction filters do not operate here.
See the Data Extraction page for more information.
Add Org/People-linked Records
You also have the option to add columns of data taken from the record of the organisation/person named on each line of the report. Various options are available. You can select more than one set of client-linked records by shift-clicking a range (PC or Mac), or holding the "Ctrl" button (PC) or the "Command" button (Mac) and clicking the options you require.
Add Referral-linked Records
If the original report related to Referrals, or to something linked to Referrals (Contacts, for example) then you will be able to add information from the relevant Referral to the spreadsheet output.
Spreadsheet Options
The Spreadsheet Options section gives you control of the header information on the spreadsheet. The options are:
- No Titles - just the data
- 1 Title Line (column headings) - the data, plus a single header at the top of each column. Usually the easiest option to work with when pivot tabling etc.
- Full Titles (includes header with dates etc)
There is also a drop-down box, "Where To Export To". The default option is "A blank spreadsheet", but if you upload template spreadsheets on the System Uploads page, these will appear here.
