Filter date in EazyBi

[Ismail Sanni]

Hi Guys,

Is there a way to filter out my date to show every Tuesdays and Thursdays on Eazybi?

Thanks 

[Oskars Laganovskis · Accepted solution]

Hi @Ismail Sanni ,

You might use the "Weekday" dimension to filter out your desired days.

Regards,

Oskars
eazyBI support

[Ismail Sanni]

@Oskars Laganovskis I will try that, and I also have another Issue,

I'm trying to find issues that were transitioned to a status within the past 10days. I tried this but it's not giving the issues, its just empty. 

Is there a better way to filter it out?

[Oskars Laganovskis]

@Ismail Sanni , the Transitions dimension contains the list of transitions that issues have encountered within Jira.

If you are looking for the number of issues that have had a specific transition to status, you are looking for the measure "Transitions to status Issues count". If you want to limit these transitions to the last 10 days, you might create a tuple with the measure and a calculated member in the "Time" dimension.

The expression for the calculated member "last 10 days" might be as follows.

Aggregate(
[Time].[Day].DateMembersBetween(
 '11 days ago',
 'now'))

Then you might create the following tuple.

([Measures].[Transitions to status issues count],
 [Time].[last 10 days])

This would work best with the "Transition Status" dimension.

You might read more about transitions and related measures here - https://docs.eazybi.com/eazybi/data-import/data-from-jira/import-issue-change-history.

Regards,

Oskars / eazyBI support

[Ismail Sanni]

@Oskars Laganovskis 

Thanks, I really appreciate your help.