3 Replies Latest reply on Jun 17, 2017 8:21 AM by Kalyan Allam

Calculate total values from the multiple data sources.

veera.gundu.0 Jun 17, 2017 2:16 AM

Hi Team ,

We have two share point lists

First list contains Business Group and Manager Name and Employee Name and another list contains Employee Name, Capacity and Month. Both the lists are joined with Employee Name

We have requirement as Calculate Total/Average Capacity of Business Group and Manager by connecting both the SharePoint lists.

I have attached the Sample workbook , Currently we are using tableau 10.0 Version so we have to depend on SharePoint OData connections.

Could you please help us to resolve the issue ?

Capacity by Manager.twbx 61.6 KB

1. Re: Calculate total values from the multiple data sources.

Akhilesh Singh Jun 17, 2017 5:55 AM (in response to veera.gundu.0)

Hello Veera,

I am not having 10. So, below are the steps, follow and see if this could help you.

1) Create a calculated field as SUM(Capacity)/AVG(Capacity).

2) Just place this as text shelf.

3) Put Business Group and Manager in Row shelf.

AK
Like Show 0 Likes(0)

Actions
2. Re: Calculate total values from the multiple data sources.

veera.gundu.0 Jun 17, 2017 7:49 AM (in response to Akhilesh Singh)

tried this solution does not help me
Like Show 0 Likes(0)

Actions
3. Re: Calculate total values from the multiple data sources.

Kalyan Allam Jun 17, 2017 8:21 AM (in response to veera.gundu.0)

Hi,

Its not working because you have different number of Employees in the Employee Master and Capacity.
You have Pratap, Sanket, Sireesha, Suman extra in Employee Master and thats why the AVG Calculation is not matching. If you don't want to consider these employees in the Avg calculations then you should filter them at the data source level. Then your calculations works fine.
You can check the data source filter like this. Just right click on the data source.
then select Add filter, select Employee Name and exclude those names that you don't want to consider for Avg calculations.
Like Show 0 Likes(0)

Actions