How to filter issues and display string without issues on rows?

Questions & Answers
#1

image
image1047×295 7.2 KB

CASE WHEN DateInPeriod(
[Issue].CurrentHierarchyMember.get(‘Start_Date’),
[Time].CurrentHierarchyMember
)
THEN
CASE
WHEN
[Resource Name].CurrentMember.Name MATCHES “Joubert, Amanda”
THEN
[Measures].[Issue Time Code]
END
END

#2

Hi EazyBI team,
Is it possible to do? Please do let me know if required more information on requirement. Thank you.

#3

You would need Time code as a dimension for this one. If you do not have the option to import Time code as a dimension, please check this community post on how to enable this:

If you have Time code as a dimension, you can use this formula to show Time code for each user based on issues with a start date:

NonEmptyString(Generate(
  Filter(
  [Time Code].[Time Code].Members,
  [Time Code].CurrentMember.Name <> "(none)" AND
  [Measures].[Issues with start_date] > 0),
  [Time Code].CurrentMember.Name, ","
))

Please check the spelling for any custom field dimension and measure to avoid any typo problems. We suggest using autocomplete whenever you can when writing formulas.

Daina / support@eazybi.com

1 Like
#4

Thank you so much for help on this and works now fine.

image
image1547×227 3.28 KB

#5

Hi Daina. Is it possible to display time code from start_date to End_date? instead of just start_date. please advise. Thank you.

#6

Yes, you can use a bit more complex formula instead of issues with start date as a filter. Use a formula similar to Open issues the part with function PreviousPeriods instead.

Here is an updated formula for this:

NonEmptyString(Generate(
  Filter(
  [Time Code].[Time Code].Members,
  [Time Code].CurrentMember.Name <> "(none)" AND
  Sum(
    {PreviousPeriods([Time].CurrentHierarchyMember), [Time].CurrentHierarchyMember},
    [Measures].[Issues with start date]
    -
    [Measures].[Issues with end date]
  ) > 0
 ),
  [Time Code].CurrentMember.Name, ","
))

Please check if all custom measure and dimension names are used correctly in the formulas above.

Daina / support@eazybi.com

1 Like
#7

Works now fine. Thank you @daina.tupule .