Secondary Axis

[Katie Sikorski]

I Created a Custom Expression for a Combination Chart that works great, see example below.

 

Sum(If([ARLP]="Y",1,0)) as [ARLP],

Count() as [bASIN]

 

Is there a way to do a secondary axis where you take ARLP/Basin for a percentage I have been playing with the Y axis and I can't seem to make it work has anyone done this Or can you add a calculated Column to a exiting chart Please let me know. I tried the Case statement but the expression worked better. I loaded an example of Excel that I am trying to replicate in Spotfire.

 

Thanks ahead of time

[Kirsten Smith (she/her)]

Adding this expression to your y-axis seems to do the trick:

 

Sum(If([ARLP]="Y",1,0)) / Count() * 100 as [Pct]