
1. Re: Compute using HELP!
Joe Oppelt Jun 27, 2016 11:28 AM (in response to Mikey Michaels)(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?


3. Re: Compute using HELP!
Joe Oppelt Jun 27, 2016 12:56 PM (in response to Mikey Michaels)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!
Joe Oppelt Jun 27, 2016 12:58 PM (in response to Joe Oppelt)And tell me how you are arriving at that number, of course.

5. Re: Compute using HELP!
Mikey Michaels Jun 27, 2016 2:06 PM (in response to Joe Oppelt)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%.
I made small adjustments to the Tableau report so please use the one on the attached.
THANK YOU SO MUCH FOR YOUR HELP, JOE!

Computed using Help (2).twbx 36.2 KB


6. Re: Compute using HELP!
Joe Oppelt Jun 27, 2016 2:11 PM (in response to Mikey Michaels)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!
Mikey Michaels Jun 27, 2016 2:38 PM (in response to Joe Oppelt)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!
Joe Oppelt Jun 28, 2016 2:06 PM (in response to Mikey Michaels)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 stepbystep.

Computed using Help (2) B.twbx 66.7 KB


9. Re: Compute using HELP!
Mikey Michaels Jun 28, 2016 5:32 PM (in response to Joe Oppelt)Awesome, Joe!
Thank you so much for your time!