Hi,
We log incidents to jira and each incident ticket has a custom field for the projected cost of that incident. Incidents are stored as separate Project.
I’m trying to sum that field for selected time period which works fine. When I drill through that measure then eazyBI shows me all tickets (from all projects) with the total sum.
Is it possible for me to show only valid tickets with that custom field value?
Here is the code I use for sum
cache(
Sum(
Filter(
Descendants(
[Issue].[incidentreporting2],
[Issue].[Issue]
),
DateInPeriod(
[Measures].[Issue created date],
[Time].CurrentHierarchyMember
) AND
[IM-Function].CurrentMember = [Issue].CurrentMember and
[IM-Site].CurrentMember = [Issue].CurrentMember and
[Measures].[Issue IM-3rd Party Issue] = "No"
),
[Measures].[Issue IM-ImpactCost]
))
and I get this when I drill into the sum:
Incidents tickets have INCREP prefix but it shows me all tickets from all projects
I would like to see a list of INCREP tickets which make up the sum with the amount they are contributing to the sum.