Hello,
Does anyone know which is the best chart to use if you need to factor the median of Jira tickets count? I only see the average as an option.
thank you
Hi @claressa_wallace
I think you would need to create a custom SQL query in Analytics for the median use-case.
Ok, thank you Ajay. I will look into creating that.
Hi Claressa, there’s a native chart option worth adding here: Box plot. Atlassian Analytics supports it, and it shows the median along with the quartiles and range.
For a median ticket count, first decide what each count represents—for example, tickets created per day, per week, or per assignee.
If you mean median tickets created per day, you can build this in the visual query editor:
That gives the distribution and median of the daily counts. For example, daily counts of 2, 3 and 20 have a median of 3.
Atlassian documents the supported input format and median display here (see “Box plot”): https://support.atlassian.com/analytics/docs/chart-types/
There’s also a Median option in the Aggregation guided formula if you want to add the calculated median to your result table: https://support.atlassian.com/analytics/docs/guided-formulas/
A handwritten SQL query isn’t required for that calculation.
It looks like you're new here. Sign in or register to get started.