Hi, we wanted to have an overview of the month wise issue count based on the "Start Date" in the tasks. Basically, a bar chart or simply Month & Count in a table view side-by-side.
Is this possible with native Jira dashboard gadgets?
Example of the output required -
Hi @Utsav Kothari ,
Unfortunately, I don't think you'll manage to get this with native gadgets. Atlassian Analytics can most likely do this and I've also tried to construct this with Home Dashboards but with no luck 👀
I have something like this constructed on a couple of sites, but we're mainly talking about Marketplace apps.
What I'd recommend trying is Apps feature in Rovo Studio. A couple of users said they've managed to build a custom widget (powered by Forge) by simply prompting Rovo and stating what they need. 👈
Cheers,
Tobi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Analytics, you could try, but then you need an Enterprise subscription to use the feature.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
This is probalply a possibility with the 2 dimensional ootb filter gadget, if you try to use a work around, the you set a text field, with month based on start date with an automation.
You could use smart value like {{issue.customfield_xxxxx.format("MMM")}} , where xxxxx is the id of the field, trigger the automation based on field change of the field start date or issue creation of start date is set on creation or both.
Otherwise if this is not the way you want to take, you will need to revert to 3rd party marketplace solutions
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Would it be possible to share the code used for rovo to built such a widget?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hi @Marc -Devoteam- ,
I'm unable to attach the file here, but here is the prompt I gave to Rovo Studio:
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
If you are open to try out a mktplace app, I can suggest the one we have built for the same use case.
The app allows you to build interactive Jira dashboards with powerful charts, gadgets, and reports. Visualize issue progress, team workload etc
There are multiple configuration and customization options which the apps provides. You can easily get the story points / time spent for each assignee and many other data points .Some of the sample charts are as below.
Disclaimer : I am part of the team which developed this app
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello @Utsav Kothari,
I am Marlene from the team behind Quick Filters for Jira Dashboards.
As mentioned before, Jira's native gadgets currently don't support creating this type of time series based on the Start date field.
If you are open to try a Marketplace App, you can check out Quick Filters for Jira Dashboards. With the Advanced edition of Quick Filters for Jira Dashboards, you can build time series on any Jira number or date field, including Start date.
As an alternative, you could also use the Quick Bar Chart gadget and define each bar with a JQL query, for example:
Last month: "Start date" >= startOfMonth(-1) AND "Start date" < startOfMonth()
Two months ago: "Start date" >= startOfMonth(-2) AND "Start date" < startOfMonth(-1)
Three months ago: "Start date" >= startOfMonth(-3) AND "Start date" < startOfMonth(-2)
...and continue this pattern for additional months as needed.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @Utsav Kothari
You're right that there isn't a native gadget that buckets issues by the month of a date field out of the box. Two native-leaning routes:
- Automation plus a gadget: use an automation rule to write the month into a short text field whenever Start Date is set or changes, with a smart value like `{{issue.Start date.format("MMM")}}` (use `"yyyy-MM"` if you want to keep years distinct). Then point a Pie Chart or Two Dimensional Filter Statistics gadget at that field to get the month-by-count breakdown.
- Atlassian Analytics can probably produce this kind of chart directly, though I haven't verified it for this exact case, and it requires a Cloud Enterprise subscription.
The automation approach is the most accessible if you're not on Enterprise. The one caveat is that the field only fills in going forward, so you'd want to bulk-trigger the rule once over your existing issues to backfill them.
Cheers,
Martin
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
One more option if you'd like the breakdown without maintaining an extra field.
If you're open to a Marketplace app, JXL for Jira (built by the team I work on) gives you a spreadsheet-style view where a formula column can derive the month from Start Date, and then you group by that column. Each group header shows its issue count, so you get the Month and Count layout you sketched without a custom field or automation. If you later want totals per month (story points, time, and so on) you can add sum-up columns to the same groups.
Disclosure: I work on the team behind JXL.
Best,
Martin
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.