Suggestions for the Customised Dashboard to automatically fetch the data.

[MANASA B N]

Hello Team,

       We need some suggestions to create the customised JIRA Dashboards. Currently, we have created multiple filters with the date range for the December month. We dont want to create those filters again for the month of January. 
Could you please suggest some automation for this.

[Jack Brickey · Accepted solution]

Hi @MANASA B N , can you share an example filter? Generally you should use the "startofmonth()" time function or similar JQL time function. 

example...

project = abc and created >= startofmonth()

project = abc and resolved >= startofmonth()

you can also consider a relative offset using the startofyear() to get a specific month, e.g. startofyear(2) for February.

[Jack Brickey]

You might find this page useful - jql-functions 

[MANASA B N]

Instead of changing in the filter, cannot we have this option in a dashboard itself, so that we can switch to the desired month data.

[Łukasz Modzelewski _Lumo_ · Accepted solution]

Hi @MANASA B N , welcome to the Atlassian Community!

Maybe you just should change your dates from hard coded to functions like 

• endOfMonth() / startOfMonth()

Check documentation: https://support.atlassian.com/jira-software-cloud/docs/jql-fields/#Due

and community thread: https://community.atlassian.com/t5/Jira-questions/JQL-for-current-month/qaq-p/825835 

[MANASA B N]

Instead of changing in the filter, cannot we have this option in a dashboard itself, so that we can switch to the desired month data.

[Łukasz Modzelewski _Lumo_]

Can you provide an example of the filter you're using and a screenshot (blur any confidential data)? There are multiple gadget options available, so this will help me better understand the desired outcome. I’d like to experiment and see if this can be solved using a Forge app. :)