Forum Discussion
user story and task rollups
Not sure if this is the right forum, but here is the issue: I am tryin to create a sioimple report which shows all client costs (charges) to date. I am using one view table from TFS_Warehouse (on-p...
v-jiascu-msft, let's give this a shot: https://1drv.ms/u/s!AkgfL6evUx7Jebx0NKgun4atOBI It's the template to reduce the file size. If data is needed, I can cleanse it and upload. Much appreciated.
v-jiascu-msft
Microsoft Employee
Microsoft EmployeeI will try to share it out form a different source - https://drive.google.com/file/d/0B1yTINZv_mcEQmkyMGpOX1U5WHM/view?usp=sharing
- v-jiascu-msft
Hi spsalter,
1. I created a new date table.
Calendar = CALENDAR ( DATE ( 2016, 1, 1 ), DATE ( 2019, 12, 31 ) )
2. A new column of table CurrentWorkItemView.
RelationshipDate = [System_CreatedDate].[date]
3. Establish relationship through CurrentWorkItemView[RelationshipDate] and Calendar[Date].
Could you please make more clear about "child tasks", "the client is tagged", "user story"? Because I can't find it in the model.
You can check it out in your private message.
Best Regards!
Dale