How to filter issues

Questions & Answers
1

Hello,

I have a request to get the issues account by the week dimension. for example, I have a field with the value [2019-03-27,2019-04-01,2019-04-22] for issue it-1, so for week(2019-03-24,2019-03-30),the count would be 1, for week(2019-04-01,2019-04-07),count would be 1, but for week(2019-04-08,2019-04-16),count would be 0…Could you please help with the code for caculated memeber? Thanks.

BR
Xavi

2

Hi @xavi,

You could use the AnyDateInPeriod(…) function for this. See https://docs.eazybi.com/eazybi/analyze-and-visualize/calculated-measures-and-members/mdx-function-reference/anydateinperiod.
For example

CASE WHEN 
AnyDateInPeriod(
  [Measures].[Issue dates], [Time].CurrentHierarchyMember
) THEN 1
END

Lauma / support@eazybi.com