Joining Data

Drew MacPhee
Drew MacPhee
  • Updated

To join data tables, begin by navigating to the report editor by clicking Editor:

wicket-admin-reports-join-data-1.png

 

Next, click Join data:

wicket-admin-reports-join-data-2.png

 

Next, click the data table to be joined to the existing report data:

wicket-admin-reports-join-data-3.png

 

In most cases, the join keys will be automatically populated, based on known relationships between the data tables.

Note: data tables are always joined on UUID values.

wicket-admin-reports-join-data-4.png

 

Click on the dropdown arrow to select which columns from the newly joined table will appear in the report:

wicket-admin-reports-join-data-5.png

 

Click Visualize:

wicket-admin-reports-join-data-6.png

 

The new data fields have now been joined to the report:

wicket-admin-reports-join-data-7.png

 

By default, the join key is included in the newly joined field name.

This field can be renamed by clicking the field name and clicking the cog button in the pop-up menu:

wicket-admin-reports-join-data-8.png

 

Type the new field name under Column title, and it will automatically update in the report:

wicket-admin-reports-join-data-9.png

 

A report must be saved for the changes to persist:

wicket-admin-reports-join-data-10.png

 

When saving, the original report can be overwritten, or a new report can be created instead:

wicket-admin-reports-join-data-11.png

 

Wicket's reporting solution is powered by Metabase. Additional documentation is available in the Metabase documentation.

 

 

Was this article helpful?

0 out of 0 found this helpful

Have more questions? Submit a request

Comments

0 comments

Article is closed for comments.