i need a report to show the evolution by day of the sum of all time estimates for issues in certain stages.
The problem is issues change stages over time. I need a report to show original estimate for an issues per stages that they were X days ago.
So far, I am able to calculate the sum of time for issues in certain stages as they are today (10 jul 2020). Tomorrow some issues will change stage and the calculation will be different for 10 jul 2020.
When using history measures with Time dimension, history measures show the value at the end of the selected period (day, week, month, etc.).
In case, you would like to represent values by some specific date, like Due date, then you may define a new calculated measure to overwrite the logic of how data are related to the Time dimension. There are some use cases: