eazyBI - display issues that were created from certain date

[Samuel Titka]

Hi eazyBI team!

I am pretty sure this is easy one, but I cannot get it done.

My report has Issue dimension in Rows section. So it displays issues in lines. Columns shows Days in transition status measure.

How can I show only subset of the issues? Only those issues that were created after certain date? I do not want to show also Issue created date property in my report. How can I achieve this?

BR

Samuel

[JānisJ · Accepted solution]

Hi Samuel,

There are three options:
1. You can add Filter to the column and then remove the unnecessary column (the filter condition will remain).
2. You can create calculated member for Issue dimension with formula:

Aggregate(
  Filter(
    [Issue].Members,
    DateCompare([Issue].CurrentMember.get('Created at'), 'Nov 07 2014') >= 0
  )
)

3. You can import only necessary issues. Fill JQL query field in Select application import options page with value: 

createdDate >= '2014/11/07'

Best regards,

Jānis.

[Samuel Titka]

Hello Jānis, thank you very much for your fast response! I will use 1. or 2. option. I did not realize that the filter condition will remain. This is ideal. Also 2. option is very useful - it will for sure help me when creating other reports! I do not want to import only such issues, so 3. is not relevant for me in this case. Thanks again and have a nice day BR Samuel