I filter by time and lose the % of progress

Questions & Answers
,
1

Dear community,

I have a problem with a filter that I added to a report, the filter is based on a jira field called “Annual goal”.

If I don’t filter anything by that field, it shows my percentages of progress of the projects and the blocks, but when I filter by the year 2024 or 2025 it no longer shows the % of progress. Can you help me solve this please? I attach screens and code for the “% de avance (% of progress)” and “Objetivos anuales (Annual goal)”.

filtro objetivos2
filtro objetivos2878×492 25.1 KB

filtro objetivos1
filtro objetivos11647×618 176 KB

filtro objetivos
filtro objetivos1880×677 224 KB

Code of “% de avance”

–annotations.group = Global

CASE

– Avance Epica
WHEN [Measures].[Issue type] = “Epic” and [Measures].[Issue Epic Type] = “Epica L”
THEN
CoalesceEmpty((
(([Measures].[Issues created],[Issue Type].[Task],[Status].[Done],[Salud].CurrentHierarchy.DefaultMember,[Assignee].CurrentHierarchy.DefaultMember,[Código de proyecto].CurrentHierarchy.DefaultMember,[VP/Direccion].CurrentHierarchy.DefaultMember,[Gerente Owner].CurrentHierarchy.DefaultMember)
+
(([Measures].[Issues created],[Issue Type].[Task],[Status].[In Progress],[Salud].CurrentHierarchy.DefaultMember, [Assignee].CurrentHierarchy.DefaultMember,[Código de proyecto].CurrentHierarchy.DefaultMember,[VP/Direccion].CurrentHierarchy.DefaultMember,[Gerente Owner].CurrentHierarchy.DefaultMember)*0.5))
/
([Measures].[Issues created],[Issue Type].[Task],[Status].[Sin Dismissed],[Salud].CurrentHierarchy.DefaultMember, [Assignee].CurrentHierarchy.DefaultMember,[Código de proyecto].CurrentHierarchy.DefaultMember,[VP/Direccion].CurrentHierarchy.DefaultMember,[Gerente Owner].CurrentHierarchy.DefaultMember)),0)

WHEN ([Measures].[Issue type] = “Epic” and [Measures].[Issue Epic Type] <> “Epica L”)
THEN
CoalesceEmpty((
(([Measures].[Issues created], [Issue Type].[Standar Issues],[Status].CurrentHierarchy.DefaultMember,[Status].[Done],[Salud].CurrentHierarchy.DefaultMember,[Assignee].CurrentHierarchy.DefaultMember,[Código de proyecto].CurrentHierarchy.DefaultMember,[VP/Direccion].CurrentHierarchy.DefaultMember,[Gerente Owner].CurrentHierarchy.DefaultMember)
+
(([Measures].[Issues created],[Issue Type].[Standar Issues],[Status].CurrentHierarchy.DefaultMember,[Status.Category].[In Progress],[Salud].CurrentHierarchy.DefaultMember,[Assignee].CurrentHierarchy.DefaultMember,[Código de proyecto].CurrentHierarchy.DefaultMember,[VP/Direccion].CurrentHierarchy.DefaultMember,[Gerente Owner].CurrentHierarchy.DefaultMember)*0.5))
/
([Measures].[Issues created],[Issue Type].[Standar Issues],[Status].CurrentHierarchy.DefaultMember,[Status].[Sin Dismissed],[Salud].CurrentHierarchy.DefaultMember,[Assignee].CurrentHierarchy.DefaultMember,[Código de proyecto].CurrentHierarchy.DefaultMember,[VP/Direccion].CurrentHierarchy.DefaultMember,[Gerente Owner].CurrentHierarchy.DefaultMember)),0)

– Avance Issue type proyecto
WHEN [Measures].[Issue type] = “Proyecto” and [Measures].[Issue Epic Type] = “Proyecto”
THEN
CoalesceEmpty((
(([Measures].[Issues created], [Issue Type].[Standar Issues],[Status].CurrentHierarchy.DefaultMember,[Status].[Done],[Salud].CurrentHierarchy.DefaultMember,[Assignee].CurrentHierarchy.DefaultMember,[Código de proyecto].CurrentHierarchy.DefaultMember,[VP/Direccion].CurrentHierarchy.DefaultMember,[Gerente Owner].CurrentHierarchy.DefaultMember)
+
(([Measures].[Issues created],[Issue Type].[Standar Issues],[Status].CurrentHierarchy.DefaultMember,[Status.Category].[In Progress],[Salud].CurrentHierarchy.DefaultMember,[Assignee].CurrentHierarchy.DefaultMember,[Código de proyecto].CurrentHierarchy.DefaultMember,[VP/Direccion].CurrentHierarchy.DefaultMember,[Gerente Owner].CurrentHierarchy.DefaultMember)*0.5))
/
([Measures].[Issues created],[Issue Type].[Standar Issues],[Status].CurrentHierarchy.DefaultMember,[Status].[Sin Dismissed],[Salud].CurrentHierarchy.DefaultMember,[Assignee].CurrentHierarchy.DefaultMember,[Código de proyecto].CurrentHierarchy.DefaultMember,[VP/Direccion].CurrentHierarchy.DefaultMember,[Gerente Owner].CurrentHierarchy.DefaultMember)),0)
ELSE
0
END

2

Hi @fcojnav78,

The problem seems to be that the field “Objetivo anual” is specified in a certain level of issues, not all of them. Once you select a particular value, only the issues that have the respective value are retrieved.

If the field is specified in a higher level issues in your Issue dimension hierarchy, consider defining and importing a new JavaScript calculated field that would pass down the field value to the issue’s children. See our documentation page for an example where a field value from the Epic is passed down to the Epic children - Epic level custom field.

Best,
Roberts // support@eazybi.com

1 Like