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

Questions & Answers
1

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 ?

image
image.png1076×692 56.5 KB

Regards,
Olivier

2

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

3

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

image
image.png960×497 29.2 KB

4

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

5

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

6

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

1 Like