Hi,
You are getting the error because rct_origin is a Char field and cannot be used as a measure in a pivot view.
Pivot measures must be of type float or integer since they need to support aggregate functions like sum, average, etc.
Using type="measure" on a Char field causes Odoo to throw: "No aggregate function has been provided for the measure".
To fix the issue, you should use type="row" or type="col" instead of type="measure" for Char or Selection fields.
Update your XML view as follows:
<field name="rct_origin" type="row"/>
<field name="rct_destination" type="row"/>
This will allow the pivot table to group data by origin and destination, which is appropriate for string-type fields.
If
you need an actual measure, you can create a numeric computed field
(e.g., a count or boolean flag as integer) and use that instead.
Hope it helps.