Assistance in replicating a complicated JQL query

[bchrist410]

Is it possible to reference a JQL query or JIRA filter from within EazyBI? I have to create a chart tracking issues retrieved by the following JQL query:

project = [redacted] AND issuetype = Bug AND status not in (Canceled, Resolved, Closed, Draft) AND priority in (Blocker, Critical) AND component in ("[redacted]", "[redacted]", "[redacted] Common", "[redacted]", "[redacted] Data Service", "[redacted] Graphics", "[redacted] Import Export", "[redacted] Login", "[redacted] Message Center", "[redacted] Message Service", "[redacted] Notification", "[redacted] Route Planning", "Planning", "[redacted]", "[redacted]", Authentication, "[redacted]") AND created >= 2017-MM-DD AND created <= now() AND project = [redacted] AND issuetype = Bug AND status not in (Canceled, Resolved, Closed, Draft) AND priority in (Blocker, Critical) AND component not in ("[redacted]", [redacted], "[redacted]", "[redacted]", "Development Environment","[redacted] SDK", "[redacted]", Sync, "File Sync", "Data Persistence", "[redacted]", "[redacted]", "[redacted]", "[redacted] Assembly", [redacted]) AND created >= 2017-MM-DD created <= now()

This query is replicated with slight variations to capture three different bug levels across four subprojects (12 similar queries in total).

Any help or pointers in the right direction would be appreciated.

[zane.baranovska]

Hi,

If you would like to analyze the specific set of data (according to this JQL query) form different perspectives, then you may add JQL query to data import in eazyBI.

Another option is to use dimensions Project, Issue Type, Status, Priority and Time as pages and filter data in a report to match the logic of JQL query. For example, like in a picture below.

To reuse filter options of each dimension (for example dimension Priorities) in other reports, you may define a calculated member in respective dimension to aggregate a list of matching values (for example, Blocker and Critical).

Best,
Zane