2 Replies Latest reply on Sep 9, 2016 4:07 PM by Yuriy Fal

# How do I set a weight on calculated fields from separate data sources?

I have 3 separate data sources right now that serve as the drivers of the KPI's I'm displaying. One is a cube extract, and the other 2 are Excel sheets. The image attached show the dashboard with each of the bar graphs generated.  The final bar graph (#6) is a separate Excel sheet that is a manual input of the values from bars 1-5.

Graphs 1-4 are linked under Primary/Secondary relationship edits.  Graph 5 (cube) is not linked since I can't edit multiple relationships.

What I have in the weighted calculation from Bar Graph #6 (KPO Total) on the Excel sheet is:

1 - 35%

2 - 35%

3 - 10%

4 - 10%

5 - 10%

Is there a way I can create that weight scenario directly in Tableau rather than having to manually update a separate Excel sheet?

• ###### 1. Re: How do I set a weight on calculated fields from separate data sources?

Hey Scott,

Without a packaged workbook it's going to be tough to give you a direct answer about your viz. However, a thread like this may be helpful:

• ###### 2. Re: How do I set a weight on calculated fields from separate data sources?

Hi Scott,

If by chance you Cube DS is domain complete

(i.e. it does contain all necessary dimension members

to build a final view for the KPI Total), then you could

make it a Primary and blend the other two Excel DS into.

Having Excel-based datasources as Secondary

you would have a flexibility to adapt relationships.

Your weighted KPI Total would look as such:

ZN( ATTR( [ExcelDS1].[KPI Completion] ) ) * 0.35 +

ZN( ATTR( [ExcelDS1].[KPI In Progress] ) ) * 0.35 +

ZN( ATTR( [ExcelDS2].[KPI Process] ) ) * 0.10 +

ZN( ATTR( [ExcelDS1].[KPI Sustainability] ) ) * 0.10 +

ZN( ATTR( [CubeDS].[KPI Fulfillment] ) ) * 0.10

You would be using any of your Excel DS to enter the above into.

Hope it could help.

Yours,

Yuri