How to show Top 10 products

Suppose we want to create a table or chart showing a list of the most popular products or pages. We have the option to use either AI or Workflows. In this case, let's focus on using Workflows.

Steps in Workflow Editor:

1. Let's create a Workflow and assign it a name that reflects its purpose.
2. Add a "Pull" building block and specify the data source. In this example, we'll use WooCommerce.
3. Add a "Create Report" building block, indicating that it will work with the data pulled from the first block.
4. To aggregate statistics by product, remove all dimensions except for the product name.
5. Focus on retrieving the number of orders for each product.
6. Assign a name to the report building block.

Steps in Dashboard - Adding the Table:

1. Add a Table widget and set the data source to Workflow.
2. Select the Workflow you created earlier.

Steps in AI Notebook:

1. Start a new AI Chat.
2. Link an existing workflow as the data source.
3. Instruct the AI to generate a chart.
4. Click the "Save to Dashboard" button.

To generate a chart, start by creating a new Chat and ask the AI to create a chart based on the data prepared in the Workflow.

Steps in Dashboard - Adding the Chart: