History of asset status per month

Hi, I’m trying to get the summary history information for each asset per month, current we run a query against the fact_asset table every day and export it but it doesn’t have the history before we started exporting. I found this feature in the documentation but it doesn’t work, does anybody know how to get this information, here’s what I tried: SELECT * FROM fact_asset_date(‘2022-01-01’,‘2023-01-01’,INTERVAL ‘1 month’)
WHERE asset_id=12345