How do I display by one custom field and filter by another in Atlassian Analytics

[andrew_pass]

Hi,

My scenario is - 

I've got a custom field, Change Strategy, I have another multi-select custom field for Business Area.

I have a chart in Analytics at the moment which gives me a bar chart of -

Open Epics by Change Strategy with a break down by status category.

I need to be able to filter this by Business Area where the user selects the appropriate area, epics can be tagged however to multiple areas.

Currently I've gotten as far as being able to filter and see just the issues that contain only the single value but where a ticket is tagged to multiple these aren't coming back.

Anyone got any ideas please? Would be greatly appreciated!

Thanks!

[Waseem Abbas]

Hi! To filter by Business Area with multi-select values, you'll need to adjust your chart settings. Ensure your filter logic supports "contains any" rather than "equals" for multi-select fields. This way, epics tagged with multiple areas should be included if they match any of the selected values. If you're using JQL, something like cf[Business Area] in (value1, value2) can be useful. Check your chart’s filtering options or consider creating a custom filter to handle multi-select fields effectively. Hope this helps!

[Don DMack]

This statement Ensure your filter logic supports "contains any" creates a syntax error in Atlassian Analytics for me.  I use "IN".