I’d like to filter the logged hours (Hours Spent) and the Tempo billed hours measures based on the worklog created time value, but if I use the Time in the pages, then it filters the Original estimate measures as well which I also have to show in my table.
Could you share some tricks, how to filter only the Hours Spent and the Tempo billed hours measurements?
The measure “Original estimated hours” is tied to the Time dimension the same way the “Hours spent” and “Tempo billed hours” are. The value of the estimate is displayed in the Time dimension period when the issue was created. In most cases, that period can be different from the one the work was logged.
To overcome this, try to reset the Time dimension context for the “Original estimated hours” measure. Try the formula below: