Histórico da Página

{replace-and-render}

//projeto
{replace-item:%projeto%}JBTRT4ADME{replace-item}

//sprint
{replace-item:%sprint%}Sprint 28{replace-item}

//data inicial
{replace-item}{replace-item}

//data final
{replace-item}{replace-item}

//usuario que trabalhou
{replace-item:%usuario%}marcelo.mariano{replace-item}

{replace-body}

{chart:type=barline|title=Burnup de teste|dataOrientation=vertical|subTitle=Acompanhamento da sprint com sql|dataOrientation=vertical|width=600|height=300|dataDisplay=false|yLabel=Projeto Concluído em %|xLabel=Em dias|3D=false|borderColor=black|colors=green,blueyellow,green|thumbnail=true}

|| Dias || Esperado || Pronto ||
| 01 | 6.66 | {sql-query:datasource=jiraDS|table=false|}
select ((select count(*) from jiraissue ji, project p, projectversion pv 
where ji.project =  pv.project
and pv.project = p.id
and p.pkey like('%projeto%')--nome do projeto
and pv.vname like('%sprint%')--nome da versao
and ji.issuestatus in('1'))*56.66/count(*)) as openstatus from jiraissue ji, project p, projectversion pv 
where ji.project =  pv.project
and pv.project = p.id
and p.pkey like('%projeto%')--nome do projeto
and pv.vname like('%sprint%')
and ji.issuestatus in('1','3','5')
{sql-query}
 |
| 02 | 13.32 | {sql-query:datasource=jiraDS|table=false|}
select ((select count(*) from jiraissue ji, project p, projectversion pv 
where ji.project =  pv.project
and pv.project = p.id
and p.pkey like('%projeto%')--nome do projeto
and pv.vname like('%sprint%')--nome da versao
and ji.issuestatus in('3'))*7013.32/count(*)) as openstatus from jiraissue ji, project p, projectversion pv 
where ji.project =  pv.project
and pv.project = p.id
and p.pkey like('%projeto%')--nome do projeto
and pv.vname like('%sprint%')
and ji.issuestatus in('1','3','5')
{sql-query} |
| 03 | 19.98 | {sql-query:datasource=jiraDS|table=false|}
select ((select count(*) from jiraissue ji, project p, projectversion pv 
where ji.project =  pv.project
and pv.project = p.id
and p.pkey like('%projeto%')--nome do projeto
and pv.vname like('%sprint%')--nome da versao
and ji.issuestatus in('3'))*7019.98/count(*)) as openstatus from jiraissue ji, project p, projectversion pv 
where ji.project =  pv.project
and pv.project = p.id
and p.pkey like('%projeto%')--nome do projeto
and pv.vname like('%sprint%')
and ji.issuestatus in('1','3','5')
{sql-query} |
| 04 | 26.64 | {sql-query:datasource=jiraDS|table=false|}
select ((select count(*) from jiraissue ji, project p, projectversion pv 
where ji.project =  pv.project
and pv.project = p.id
and p.pkey like('%projeto%')--nome do projeto
and pv.vname like('%sprint%')--nome da versao
and ji.issuestatus in('3'))*70/count(*)) as openstatus from jiraissue ji, project p, projectversion pv 
where ji.project =  pv.project
and pv.project = p.id
and p.pkey like('%projeto%')--nome do projeto
and pv.vname like('%sprint%')
and ji.issuestatus in('1','3','5')
{sql-query} |
| 05 | 33.33 | {sql-query:datasource=jiraDS|table=false|}
select ((select count(*) from jiraissue ji, project p, projectversion pv 
where ji.project =  pv.project
and pv.project = p.id
and p.pkey like('%projeto%')--nome do projeto
and pv.vname like('%sprint%')--nome da versao
and ji.issuestatus in('3'))*7026.64/count(*)) as openstatus from jiraissue ji, project p, projectversion pv 
where ji.project =  pv.project
and pv.project = p.id
and p.pkey like('%projeto%')--nome do projeto
and pv.vname like('%sprint%')
and ji.issuestatus in('1','3','5')
{sql-query} |
| 0605 | 3933.9633 | {sql-query:datasource=jiraDS|table=false|}
select ((select count(*) from jiraissue ji, project p, projectversion pv 
where ji.project =  pv.project
and pv.project = p.id
and p.pkey like('%projeto%')--nome do projeto
and pv.vname like('%sprint%')--nome da versao
and ji.issuestatus in('3'))*7033.33/count(*)) as openstatus from jiraissue ji, project p, projectversion pv 
where ji.project =  pv.project
and pv.project = p.id
and p.pkey like('%projeto%')--nome do projeto
and pv.vname like('%sprint%')
and ji.issuestatus in('1','3','5')
{sql-query} |
| 0706 | 4639.6296 | {sql-query:datasource=jiraDS|table=false|}
select ((select count(*) from jiraissue ji, project p, projectversion pv 
where ji.project =  pv.project
and pv.project = p.id
and p.pkey like('%projeto%')--nome do projeto
and pv.vname like('%sprint%')--nome da versao
and ji.issuestatus in('3'))*7039.96/count(*)) as openstatus from jiraissue ji, project p, projectversion pv 
where ji.project =  pv.project
and pv.project = p.id
and p.pkey like('%projeto%')--nome do projeto
and pv.vname like('%sprint%')
and ji.issuestatus in('1','3','5')
{sql-query} |
| 0807 | 5346.2862 | {sql-query:datasource=jiraDS|table=false|}
select ((select count(*) from jiraissue ji, project p, projectversion pv 
where ji.project =  pv.project
and pv.project = p.id
and p.pkey like('%projeto%')--nome do projeto
and pv.vname like('%sprint%')--nome da versao
and ji.issuestatus in('3'))*7046.62/count(*)) as openstatus from jiraissue ji, project p, projectversion pv 
where ji.project =  pv.project
and pv.project = p.id
and p.pkey like('%projeto%')--nome do projeto
and pv.vname like('%sprint%')
and ji.issuestatus in('1','3','5')
{sql-query} |
| 0908 | 5953.9428 | {sql-query:datasource=jiraDS|table=false|}
select ((select count(*) from jiraissue ji, project p, projectversion pv 
where ji.project =  pv.project
and pv.project = p.id
and p.pkey like('%projeto%')--nome do projeto
and pv.vname like('%sprint%')--nome da versao
and ji.issuestatus in('3'))*7053.28/count(*)) as openstatus from jiraissue ji, project p, projectversion pv 
where ji.project =  pv.project
and pv.project = p.id
and p.pkey like('%projeto%')--nome do projeto
and pv.vname like('%sprint%')
and ji.issuestatus in('1','3','5')
{sql-query} |
| 1009 | 6659.6094 | {sql-query:datasource=jiraDS|table=false|}
select ((select count(*) from jiraissue ji, project p, projectversion pv 
where ji.project =  pv.project
and pv.project = p.id
and p.pkey like('%projeto%')--nome do projeto
and pv.vname like('%sprint%')--nome da versao
and ji.issuestatus in('3'))*7059.94/count(*)) as openstatus from jiraissue ji, project p, projectversion pv 
where ji.project =  pv.project
and pv.project = p.id
and p.pkey like('%projeto%')--nome do projeto
and pv.vname like('%sprint%')
and ji.issuestatus in('1','3','5')
{sql-query} |
| 1110 | 7366.2660 | {sql-query:datasource=jiraDS|table=false|}
select ((select count(*) from jiraissue ji, project p, projectversion pv 
where ji.project =  pv.project
and pv.project = p.id
and p.pkey like('%projeto%')--nome do projeto
and pv.vname like('%sprint%')--nome da versao
and ji.issuestatus in('3'))*7066.6/count(*)) as openstatus from jiraissue ji, project p, projectversion pv 
where ji.project =  pv.project
and pv.project = p.id
and p.pkey like('%projeto%')--nome do projeto
and pv.vname like('%sprint%')
and ji.issuestatus in('1','3','5')
{sql-query} |
| 1211 | 7973.9226 | {sql-query:datasource=jiraDS|table=false|}
select ((select count(*) from jiraissue ji, project p, projectversion pv 
where ji.project =  pv.project
and pv.project = p.id
and p.pkey like('%projeto%')--nome do projeto
and pv.vname like('%sprint%')--nome da versao
and ji.issuestatus in('53'))*7073.26/count(*)) as openstatus from jiraissue ji, project p, projectversion pv 
where ji.project =  pv.project
and pv.project = p.id
and p.pkey like('%projeto%')--nome do projeto
and pv.vname like('%sprint%')
and ji.issuestatus in('1','3','5')
{sql-query} |
| 1312 | 8679.5892 | {sql-query:datasource=jiraDS|table=false|}
select ((select count(*) from jiraissue ji, project p, projectversion pv 
where ji.project =  pv.project
and pv.project = p.id
and p.pkey like('%projeto%')--nome do projeto
and pv.vname like('%sprint%')--nome da versao
and ji.issuestatus in('5'))*7079.92/count(*)) as openstatus from jiraissue ji, project p, projectversion pv 
where ji.project =  pv.project
and pv.project = p.id
and p.pkey like('%projeto%')--nome do projeto
and pv.vname like('%sprint%')
and ji.issuestatus in('1','3','5')
{sql-query} |
| 1413 | 9386.2458 | {sql-query:datasource=jiraDS|table=false|}
select ((select count(*) from jiraissue ji, project p, projectversion pv 
where ji.project =  pv.project
and pv.project = p.id
and p.pkey like('%projeto%')--nome do projeto
and pv.vname like('%sprint%')--nome da versao
and ji.issuestatus in('5'))*7086.58/count(*)) as openstatus from jiraissue ji, project p, projectversion pv 
where ji.project =  pv.project
and pv.project = p.id
and p.pkey like('%projeto%')--nome do projeto
and pv.vname like('%sprint%')
and ji.issuestatus in('1','3','5')
{sql-query} |
| 1514 | 10093.24 | {sql-query:datasource=jiraDS|table=false|}
select ((select count(*) from jiraissue ji, project p, projectversion pv 
where ji.project =  pv.project
and pv.project = p.id
and p.pkey like('%projeto%')--nome do projeto
and pv.vname like('%sprint%')--nome da versao
and ji.issuestatus in('5'))*7093.24/count(*)) as openstatus from jiraissue ji, project p, projectversion pv 
where ji.project =  pv.project
and pv.project = p.id
and p.pkey like('%projeto%')--nome do projeto
and pv.vname like('%sprint%')
and ji.issuestatus in('1','3','5')
{sql-query} |
| 15 | 100 | 0 |
{chart}


Eis aqui um exemplo de o que é para acontecer no gráfico com os percentuais de execução em cada dia de uma sprint de 15 dias.

    * primeiro dia deve, mostra o percentual de issues com status 'Open'.
    * segundo dia em diante deve mostrar o percentual de issues com status 'InProgress' até 70% do projeto.
    * entre 70% e 95% mostra o percentual de issues com status 'Resolved' até 95%.

{replace-body}
{replace-and-render}