My script below performs sorting with Sum(ColA), but does not work with Sum(ColA) / Sum(ColB) or Avg(ColA). How to make it work? Thanks

[ron quach 2]

from Spotfire.Dxp.Application.Visuals import CategoryKey

from Spotfire.Dxp.Application.Visuals import CombinationChart

myCategoryKey1=CategoryKey("Sum(ColA)")

#Perform sorting

vis.As[CombinationChart]().SortBy=myCategoryKey1

[Heleen Snelting]

Hi @ron quach​ would it be possible to share the dxp? Include a small dummy dataset representative of what you are using? It will then be easier for anyone looking at this to provide more specific script troubleshooting suggestions. Its not clear what type of error messages you are getting for example.

Thanks!

Heleen

[ron quach 2]

Hi Hellen,

Here is the sample dxp. The script will sort the combo chart "Sort x-axis by" ok with myCategoryKey1=CategoryKey("Sum(Out)"),

but it incorrectly sorts if I use myCategoryKey2=CategoryKey("Sum(Out)/Sum(In)") . Sum(Out)/Sum(In) = Yield %.

Thanks

Ron

Use Script it has incorrect Sort by Yield% or Sum(Out)/Sum(In)

 

Use "sort x-asis by" has correct sort by Yield% or Sum(Out)/Sum(In)



[Gaia Paolini]

myCategoryKey=CategoryKey('Yield %')

[ron quach 2]

Thanks Gaia. It works.

I want to select any Y-Axis value, IN, OUT, Yield %, from the list box ${SortOpitons} then sort it, but it does not work.

Please help.

Thanks

Ron

Script

from Spotfire.Dxp.Application.Visuals import CategoryKey

from Spotfire.Dxp.Application.Visuals import CombinationChart

#Define sorting myCategoryKey

# myCategoryKey1=CategoryKey("Sum(Out)")

myCategoryKey2=CategoryKey("${SortOpitons}")

#Perform sorting

vis.As[CombinationChart]().SortBy=myCategoryKey2

[Gaia Paolini]

The document property needs to go into the script as an input parameter. I changed the values assigned to the drop down list (I don't think the as [..] construct works (there is no need for that anyway), and Yield % needs to be referred as such, re: my previous answer (I am not sure why, but since it works manually, it will work in a script).

Attached the modified dxp.

[ron quach 2]

I cannot open your dxp. Please check if my doc property as script input parameter is correct.

Thanks

Ron

[Gaia Paolini]

This is the setting inside the drop down list:

This is the script: the sort input variable was correctly defined but it does not need to be surrounded by quotes:

[ron quach 2]

Hi Gaia,

I followed yours, but it is still did not work. I attach dxp for you to check.

thanks

Ron

 



[Gaia Paolini]

I think the issue is still what you choose as value (Expression) in your dropdown. 

You need to look at what the manual options are and set them exactly the same way in your dropdown -> script.

So if you open your chart's Properties, go to Appearance, you see what is listed under Sort x-axis by: 

That is what you want to use in your dropdown. I see your options are now 'IN', 'OUT' and 'Yield %'.

I don't mean the Display Name (what people see), I mean the actual Expression (what is sent to the script.)

[ron quach 2]

It works now. Thank you very much Gaia It is trickly. I thought sorting X-Axis in the appearance need the formula like Y-Axis in combo chart.