How to create a filter to get a component field last change in EazyBI?

Hi,

I'd like to know how I can create a filter to get the last change of the component field as a custom field in EazyBI.

I tried:

Case when
([Measures].[Issue Component]) = 'X'
then
Tail(Filter([Time].[Day].members,
([Measures].[Issue Component]) = 'X'
)).Item(0).Name
end

But this filter return the issue created date

Thx

1 answer

Hi Marcelo,

Component changes are not imported in eazyBI. Also, as Components is a multiple value field, it is not allowed to import value changes of this field.

It would be possible to precalculate the last date when the changes of Components field had happened in the additional custom field (without splitting by particular components) and import in eazyBI (as a measure or issue property, regarding of your further needs). You could use JIRA Misc scripted fields for that, for example. Here is a link to eazyBI documentation page how to import JIRA Misc fields in eazyBI: JIRA Misc custom fields

For more detailed assistance, please, contact support@eazybi.com .

 

Ilze, support@eazybi.com

 

Suggest an answer

Log in or Sign up to answer
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Published May 30, 2018 in Marketplace Apps

Three tips for boosting your board's efficiency with Story Maps

Trello is one of the most effective tools for driving your sprints. It's customizable for every Agile team and product owners and Scrum masters (SM) love it. However, Agile teams often struggle with:...

819 views 2 9
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you