How filter a custom field by value in a row report?

Hi,
I have a custom field in JIRA…it is a selection list.
So in EazyBI I have some values like this
[customFiled].[value 1]
[customFiled].[value 2]
[customFiled].[value 3]

[customFiled].[value n]

This custom filed is in a row report and I would like to show only the value witch have the caracters XXX for example.
Do you know how I can do it please ?


Regards,
Olivier

Hi @Olivier!

You could click on any of the row members and select to Filter by name > Matches and enter the string you wish to match in the dimension member names, see https://docs.eazybi.com/eazybi/analyze-and-visualize/create-reports#Createreports-Allhierarchylevelmembersandmemberactions.

Lauma / support@eazybi.com

Hi Lauma !
Thanks a lot :slight_smile:
Do you know if it is possible to do it in a calculated member too ?
See the attachment where I had defined a member WMS with some value of a customed field

Regards,
Olivier

Lauma,
I have an another question too.
When the custom field is in the column I can not filter by name…

You are correct, currently, it is not possible to filter by name if the dimension is on columns. We have added this for consideration in the future development of eazyBI.

Now you could create an Aggregate(…) member in the dimension and use the MATCHES operator to filter members by name. For example (please double check the dimension name spelling)

Aggregate(Filter(
  [Produits - Functionnalites].[Produits - Functionnalites].Members,
  [Produits - Functionnalites].CurrentMember.Name MATCHES ".*WMS.*"
))

Lauma / support@eazybi.com

Thanks a lot Lauma, it works !
Have a nice day :slight_smile:

1 Like