Need to generate report with Date Filter

Questions & Answers
, , ,
1

Hi Team,

We need two filters for DAYS, that is 1st -15th of every month as 1st Filter & 16th -31st as 2nd Filter to generate a report on every 15days basis.

So could you please help me on creating a measure or calculated member in Time dimension to fix this blocker.

Please help me to generate a report for every 15days .

Thanks in Advance

Regards,
Revathy Madhavan

2

Hi Team,

Any update on tha above?

Regards,
Revathy.M

3

Hi @Revathy0227

If you want answers according to SLA, try reaching out to eazyBI support.
There is no SLA for community posts.

Currently, while you can’t build many different custom hierarchies in “Time” dimension the best way would be by creating a user-defined calculated measure that would understand how many days of each month should be calculated for the particular numerical measure.

For example, this would calculate number of issues created for the first 15 days of the displayed month.

CASE WHEN
[Time].CurrentHierarchyMember.level.name = "Month"
THEN
Sum(
Filter(
  [Time].CurrentMember.children,
  [Time].CurrentMember.key >0
  AND
   [Time].CurrentMember.key <16
),
[Measures].[Issues created]
)
ELSE
NonZero(
SUM(
Filter(
Generate(
    ChildrenSet([Time].CurrentHierarchyMember),
    Descendants([Time].CurrentHierarchyMember, [Time].[Day])
  ),
  [Time].CurrentMember.key >0
  AND
   [Time].CurrentMember.key <16
),
[Measures].[Issues created]
)
)
END

In similar way you can create one to calculate issues from day 16th.

Martins / eazyBI support

image
image1602×1316 103 KB