How to get the report in eazybi for the issues created before specific date?

sameerkumar_mandal February 10, 2020

Hello team,

Can you pls help me with calculated member functionality to display issues, created before specific date?

Jira query:

project in ("abcd") AND fixVersion  = "abcd" AND issuetype in (Epic, Story, Defect, Bug) AND createdDate < "2019/12/13"

 

1 answer

0 votes
Sir Mārtiņš Vanags
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
April 20, 2020

Hi @sameerkumar_mandal 

In this case, you could create a new calculated member in the "Time" dimension that filters all dates before the specific date.

Aggregate(
[Time].[Day].Members.item(0): --first day imported in eazyBI Time dimension
[Time].[Day].DateMember('Dec 13 2019').lag(1) --one day before the closing 
)

 

Next, you could enable this new member for the selection from the dimension and create your expected report using all these dimensions as page filters

report example.png

 

Martins / eazyBI support

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events