Issues Resolved not coming under correct time

[zane.baranovska]

Hi @simarpreet_singh,

This particular custom field “Hour of Day created” represents the hour of creation time regardless of used measure in the report.

If you would like to represent resolved issues based on the hour of the resolution time using the same dimension, you might want to create another JavaScript calculated custom measure (JavaScript calculated custom fields).

1. Deselect custom field “Hour of Day created” from data import and import data. This is necessary so you could apply the changes to the advanced settings.

2. In advanced settings, add one more line to the custom field “Hour of Day created” definition:
   separate_table = true

3. Define another JavaScript calculated custom field that would count resolved issues and map them to the dimensions “Hour of Day created” and “Time” by resolution time.
   For custom field add advanced settings parameter
   multiple_dimensions=["Time","Hour of Day created"]
   And make sure to return the JavaScript result in the format <date>,<resolution hour>,<counter for issue>. For example, “29.04.2020,18,1”.

More details on custom field advanced settings separate_table, multiple_dimensions are here: Advanced settings for custom fields.

There is the related topic on how to build custom dimension “Hour of Day Created”:

Generate count of issues created per day and per hour

Hi, You can have the number of issues created per day by adding the Time dimension and expand all the members to the day level. The default measure Issues created is mapped to the time dimension by the issue creation date: [image] The solution for the hours’ breakdown would require the use of the advanced settings since the hour is not a standard dimension of the eazyBI data model. You may try the following settings and import the Hour of Day Created field from the data import screen as a n…

Best,
Zane / support@eazyBI.com