Assistance with counting based on value and populating calculated measure to identify range

Questions & Answers
,
#1

I am new to this level of detail in eazyBI.
I have a user that requested a custom number filed with decimal. I would like to be able to determine the value of this field in order to count (add 1) to one of 3 fields to categorize into a range.
i.e. if (issue customfield) is not empty and value is between 0 and 3 , add one to range_low
if (issue customfield) is not empty and value is between 3.1 and 6 , add one to range_med
if (issue customfield) is not empty and value is between 6.1 and 10 , add one to range_high
I would then use the 3 calculated range fields on a chart

Could someone please help me figure out how to accomplish this in eazyBI?

TIA

#2

Hi,

The best way to implement this use case is to create a custom interval dimension from this numeric field. You need to add to the advanced settings the lines like this:

[jira.customfield_NNNNN]
data_type="decimal"
dimension=true
intervals="10"

Note to use the correct custom field ID instead of the NNNNN.
After you import the custom field as a dimension, you will be able to adjust the intervals by which you wish to count the issues.

Kindly,
Janis, eazyBI support

#3

Thank you Janis,

This is what we have done and it seems to be the solution. The customer is happy with the results.

Thanks again, Ruth