I would like to show a report that compare between last week and this week

[Bala]

A dashboard should show last week report and this week automatically (i can't edit my filter every time) 

Please help

[Thomas Schlegel]

Hi @Bala,

what kind of data do you exactly want to show?

[Bala]

1) How many numbers of issues created last week and this week.

2) how many tickets are reopened. 

3) how many tickets are raised in particular project.

and many :) 

[Thomas Schlegel]

You can't query the number of issues, you can just query issues.

But you can do something similar with gadgets. First create these queries and save them

- created > startOfWeek(-7d) and created < startofweek()  

     save this as "issues created last week"

- created > startOfWeek()

     save this as "issues created this week"

- created > startOfWeek(-7d) and created < startofweek()   and project = abc

     save this as "issues created last week in project abc"

- created > startOfWeek() and project = abc

     save this as "issues created this week in project = abc"

- status changed to reopened after startofWeek(-7d)

     save this as "reopened tickets in the last week" 

- status changed to reopened after startofWeek()

     save this as "reopened tickets this week" 

Then create a dashboard, add gadgets which display the issues of your JQL as table or chart. Both are showing also the current number of issues.