How to filter a report in 2 columns of 3 in Eazybi ?

Aurelie Pilette
Contributor
February 19, 2019

Hello,

i have this report

eazybi.png

I would like to have :

I try to filter to have the version date only when New feature and Bug is not empty for the version date.

if bug is empty and if new feature is empty for one date, the line must be displayed

 

My fix version date is a calculated member :

CoalesceEmpty(
[Affects Version].CurrentHierarchyMember.get(‘Release date’),
[Fix Version].CurrentHierarchyMember.get(‘Release date’)

 

For that, i try to make a calculated member in measure dimension :

Filter(
CoalesceEmpty(
[Affects Version].CurrentHierarchyMember.get(‘Release date’),
[Fix Version].CurrentHierarchyMember.get(‘Release date’)
),
[Issue Type].[Bug & New Feature].Members >= 1
)

 

Bug and New feature is a calculated member.

 

But it doesn't work. Can you help me please ?

 

 

 

1 answer

0 votes
Fabian Lim
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
November 30, 2021

Hi @Aurelie Pilette

You need to use row filtering to accomplish this.  This post from the eazybi community explains the workaround in details: https://community.eazybi.com/t/filtering-rows-in-eazybi-with-profield-list-property-imported-as-property-and-dimension/5674/2

Regards

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events