Display data of tickets created last month on weekly basis.

[Neeta Dubey]

Hi All,

I need simple help in updating my dashboards which displays data on weekly basis for current month and last month and if possible on quarterly basis. The data should update automatically.

I was able to get desired filter for current month, however when i try for last month, my filter gives me of data of last month + current month.

This is the query I have of my last month also. Graph shows same number of weeks for current month as well as last month.

Query for last month data: 

project = "myprojectname" AND created < endOfMonth(-1) AND created >=startOfMonth(-1) ORDER BY created ASC

[Danut M _StonikByte_]

Hi @Neeta Dubey ,

Try this for filtering the issues created last month: 

project = "myprojectname" AND created >= startOfMonth(-1) and created < startOfMonth() ORDER BY created ASC

Danut.