# Create a new report

## How to create a new report?

* Click on Analyze from the navigation bar and navigate to **Reports.**
* Click on “**+ Create Report**” to create a new report.
* On the Build Report Using page - Choose **Model,** to build detailed reports using models created on top of your data warehouse tables.
* **Report** info popup will appear and  click on the **"Start Building Report"**
* The **Create Reports** form opens up. **Give a name** to your report.  
* Search and select the model on which you want to build the report.
* Click on **Create**.

## Build a Report from Table

Let's suppose we have an ecomm\_orders model and we want to build some analysis around that, like Category-wise total orders, Sales by state, etc.

* Click on "**+Create Report**" and select the ecomm\_orders model.
* On clicking on Create, you would land on the Edit View of the **Report Builder UI**.
* In the Input section, you can see all the **Dimension** columns and **Measures** that are present in the model.
* For example, let's build a table consisting of category-wise total orders. The **Table** is the default visualization type. 
* In the **Build** Section, **Table Fields** - there are two sections: **Summarize** and **Group By**.
* Drag Order\_id into the **Summarize** area. You may also click on "**+Add Column**" to add a column. When you drop a numeric column, the summarization is by default selected as **Sum.** You may change the aggregation type. As for our example, we need the **Count** of the Order\_Ids by category, so let's change the aggregation to Count by clicking on the dropdown button alongside the selected Order\_Id column in **Summarize** area and choose **Count** aggregation.
* Now drop *Category* into the **Group By** Area. 
* :zap: Hit the **Run** button.
* And there you have the Category-wise Total Orders report in the **Table** format.
* Now, for example, you want to plot a pie chart for the Category-wise Total Orders report. Click on **Pie-Chart** Visualization type on the top of the pane.
* Make edits to the chart settings if required, and :zap: Hit **Run**. 
* And there you have the Pie chart of the Category-wise Total Orders report.

<figure><img src="/files/alSzv49RCJWaeWz6ea06" alt=""><figcaption><p>Category-wise Total Orders </p></figcaption></figure>


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.sprinkledata.com/product/analysing-your-data/reports/build-using-models/create-a-new-report.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.