How to Data Blend Multiple Reports via Union or Join

Version: Yurbi v12

Role: Builder or higher

Permission: Builder access to the application


Overview


To use Link Report option the report must be an existing one.  If you are creating a new report, save it first, then access it through the Library section with the Edit action.

Join can combine data from two or more reports based on logical relationships between the resulting report’s data. It indicates how Yurbi should use data from one report results to select the row in another report results.

On the other hand, Union combines the results of two or more reports into a single result set that includes all the rows that belong to all reports in the union. The Union operation is different from using joins that combine columns from two tables.

Make sure that all reports needed to create a union or join report are ready.

Accessing the Report

1. Click on the Library button, which is found below the Dashboard button.

A screenshot of a menuAI-generated content may be incorrect.

2. Choose between the Team or Private subsection.

A screenshot of a computerAI-generated content may be incorrect.

3. Select the folder where the report or dashboard is nestled in

A screenshot of a computerAI-generated content may be incorrect.

4. Locate the report or dashboard you wish to edit.

A screenshot of a computerAI-generated content may be incorrect.

5. Click on the three dots found at the end of the report or dashboard.

A screenshot of a computerAI-generated content may be incorrect.

6. From the drop-down menu, select the Edit option.

A screenshot of a computerAI-generated content may be incorrect.

7. Upon selection, you will be automatically redirected to the builder section.

A screenshot of a computerAI-generated content may be incorrect.

8. Click Actions Menu

A screenshot of a computerAI-generated content may be incorrect.

9. Select Link Reports

A screenshot of a phoneAI-generated content may be incorrect.

A Report Linking dialogue box will appear. 

Join Type Report

In this section, we will cover the process of data blending a report using the Join option.

1. Under Joined Reports section, Click Add New

A screenshot of a report linkingAI-generated content may be incorrect.

2. Select the desired report you want

A screenshot of a computerAI-generated content may be incorrect.

3. Click Select

A screenshot of a computerAI-generated content may be incorrect.

4. Choose your Join Type

A white rectangle with black linesAI-generated content may be incorrect.

A blue line on a white backgroundAI-generated content may be incorrect.

5. Select your T1 from the drop-down menu

A blue and white rectangular objectAI-generated content may be incorrect.

6. Select your Operation from the drop-down menu

A blue and white stripeAI-generated content may be incorrect.

7. Select your T2 from the drop-down menu

A screenshot of a computerAI-generated content may be incorrect.

8. Click Save

A blue rectangle with white textAI-generated content may be incorrect.

9. You can see in the Report Linking, under Joined Reports that the newly configure Join Report is there.

A screenshot of a computerAI-generated content may be incorrect.

10. Click Save & Apply

A blue rectangle with white textAI-generated content may be incorrect.

For Join type, save the report first so that the configuration you have made will reflect in the preview section.

Union Type Report

In this section, we will cover the process of data blending a report using the Union option.

1. Under Joined Reports section, Click Add New

A screenshot of a report linkingAI-generated content may be incorrect.

2. Click Save & Apply

A screenshot of a report linkingAI-generated content may be incorrect.

3. Select the desired report you want

A screenshot of a computerAI-generated content may be incorrect.

4. Click Select

A screenshot of a computerAI-generated content may be incorrect.

5. Click Add New

A screenshot of a computerAI-generated content may be incorrect.

6. Select Primary Report Field from the drop-down menu.

7. Select Linked Report Field from the drop-down menu.

A blue and white stripeAI-generated content may be incorrect.

8. Select Data Type

A white rectangular object with a black borderAI-generated content may be incorrect.

9. Click Add Union

A blue rectangle with white textAI-generated content may be incorrect.

10. You can see in the Report Linking, under Unioned Reports that the newly configure Union Report is there.

A screen shot of a computerAI-generated content may be incorrect.

11. Click Save

A blue rectangle with white textAI-generated content may be incorrect.

12. Click Save & Apply

A blue rectangle with white textAI-generated content may be incorrect.

For Union type, the configuration will immediately reflect in the preview section.


And there you have it! You know now how to data blend multiple report using the Join and Union within the Link Reports option.