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"
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
Martins / eazyBI support
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.