When creating advanced reports in the Reporting/ Analytics module you may have the need to pull in fields from multiple data sources into one report. You will need to connect these two data sources by a common field.
You can either start with an existing report and add in the new data source or you can create an entirely new report from scratch. If using an existing report you will want to navigate into design mode.
Reporting/ Analytics -> Report Maintenance -> Create Reports
Select your main data source from the available list on the DATA SOURCES tab.
At the bottom left of the screen, click on the Advanced icon.
Once in the advanced view, click on the add row icon.
After clicking Advanced, you'll still be in the Data Sources section, click on this icon to add your second Data Source
Choose your second Data Source and click on Continue to Fields
In your field drop down, you will see fields from both data sources available to select.
Perform your field selections and apply Functions and Formats as needed.
You can now continue to add filters and more or stop here, click save, and name your report and assign it a category.
Comments
0 comments
Please sign in to leave a comment.