[AOE] Every workbook using a costs lookback period should consider the 3-days costs ingestion offset

⚠️ Problem

Some AOE Workbooks, such as the Benefits Simulation, Reservations Potential, Reservations Usage and others, have a costs lookback period that is set as 30 days by default. However, as the engine has a default 3-days offset for ingesting costs, the workbooks always base their results in a shorter lookback period (e.g., 27 days for a selected period of 30 days). NOTE: the ingestion offset is set as an Azure Automation variable that cannot be read from the workbooks.

🛠️ Solution

The aforementioned workbooks should add a disclaimer or even a costs offset parameter that would add the offset time range to the lookback period, so that users get more accurate results.

🙋‍♀️ Ask for the community

We could use your help:

1. Please vote this issue up (👍) to prioritize it.
2. Leave comments to help us solidify the vision.

Start by reviewing the Benefits Simulation, Reservations Potential, and Reservations Usage workbooks and how their 30-day costs lookback is configured. Confirm how the 3-day ingestion offset affects each workbook, then clarify whether the accepted outcome is a disclaimer or an offset parameter; done means the affected workbooks consistently account for the offset.