How to create a histogram

Hello,

I have a simple table (dimension, measure) and I want to create a histogram of values on the measure, to understand data distribution.

Any ideas?

Thanks

Hello David,

eazyBI by default imports any numeric value as a measure you will get total value from this custom field. Histogram chart should represent a count of issues with particular numeric value and split by another dimension.

You would like to import your numeric custom field as a dimension or interval dimension into eazyBI to see how issues are split by particular values.

Here is an example custom field definition that enables importing this custom field as a dimension (interval dimension):

[jira.customfield_NNNNN]
data_type = "integer"
measure = true
dimension = true
intervals = "/10"

Please update the definition above using custom field ID instead of NNNNN.
The last line intervals = “/10” will create this dimension as an interval dimension with step 10. Please remove the line if you would like to split data by exact custom field values.
Please see more information about intervals though:
https://docs.eazybi.com/display/EAZYBI/Interval+dimensions

Then you can build a chart with this new numeric/interval dimension and your another dimension together with default measure Issues created. This will show you how issues are distributed by this numeric custom field and another custom field dimension.

In my example, I imported Story Points as interval dimension with step “3,7”. I used this new Story Points dimension and T-Shirt Size dimension to see a distribution of data.

Daina / support@eazybi.com

Hello Diana,

I am looking for something similar, but with the issue resolution time as the intervals.

So Issue count as in your screenshot and the intervals are for example something like 0-10 days, 11-20 days, 21-30 days etc.

How could that be achieved?

Even nicer would be a histogram with the density instead of issue count, so like between 0 and 1 and for example 0,5 at interval 11-20 would mean 50% of all issues have a resolution time between 11 and 20 days.
But assume that is harder or maybe not possible?

Big thank you in advance.

BR, Markus

eazyBI has a default Resolution interval dimension. The dimension is not imported automatically, you would like to select it for an import explicitly.

Here are a couple of reports in our demo account using Resolution interval dimension:
Issue Resolution Intervals (Lead Time)
Issue Resolution Days (Lead Time)

Daina / support@eazybi.com

Hello Diana,

waow that is really great, thank you very much.

I took the Issue Resolution Intervals (Lead Time) - it works really good.

One question:
Is there a way to create a measure that shows the percentagte of issues resolved (similar to the issue resolved count)?
So something like
[Measures].[Issues resolved] /
…? And this would maybe be something like sum issues resolved of all resolution time intervals? or maybe there is a better way?

Best regards,
Markus

Edit:
Or is it maybe possible with a second cumulative line like this?:
https://images.app.goo.gl/gAHCX2fawP55iawRA

Hi Diana,

not sure if I created the two replies in the correct tree.
Do you maybe have a short feedback on the additional question?
That would be great, even if it is not possible would help, then we at least know for sure.

Big thank you in advance.

Best regards,
Markus

Since eazyBI version 5.0, we added an option to Add calculated measures. In this case, you can add a % of total to see % of each Cumulative sum as well.

Daina / support@eazybi.com

Hello Diana,

that is great thank you very much.
A good reason to upgrade as soon as possible for us (at the moment we are on 4.7.2)

Thank you again.

Best regards,
Markus