Hy,
the Asset management module is associated with the Project module in that way that for every WorkOrder a project or subproject is created. This means that all time posting are available as actuals on theses project.
So you can use tools form the project accounting module to get some insights in time entires and for aggregation I would recommend to activate the Project accounting cube within the entity store. Here you get a basic tabular datawarehouse covering all projects and subproject, actuals, forecasts, ... as well as time dimension for your analytics.
Furthermore you can extend the project acoounting cube as well as the Power BI report to fullfill your reporting requirements.
Within in the Asset management itself there is also the /inqueries/Work Order/Work order hour control/ form which also covers some aggregations including date dimension. Did you try to use this one?
Hope this helps
Herzliche Grüße / kind regards,
Andreas Raithel
D365FO Solution Architect