How to create yearly totals chart from simple orders table?

Need Help
#1

Hi,

I have a very simple table:

id INT
net_price DECIMAL
order_date DATE

I want to create a Dashboard data source and widget that displays one bar per year (e.g. 2023, 2024, 2025), where each bar represents the sum of net_price grouped by order_date (year).

However, the documentation does not include an example of how to correctly configure a date-based dimension for grouping (year/month) or how to make the widget use order_date as a date field.

How should I define the Data Source (dimension + metric) and configure the widget to achieve yearly grouping of orders by order_date?