Creating a Model

A Model is a saved question that acts as a clean, reusable starting point for reports. Instead of writing the same query logic over and over, you define it once as a model and build your reports on top of it.

To create a Model, you must first have a saved Question:

This example Question returns all active organization memberships, including membership tier and start/end dates:

To convert this Question to a Model, click the ellipses menu (...) and click Turn into a model:

This cube symbol indicates that the Question has been converted into a Model:

Once saved, this Model can be used like any other table in the reporting database - either as the basis for a new report or joined with other tables for more complex reports. Tables in the reporting database auto-join based on UUIDs, so make sure the Model includes the relevant UUID fields to take advantage of this.

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