It's all about the answers!

Ask a question

Variable dates in Report Studio DW


Sandra Walker (623) | asked Jul 08 '14, 4:41 a.m.
I want a metrics report on total work item creation by type  on a given day in an iteration. I am using the Request Creation Metric -> Creation Date. I can filter on date by explicitly selecting dates and this gives me a filter that looks like

[Date] in ([Request Creation Metrics].[Creation Date].[Date].[Year]->[all].[2014])

What I want is to be able to pass in the dates for the iteration using ?startDate? and ?endDate? but using the the format that I would typically use for ODS gives me an error

Note that using nesting with iteration and date won't work for me as I am trying to track items that have been created both before and after (sic) the iterations date so I want to select the iteration's dates and then add some tolerance

Be the first one to answer this question!


Register or to post your answer.


Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.