i have a pretty big and complicated Jira JQL, which i need to reproduce in EazyBI.
I want to create a custom Measure containing the Filter Function to do that. Im currently stuck at the part where i have this part of the JQL:
[…] AND labels in (“label 1”, “label 2”) AND labels != “label 3”
So basically it only counts the issue if it has either label 1 or label 2 or both AND it doesnt have label 3.
If the “labels in ()” part only consisted of one label it would be pretty easy, but i just cant seem to find out how i can do it with 2 or more labels. Is there any way to do it?
Further question: The JQL consists of many more of these kinds of parts. I tried to use “pages” for example to filter the status, but it didnt quite work. I drilled into the issues and there were a few issues who were in a different status. Is there a way to make this work or do have to include this Filter also into the jql and if so, how?