Search code examples
parameterstableau-apidashboardworksheetcalculated-field

How to create a calculation on the dashboard between two different worksheets in Tableau?

I'd like to create a calculation on a dashboard that has inputs from two different worksheets.

In other words, I have one bar in a worksheet called 'Closed Won Deals' and another bar in another worksheet called 'Intro'd Deals.' I've placed both on the same dashboard, but I'd like to divide the number of closed won deals by the number of Intro'd deals on the dashboard.

enter image description here

In this case, I'd like to divide 29/254 to attain 11.4%.

I've tried to accomplish this by doing the following: 1) Create a calculated field for Closed Won Deals that would sum to 29 2) Create a calculated field for Intro'd Deals that would sum to 254 3) Create a calculated field for 'Conversion Rate' by dividing the calculate dfield for Closed Won Deals by the calculated field for Intro'd deals, which looks like the following: 

sum([Intod deals])/SUM([Closed Won Deals])

However, I get the incorrect conversion. Is there a better way to accomplish this?

Solution

  • (now this is just an idea.)

    sum([Intod deals])/SUM([Closed Won Deals])

    => would be translated to: (sum = [Intod deals])) / [Cloded Won Deals] try to add one more bracket to make it: 

    sum(([Intod deals])/SUM([Closed Won Deals]))