Request

It would be nice to see even some basic conditional logic that can be done in filters.

Reason

Some filter results return empty objects such as openSprints() if there is not an active sprint.

Issue

This means that some dashboards could just be empty or require double the widgets to show two different sets of data.

Example: openSprints() / futureSprints()

Proposition

For instance, if you were able to write the following statement:

If( openSprints() == Null ){ return futureSprints() }

elseIf( openSprints() != Null ){ return openSprints() }

or written as a ternary operator:

if( openSprint() == Null, return futureSprints(), return openSprints() )

Adoption of Use

I would imagine there a quite a few people that would welcome this feature, since many people use and understand Microsoft Excel functions and conditional logic is being used in more widely adopted software like MailChimp.

There seems to be a trend to offer simplified conditional logic for general purpose, and custom scripting for more advanced users. I think this is where Jira has an opportunity to cater to both those individuals.

References

How to Use Conditional Statements in Search Filter