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


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.


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

[Time.Weekly].CurrentMember.get('Week day name') MATCHES

That would aggregate all Mondays in one calculated member:

Similarly, you could create other calculated members

Martins / eazyBI support

Many thanks for your reply. It works perfectly.

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 /