9 Replies Latest reply on Jun 28, 2016 5:32 PM by Mikey Michaels

Compute using HELP!

Hello All,

I have had wonderful success posing all sorts of questions on here....hope someone can help me again!

With the help of the Tableau Forum, I created a calculated field called [Current 3 month Utilization]. This field is to return a 3 month utilization average base off my parameter [Date parameter].

Everything seems to be going okay, until I need to adjust the Compute Using on my calculated field.

Since I'm a novice Tableau user, is there anyone that can help me with my compute using field?

Cheers,

Mikey

• 1. Re: Compute using HELP!

(Note to self.  8.2 workbook)

What do you want to do?  Given the data in the sheet, what result do you expect to see for the 4 cells where this is displayed?

• 2. Re: Compute using HELP!

Hi Joe,

thanks for getting back to me so quickly!

I'm hoping to see a utilization percentage for each country in the red boxes below. I'm confident my calculated field [Current 3 month Utilization] is correct, but I not sure how to adjust the compute using field.

• 3. Re: Compute using HELP!

What I was looking for was this:  What number should the calc come up with for AMER?  And for GSF?

I could spend some time trying to figure out what it's doing in there, but you would be helping me to help you to know what I'm aiming for without that.

• 4. Re: Compute using HELP!

And tell me how you are arriving at that number, of course.

• 5. Re: Compute using HELP!

Doh!

I understand what you are saying now..License for AMER should be 71%, APAC should be 0%, EMEA should be 71%, and GDF should be 71%.

THANK YOU SO MUCH FOR YOUR HELP, JOE!

• 6. Re: Compute using HELP!

and how do we arrive at those numbers?  I want to make sure your calc is actually doing what you want it to do.

• 7. Re: Compute using HELP!

Hi Joe,

My calculation should be calculating the EASy Utilization for the current rolling 3 months which is driven by the Date parameter. For example, the parameter is set on March 31st, 2016, my table calc would look at  only Jan, Feb, and March 2016.

So for AMER, when I look at the source data, the utilization should be 71% as I have 5 orders out of 7 that went through EASy.

I hope that help and it is clear.

• 8. Re: Compute using HELP!

Sorry.  I've been tied up.

See attached.

If I understand correctly, you want the number of orders within EASY and within the time frame and within a category, divided by the number of orders within that time frame in that category.

I created separate calcs to make those two values, and a third to do the division.  Threw them all on the measures.

Sheet2 is just a copy, but I added a calc to null out the zero values so they don't show.

You can combine all this into one calc, but I compartmentalized it to show step-by-step.

• 9. Re: Compute using HELP!

Awesome, Joe!

Thank you so much for your time!