6 Replies Latest reply on Sep 22, 2018 4:23 PM by Jessie Zhou

compare different measures of one dimension

Hi there,

Just wondering, is there a way to compare sum of  Q1,Q2 andQ3  spent to Q4 forecast spent, just so i can understand the likelihood of over or under spent  given a budget ?

thank you,

Jes

• 1. Re: compare different measures of one dimension

Hi Jes,

Simple answer, yes, just use a Lookup.

Though it would help to know how your data is defined to be able to provide the correct calculation to you.

Steve

• 2. Re: compare different measures of one dimension

Hi Steve,

Thank you for your reply, here is the dummy data that i have, mind to show me how to use lookup ?

Thank you,

Jes

• 3. Re: compare different measures of one dimension

This can be done using window calcs and lookup-ups.

First though, may I know how you are intending to use your data? Are you planning on plotting this as a table in this way or, are you going to be creating a visual, and what calculations do you have in mind, and finally, is this the only data in your set? This would be useful to know if you are going to build-out a little more as window calculations can affect this if they are not properly scoped.

Steve

• 4. Re: compare different measures of one dimension

Hi Steve,

So basically I also have the budget information, so I wanna find the

difference between budget and sum of first three Q actual spent , then

comparing it with the last Q forecast spent, to virtualize the likelihood

of under / over spent.

Do you mind give me some idea of how to use the calculations as you

mentioned to compare the sum of first three quarters and the last quarter.

Thank you,

Jessie

On Sat, Sep 22, 2018, 10:18 AM Steve Martin <tableaucommunity@tableau.com>

• 5. Re: compare different measures of one dimension

Hi Jessie,

The attached workbook demonstrates the use of a lookup and, when using it in a calculation for a comparison.

As a matter of interest, do you happen to work for a travel firm?

Steve

• 6. Re: compare different measures of one dimension

Hi Steve,

Thank you for your help! feel good to learn sth new today!

And no, i am just planning data with some ideas i didnt work for a travel firm

Best,

Jes