Sprint Burn down using Dashboards.

[jonatan.goebel]

Hello

I am trying to build a Sprint Burn Down inside Enterprise Architect, but I am unable to find how to build a time series chart with a sum of a specific property instead of a total of found elements.

For now, I have a Tagged Value to store the estimated story points of each userStory. I do know how to get this property with Custom SQL and cast it to Int, but the result is always returned as a Count.

Does any one knows alternative ways to build the Burn-Down that consider the story points of each user story?

Thanks

[Mauricio Moya (Arquesoft)]

Two approaches:

1) Avoid automatic calculation of timeseries chart (which only works when having Cloud Server), and manipulate the data of the chart via a custom script that calculates your data and stores it in the suitable tag value of the timeseries chart (the data is stored as an XML). Just a programming solution.

2) Use some query that returns as rows as the value of your current dot in the graph. For example, the following SQL returns 10 rows (change the 10, and return different number of rows). Works in SQLServer:

Code: [Select]

SELECT TOP(10) 'true'
FROM sys.columns AS a CROSS JOIN sys.columns AS b

[jonatan.goebel]

Thanks for your reply.

I will use your first tip and define the manual process at the organizational process.

About the query, our database uses Postgresql, so it has 'limit' instead of 'TOP()' option. Unfortunately, the 'limit' options do no accept an expression as argument, so the cross join strategy do not work.

But googling about your alternative I found a solution using 'generate_series', here is my query for future readers:

Code: [Select]

select L from generate_series(1, (
select SUM(CAST(op.Value as Int)) from t_object
INNER JOIN t_package ON t_package.Package_ID = t_object.Package_ID
inner join t_objectproperties op on op.Object_ID = t_object.Object_ID
where op.Property = 'Scrum::storyPoints'
AND t_object.Object_Type = 'Task'
AND t_object.Phase != 'Done')
) L


[Mauricio Moya (Arquesoft)]

If you use Cloud Server (it is free and very easy to install), the Cloud Server can generate periodically the points of the graph if you use the second alternative and your query strategy for postgres. If I were you, I would use the query.