Retrieve dynamic daily report

[Arthur Harutyunyan]

Hey all,

I have a dashboard called "Daily Report" and I have attach several projects there to get the current day status. See the screenshot. A simple filter is used behind. 

project = xxx and statusCategoryChangedDate >= startOfDay() AND statusCategoryChangedDate < endOfDay()

Now I want to enhance this dashboard, to be able to get this kind of report for a selected day. Lets say, to add a date picker on the dashboard, and select date range.

Please kindly help me guys, to have this helpful report ;)

Thanks in advance

Arthur

[Arthur Harutyunyan · Accepted solution]

Please let me know if anybody knows how to solve it without paying :)

[Arthur Harutyunyan · Accepted solution]

Thanks to all of you guys, but Im looking for a free solution of this use-case

[Marlene Kegel - codefortynine]

Hi @Arthur Harutyunyan

Your use case is possible with our Jira cloud app Quick Filters for Jira Dashboards.

This is how you could create your dynamic dashboard with Quick Filters:

• Add the "Quick Controller" and the "Quick Pie Chart" gadget to your dashoard
• Add Filter "statusCategoryChangedDate" to the Quick Controller
• Select "Dropdown"
• In the Quick Pie Chart gadget select the global filter you want to get the issues from

With this setup it is possible to filter dynamically for changes that happened at a certain date (see screenshot).

If you have further questions or feedback, don't hesitate to get in touch with our support. 

[Arthur Harutyunyan]

Hi, removing this from my app's list. Does not satisfy my needs. I think the use-case is clearly described.

[Marlene Kegel - codefortynine]

If you have an idea how we could enhance Quick Filters for Jira Dashboards to fit your needs, please let us know.

We're still working on updates and your feedback is very welcome, @Arthur Harutyunyan !

[Hernan Halabi - Elite IT Consulting Group]

Hello @Arthur Harutyunyan take a look to eazybi app. You can create the same reports and make use of eazybi dashboard that allows you to have global variables, in this case the dates. So you can change the date at the dashboard level and all your reports will be updated based on that criteria

[Jack Brickey]

you can't include a dynamic field filter to the dashboard OOTB. Consider tying into MS PowerBI or an addon e.g. rich-filters-for-jira-dashboards 

Note: I don't use either of these at this time. just passing along info i'm aware of so I suggest you do your homework and choose what fits your needs.