Is there an easy way in Spotfire 12.0.0 LTS to get a different axis scale in a scatter or line plot? There's just the default "linear" and the option "logarithmic". I would like to get "normal probability scale" as in the python library mpl-probscale.

[Funny Cat]

[Fredrik Rosell]

Hello!

I'm afraid the answer is no - there is currently no way to do that, but it's a very valid idea, so I recommend that you create/vote for it in the Ideas Portal. There is e.g. an existing idea for Probability Scale - https://ideas.tibco.com/ideas/SPF-I-5153.

 

[Funny Cat]

Thanks for the answer.

My current workaround is to plot the z-score instead and add horizontal lines for the % values I want to show.

However, the solution is not very nice, since the position of the annotation is changing depending on display resolution/chart size, so it's not obvious which line has which value (however I added the values in the tooltip, so at least you can hover over the lines to see the percentages)

 

For those who are interested how to do this automatically:

• make a list of percentages you want to display e.g. in excel, and name the column percentage
• calculate the z-score (in Excel using the function NORM.S.INV, or use the NormInv function of Spotfire) and name the column zscore
• In the column properties, set the formatting of the column percentage to 0.### %
• Add the following script, create the parameter vis and set it to your probability plot. Then run it:

from Spotfire.Dxp.Application.Visuals import *from System.Drawing import *from Spotfire.Dxp.Data import * #Add the parameter vis - and set the value to your probability plotvc = vis.As[VisualContent]() # remove old percentage lines (in case you have to adjust the lines more than once)for fm in vc.FittingModels: if '%' in fm.Line.DisplayName: vc.FittingModels.Remove(fm) #define data table and se the cursors to the table columnseTable=Document.Data.Tables["zscore-percentage"]cur_p = DataValueCursor.CreateFormatted(eTable.Columns["percentage"])cur_z = DataValueCursor.CreateFormatted(eTable.Columns["zscore"]) #run through table to get the values and draw the linesfor row in eTable.GetRows(cur_p, cur_z): p = cur_p.CurrentValue.replace(",",".") z = cur_z.CurrentValue.replace(",",".") #print p,z  #draw lines horizontalLine=vc.FittingModels.AddHorizontalLine(z) myLine=horizontalLine.Line myLine.LineStyle=LineStyle.Dot myLine.Width=1 myLine.IsBackground=True myLine.CustomDisplayName=p labels_tooltips=horizontalLine.Line.Details #print lt.Name,lt.DisplayName,lt.ShowInLabel,lt.ShowInTooltip for lt in labels_tooltips: if lt.Name=='Name': lt.ShowInLabel=False if lt.Name=='y': lt.ShowInTooltip=False if p in ['0.1 %', '1 %', '10 %', '50 %', '90 %', '99 %', '99.9 %']: myLine.Color=Color.Gray for lt in labels_tooltips: if lt.Name=='Name': lt.ShowInLabel=True else: myLine.Color=Color.LightGray