The report screenshot matches the request: the first column shows without time repeating, then two following measures Remaining estimate history and Effort Spent history is split by time.
Could you clarify if this the report you could create based on the suggestion, but there is still something missing or you could create this only using some formulas? Some additional details will help us give a more precise answer.
In any case, here are more details on how I could create a similar report with default measures Hours spent and Remaining estimated hours history, and property Issue assignee. Here are the steps I did to get it working:
- Select the Hours spent and use the option drill into > Time and select All times (or a specific level, for example, weeks).
leave the time dimension as is it for now - we will set the needed selection on the last step. - select the Remaining estimated hours history and use the option drill into > Time and select the same selection as for the first one (All times or level).
- Then expand the Time dimension on the Column and make the needed selection. For example, select Last 4 weeks. Expand it in the report and then deselect the last 4 weeks leaving the expanded weeks only.
You can make any time selection here. The only limitation is - you can’t use the same dimension on Pages for selection.
Here is my report:
Daina / support@eazybi.com