Gantt chart help

Hi, Im referring to this example here https://docs.eazybi.com/eazybijira/learn-more/learn-eazybi-through-examples/gantt-chart

and Specifically this code section here to create the coloured bars.

CASE WHEN
[Measures].[Issues created] > 0
THEN
[Measures].[Issues resolved]
/
[Measures].[Issues created]
END

Qn 1) At which % threshold does the green/red/blue colours appear?

Qn 2) Why does the Calculated field as per formula above show as blank even when I have at least One issue per epic?

eg of my measures below
image

Hi @admin01,

Thank you for joining the eazyBI community.

Regarding your first question about colors

  • green - completed tasks, from the percentage in the field “Issue resolved%”;
  • red - overdue tasks. Displays the remainder of the percentage if the “End date” is past the current date. For example, let’s take the “Issues resolved %” value 67% - 67% of the will be colored green, and the rest 23% will be red because the “End date” is already in the past and it is considered over-due;
  • blue - upcoming tasks, milestones and completed tasks without completion ratio;
  • grey - a group of tasks.

Please read more about this on our documentation page - https://docs.eazybi.com/eazybijira/analyze-and-visualize/create-charts#Createcharts-Ganttchart

"Issues resolved %" blank
The values are probably blank because there are no issues resolved - the measure “Issues resolved” is empty for the Epic and thus the calculation returns empty values. If you want the calculation to display zeros for those values, you can add the CoalesceEmpty() function. Please read more about it on our documentation page - https://docs.eazybi.com/eazybi/analyze-and-visualize/calculated-members/mdx-function-reference/coalesceempty.

Best,
Roberts // eazyBI support