Get sum of column and percentage of it

I need to get the total of a single column (in my case, Hours Spent) and get to know the percentage of the different users that have logged hours.

To ilustrate it, look at this example:

Worker 1 has logged 10 hours, so it’s 10% of the total Hours spent
Worker 2 has logged 20 hours, so it’s 20% of the total Hours spent
Worker 3 has logged 70 hours, so it’s 70% of the total Hours spent

You can use a division of hours spent of selected user to any user addressing any user as Logged by default member in a tuple with measure hours spent:

CASE WHEN [Measures].[Hours spent] > 0
THEN
[Measures].[Hours spent]
/
([Measures].[Hours spent],
[Logged by].DefaultMember)
END

image

Daina / support@eazybi.com

Starting eazyBI 5.0 version there is an option to add standard calculations to the measures, see https://docs.eazybi.com/eazybi/analyze-and-visualize/create-reports#Createreports-Addstandardcalculationsbasedonaselectedmeasure.

Now it would be possible to easily add % of Total to the Hours spent

Lauma / support@eazybi.com

1 Like