Date Comparison Grid

[DEGAN]

Hi,
Date Comparison Grid.

I’m trying to make a date comparison table between months, basically I have to compare the DAY x the MES:
On the 1st of the month 01 has a metric = 5
On the 1st of the month 02 there is another Metric = 7
For the management to make the comparison.

An explanation is attached:

[gerda.grantina]

Hi @DEGAN ,
You can explore JavaScript custom dimension and adjust code that is used here to get “Hours of the Day”:

Generate count of issues created per day and per hour

I am trying to generate two graphs/charts 1.I would like to see a count of the number of issues created per day 2. I would like to see a graph that shows me an hourly breakdown (for the month) of the time of day tickets are created. (I am trying to determine when is the busiest time of day) I am not having any luck creating either one of these. For #1 I tried to use issues created count in combination with the issue create date measure and I am unable to figure out how to do this. Any sugge…

The JavaScript code would be like this:

[jira.customfield_day_of_month_created]
name = "Day of Month Created"
data_type = "integer"
dimension = true
javascript_code = '''
var DaysCreated = new Date(Date.parse(issue.fields.created)).getDate();
issue.fields.customfield_day_of_month_created = DaysCreated;'''

In the report it looks like this:

But keep in mind that with this approach you can get only a particular event - in this case when the issue was created and it won’t be linked to other measures in your account.

To see data for the previous month you can also explore standard calculations → time ago Create reports

best,
Gerda // support@eazyBI.com

[DEGAN]

hank you very much for the feedback,

It helped me a lot, now I’m just trying to change the metric from created to resolved, but it’s giving an error, thank you very much anyway.
Here’s the model I’m using for resolved:

[jira.customfield_day_of_month_resolved]
name = “Day of Month resolved”
data_type = “integer”
dimension = true
javascript_code = ‘’’
var Daysresolved = new Date(Date.parse(issue.fields.resolved)).getDate();
issue.fields.customfield_day_of_month_resolved = Daysresolved;’’’

[gerda.grantina]

Hi @DEGAN ,
You are close to the solution, but you need to use ‘issue.fields.resolutiondate’:

[jira.customfield_day_of_month_resolved]
name = "Day of Month Resolved"
data_type = "integer"
dimension = true
javascript_code = '''
var DaysResolved= new Date(Date.parse(issue.fields.resolutiondate)).getDate();
issue.fields.customfield_day_of_month_resolved = DaysResolved;
'''

To see available issue fields, you can check JSON in eazyBI import options:

Also, see in eazyBI documentation other tips on how to test your JavaScript customfield: JavaScript calculated custom fields - eazyBI for Jira

best,
Gerda // support@eazyBI.com

[DEGAN]

Hi,

Thank you very much for the feedback, it helped me a lot.

Thank you so.