No information on parent groups for a property issue

Questions & Answers
1

Hello, I start in the creation of calculated field and I need help.

In jira I have a specific field “N° de Ticket CRM” which is imported into EazyBi as an issue property.

The field is empty or fill with string.
I have this information only on the lines issue.

I would like from any dimension to be able to count the number of issues with a “N° de Ticket CRM” to make a statistic

Here is the property field :

[Issue].CurrentHierarchyMember.get('N° de ticket CRM')

This is what i can only get on the issue :

image
image.png1420×355 17.5 KB

In yellow a column propertie and in red my count column.

But my count column is not good because i cont only issue and not other dimension.

My user define field :

CASE WHEN Not IsEmpty([Issue].CurrentHierarchyMember.get('N° de ticket CRM'))

THEN 1
ELSE
0
END

But with the dimension Time I always have zero, then I would like the number of issue with a value in the field “N° de Ticket CRM”

Thanks for your help

2

I want value in cell “Issue N° de ticekt CRM” or “TicketCRM count”.
I want sum of “Issue N° de ticket CRM” for my dev.

image
image.png712×471 20.8 KB

3

We can see on this screenshot that I have the green line that is correct. But the red lines that are groupings of me do not give me the sum of the green line. I have an empty cell so I should have 1

image
image.png1608×321 22.2 KB

4

Hi @MiH,

To get the count of issues where this field is not empty, try creating a new calculated measure, using the Filter() and Descendants() functions:

NonZero(Count(
  Filter(Descendants([Issue].CurrentMember,[Issue].[Issue]),
  Not IsEmpty([Issue].CurrentHierarchyMember.get('N° de ticket CRM'))
  AND
  [Measures].[Issues created] > 0
  )
))

You can read more about these functions on our documentation page - https://docs.eazybi.com/eazybi/analyze-and-visualize/calculated-members/mdx-function-reference/filter.

Kind regards,
Roberts // eazyBI support