In eazyBI, I need to filter issue ,status and time

[FJ-Jay]

Hi all,

I want to filter issue type , status and time

 issue type = Service Request

status = in processing

time = Before last month

I just came into contact with this system, so need help. thanks.

sum(
Filter(
Descendants(
[Issue Type].[Service Request],[Issue Type].[Service Request]
),
DateBetween([Issue].CurrentHierarchyMember.get('Created at'),
'2021-01-01',
'2021-09-31')
)

)

[Fabian Lim · Accepted solution]

Hi @FJ-Jay

Another method you can use is to bring the dimensions you need in the pages for filtering. Then select the opions you need.