3 Replies Latest reply on Jun 29, 2016 7:14 PM by Shinichiro Murakami

IF statement help

Mikey Michaels Jun 28, 2016 6:07 PM

Hello All,

I hope this message finds you all well.

I'm in need of some help. Here is what I'm trying to accomplish:

I'm trying to write an IF statement that will look at each category in my graph (License, ME&S, and Trial) and IF all categories for the Zone are above 60% THEN "Above Benchmark". IF <60% or blank then "Under Benchmark".

So on the attached, the only zone that meets this criteria is GSF

I'm struggling as I do not think the following is the best way to solve...."IF Category = "Trial" and EASy Utilization > .60 and Category - "ME&S" and EASy Utilization > .60......there has to be a better way!

Thanks for your time.

Regards,

Mikey

EASy_Rolling 3mo_HELP.twbx 41.0 KB

1. Re: IF statement help

Shinichiro Murakami Jun 28, 2016 7:04 PM (in response to Mikey Michaels)
Considering you are using version 8, only the way I know is creating multiple fields.
If you can upgrade, after, version 9.0 yo ucan use LOD to calculate same thing.

LOD
Overview: Level of Detail Expressions

[Order Value (USD) License]
if [Category]="License" then [Order Value (USD)] end

[Order Value (USD) ME&S]
if [Category]="ME&S" then [Order Value (USD)] end

[Order Value (USD) Trial]
if [Category]="Trial" then [Order Value (USD)] end

[EASy Utilization License]
IF ATTR([EASy?])="Yes" THEN COUNT([Order Value (USD) License]) / TOTAL(COUNT([Order Value (USD) License])) END

[EASy Utilization ME&S]
IF ATTR([EASy?])="Yes" THEN COUNT([Order Value (USD) ME&S]) / TOTAL(COUNT([Order Value (USD) ME&S])) EASy Utilization TrialEND

[EASy Utilization Trial]
IF ATTR([EASy?])="Yes" THEN COUNT([Order Value (USD) Trial]) / TOTAL(COUNT([Order Value (USD) Trial])) END

Then,

[Calculation2]
IF ([EASy Utilization License]) > 0.6
and [EASy Utilization ME&S] >0.6
and [EASy Utilization Trial] > 0.6
THEN "Above Benchmark"
END

Thanks,
Shin

8.3 attached.

EASy_Rolling 3mo_HELP 8.3.twbx 41.5 KB
Like Show 1 Likes(1)

Actions
2. Re: IF statement help

Mikey Michaels Jun 29, 2016 6:43 PM (in response to Shinichiro Murakami)

Thank you so much, SHIN!
Like Show 0 Likes(0)

Actions
3. Re: IF statement help

Shinichiro Murakami Jun 29, 2016 7:14 PM (in response to Mikey Michaels)

You are welcome.
Hope you can get version 9.0 or higher soon.

Shin
Like Show 0 Likes(0)

Actions

Go to original post

Tableau Community Forums

IF statement help

1. Re: IF statement help

2. Re: IF statement help

3. Re: IF statement help

Actions

More Like This