Remove users from report individually

Questions & Answers
1

Hello,

I would like to remove people from a list of users as the hours recorded are no longer required (due to a restructure). I have a report where the table has the following.

Rows: Time
Logged By: All users

Columns: 3x User Defined Hours

If a member is removed from the report manually (right click member - delete). The report does not change the External Project Hours.

External Project Hours measure:
([Measures].[Hours spent], [Project].[ProjectA])+
([Measures].[Hours spent], [Project].[ProjectB])+
…
([Measures].[Hours spent], [Project].[ProjectZ])

Thanks in advance

2

Hi @rem

You are right, the total row “All Logged by” won’t be automatically calcualted if you remove one user from “Logged by” dimension.

You could try this formula for your “External Project hours” measure:

Sum(
{
	[Project].[ProjectA],
	[Project].[ProjectB],
	[Project].[ProjectZ]
},
[Measures].[Hours spent]
)
-
Sum(
{
	[Project].[ProjectA],
	[Project].[ProjectB],
	[Project].[ProjectZ]
},
(
[Measures].[Hours spent],
[Logged by].[Manually removed user name]
)
)

If you have more than 1 user to remove, you can replace the “Manually removed user name” with a calcualed member from “Logged by” dimension after it is created with an aggregate.

Martins / eazyBI

3

Hi Martins,

Thanks for the response.

I’ve set up the measure and tested it on a user.

But I get the error

Formula is not valid:
No function matches signature “Sum(, , )”

4

Hi @rem

Please send your formula that returns the error.

Martins / eazyBI

5

It was incorrectly pasted. Apologies.

However, for “[Logged by].[Manually removed user name]”

Are we talking short name? or surname, firstname as it is currently displayed in the graph?

To add context, its now removing hours of a test user, but it is still keeping the user in the chart with 0.00 logged. I’m also seeing that the clumn has a lot of negative values in place of what was blank before.
image

Here is the code thats been used for external project hours:

Sum(
{
[Project].[ProjectA],
[Project].[ProjectB],
[Project].[ProjectC],
[Project].[ProjectD]
},
[Measures].[Hours spent]
)
-
Sum(

{
[Project].[ProjectA],
[Project].[ProjectB],
[Project].[ProjectC],
[Project].[ProjectD]
},
(
[Measures].[Hours spent],
[Logged by].[Surname, Firstname]
)
)
6

See previous response, not sure if the community update when a user has updated a post.

7

Hi @rem

You should use display names in the formula for “Logged by” dimension - the same as you see when you create a report with “Logged by” dimension in rows.

Martins / eazyBI

image
image2578×966 199 KB

8

Sorry, I am quite new to EazyBI formulas (Despite using EazyBI for years). But wouldn’t this show specific people would it not?

So for example, if I used [Logged by].[A Name] it would display A Name.

I don’t want this. I want to have a list of users minus the people on the below list.

A Name
A NotherName
A ThirdName

As a test, I used my name, as I’m on the list of people in the formula I used above. What I observed was that my hours had changed from 74.75h to 0.00. However, others had had 74.75h removed from “External project hours”.

Again, Sorry to sound so new at this. But I hope this clarifies further.

Thanks

9

Hi @rem

The idea is to subtract the hours for particular users from the calculation, which is why I recommended using these users in the second part of the formula to exclude their hours.

What layout for the report you have in mind? How would your report look like when it is completed (columns, dimensions, measures, filters)?

Martins / eazyBI

10

So the current layout is as below:

image

This is the layout I would like, just with a set of users removed (about 10 or so) so hours are not seen in Internal and External project hours (Both are a user defined measure).

Regards

11

Hi,
Are you saying that the formula I suggested doesn’t work as expected?
Could you please provide more details (if the content is too sensitive, you can reach out to support@eazybi.com) on what is wrong with the formula after you use the correct Logged by names to exclude them from the calculation?

Martins

12

Yes lets have this conversation out of the community as some data is sensitive.

Thanks