Create a calculated member of the ticket closed in each day of the week

Questions & Answers
1

Hello,

I would like to create a calculated member that I can choose the weekday (Monday, tuesday…) and see the ticket resolved of each weekday. Or just to see how many issue are resolved on every Friday.

Thank you in advance for your help.
Trang

2

Hi,

You could try creating a new calculated member in “Time” dimension (weekly hierarchy) using the following code:

Aggregate(Filter(
[Time.Weekly].[Day].Members,
[Time.Weekly].CurrentMember.get('Week day name') MATCHES
'Monday'
)
)

That would aggregate all Mondays in one calculated member:

calculated%20member%20-%20Mondays
calculated member - Mondays.jpg1776×998 185 KB

Similarly, you could create other calculated members

Martins / eazyBI support

3

Many thanks for your reply. It works perfectly.

4

With version 6.0 we added a new dimension Week Day we map any default stored measures to Week day dimension by default. You can use this dimenson to check how many issues were created, or resovled by Week days.

Daina / support@eazybi.com