Report filter based on array length | Community
Skip to main content
Lawson02
Lawson02
Level 6
December 12, 2024
Solved

Report filter based on array length

  • December 12, 2024
  • 1 reply
  • 447 views

I have a field called numPick which is a checkbox field that can contain multiple things, for ex AAA123, AAA122, AAA121. Is it possible to create a report filter that filters out projects that have more than one checked?

 

Projects I want:

numPick: AAA102

 

Projects I don't want:

numPick: AAA123, AAA122, AAA120

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Lawson02

Thank you very much for the response, it set me on the right path! I am going to filter my report using

DE:numPick=,

DE:numPick_Mod=cinotcontains

 

This way any project with more than one numPick is filtered out because since numPick is a checkbox field it separates multiple using a comma.

1 reply

skyehansen
Community Advisor
skyehansenCommunity Advisor
Community Advisor
December 12, 2024

I think if you make a calculated field and then filter off that calculated field, this would be the easiest.

 

So if for example, you created a calculated field called numPick-CF, and the calculation would be {DE:numPick}.

 

Then your report filter would be

DE:numPick-CP=AAA102

DE:numPick-CP_Mod=cieq

Lawson02
Lawson02AuthorAccepted solution
Level 6
December 13, 2024

Thank you very much for the response, it set me on the right path! I am going to filter my report using

DE:numPick=,

DE:numPick_Mod=cinotcontains

 

This way any project with more than one numPick is filtered out because since numPick is a checkbox field it separates multiple using a comma.

Terms & ConditionsAccessibility statement

Loading footer...