Some FocalScope reports can be combined with other FocalScope reports to create more detailed reports that incorporate multiple report metrics. This functionality is very useful when you want to create overview reports that cover multiple aspects of your support and communications processes. This article details how you can combine the data from two different reports in FocalScope.
Figure 1 - FocalScope Report Center
Please note: The User-Group.xlsx and Group Performance.xlsx are mere used for demonstration purposes. Your report files will have different names depending on which reports you generated.
Figure 2 - Excel files in the Reports folder
Please note: It is important that the [User-Group.xlsx] file be opened before the [Group Performance.xlsx] file is opened. In this example the [User-Group.xlsx] file serves as a dictionary for the [Group Performance.xlsx] file.
The primary component (and front end) of the final report is the Group Performance.xlsx report; the secondary component is the User-Group.xlsx report. The predefined pivot tables and charts are configured in the Group Performance.xlsx file. Both reports get their data directly from the FocalScope database, and the final report comprises of a combination of the data in both reports.
Please note: In this example the Group Performance.xlsx report references data in the User-Group.xlsx report using two custom data fields, as indicated in Figure 3: