Drill-through list when setting dimensions for a text field

Questions & Answers
, , , ,
1

  1. I enabled the Jira text field named ‘PR’ as a dimension.
    Additional advanced settings:
    [jira.customfield_17131]
    data_type = “string”
    dimension = true

  2. The values ​​for ‘PR’ include TPHA, TPHB, TPHC, TPHD, TPHE, and TPHF (these are examples).

  3. I created a member named ‘A’ combining TPHA and TPHB using a calculated member formula.

I created a member named ‘C’ combining TPHC and TPHD using a calculated member formula.

I created a member named ‘E’ combining TPHE and TPHF using a calculated member formula.

  1. The values ​​are counted correctly using the created dimension.

  2. When I click ‘A’ and select “drill through issue,” a list of issues appears.
    The ‘PR’ fields of these issues contain TPHA and TPHB.

  3. When I click ‘C’ and select “drill through issue,” no list of issues appears (“No data found”).
    The ‘PR’ fields contain TPHC but not TPHD.
    It seems the system reports no data because TPHD is missing, even though TPHC values ​​do exist.

Since we want to see a list of the values ​​that actually exist,
we would like the drill-through action to display the list of issues containing TPHC.

I am inquiring if there is a way to achieve this. Due to security policies preventing screenshots, I have provided a detailed text explanation. Please let me know if any part requires further clarification. I would appreciate your help in resolving this issue.

2

Hello @sso ,

I assume that there might be some trouble with the member aggregation.

Please export and share the report definition to the eazyBI support email support@eazyBI.com for closer inspection.

Regards,

Oskars / support@eazyBI.com

3

Hi, @oskars.laganovskis ~

We have forwarded the content to the email address you provided. Please check it.

Thanks.

4

The problem turned out to be related to the calculated ember expressions.

The arithmetical operations were used to add the members, which provided the results with the basic measures.

The proper method for creating calculated members was suggested - Calculated members in other dimensions .

Regards,

Oskars / support@eazyBI.com