Ufdjrw

How to get directions in deep space?

What to do when eye contact makes your coworker uncomfortable?

Change the color of a single dot in `ddot` symbol

What's the name of the logical fallacy where a debater extends a statement far beyond the original statement to make it true?

Which was the first story featuring espers?

Why does this expression simplify as such?

Why do Radio Buttons not fill the entire outer circle?

When were female captains banned from Starfleet?

Short story about a deaf man, who cuts people tongues

Is it allowed to activate the ability of multiple planeswalkers in a single turn?

Biological Blimps: Propulsion

What are some good ways to treat frozen vegetables such that they behave like fresh vegetables when stir frying them?

What does Apple's new App Store requirement mean

Why is it that I can sometimes guess the next note?

Why does AES have exactly 10 rounds for a 128-bit key, 12 for 192 bits and 14 for a 256-bit key size?

Are Captain Marvel's powers affected by Thanos breaking the Tesseract and claiming the stone?

Will number of steps recorded on FitBit/any fitness tracker add up distance in PokemonGo?

Has the laser at Magurele, Romania reached a tenth of the Sun's power?

Why Shazam when there is already Superman?

Why does Carol not get rid of the Kree symbol on her suit when she changes its colours?

Were Persian-Median kings illiterate?

Why is the "ls" command showing permissions of files in a FAT32 partition?

What is the English pronunciation of "pain au chocolat"?

Quoting Keynes in a lecture

how to show top 5 customer id in color or any python script in spotfire

can any one suggest me iron python script to show top 10 values in spotfireIn Spotfire, how to trellis a SummaryTable using IronPython scriptHow to access Spotfire expression values using IronPython scriptHow do I programmatically change the column referenced by Column Values Line in Spotfire?Spotfire - Dividing one row value with another in a cross tableHow to access cross table columns in iron python scriptHow am I able to get values from a column in spotfire tables using Iron Python scripting?Spotfire - Custom sub totalHow to access a Calculated Value from python?Marked Items in Horizontal Chart matching with created details visualizationChange column header depending on marked row on Spotfire

0

I have cross table as shown in the attachment.

I used "color by" property to show top 5 electronics values.

I would like to show top 5 customer id(vertical axis) also in a color representation.

Can any one help me on this.

Kindly give me idea how to show top 5 customer id in color or any python script.

Regards
Naveen

ironpython spotfire

share|improve this question

edited Mar 7 at 5:05

hoangdv

1,8741614

asked Mar 7 at 3:29

rajutibco35rajutibco35

1

add a comment | 

0

I have cross table as shown in the attachment.

I used "color by" property to show top 5 electronics values.

I would like to show top 5 customer id(vertical axis) also in a color representation.

Can any one help me on this.

Kindly give me idea how to show top 5 customer id in color or any python script.

Regards
Naveen

ironpython spotfire

share|improve this question

edited Mar 7 at 5:05

hoangdv

1,8741614

asked Mar 7 at 3:29

rajutibco35rajutibco35

1

add a comment | 

I have cross table as shown in the attachment.

I used "color by" property to show top 5 electronics values.

I would like to show top 5 customer id(vertical axis) also in a color representation.

Can any one help me on this.

Kindly give me idea how to show top 5 customer id in color or any python script.

Regards
Naveen

ironpython spotfire

share|improve this question

edited Mar 7 at 5:05

hoangdv

1,8741614

asked Mar 7 at 3:29

rajutibco35rajutibco35

1

share|improve this question

edited Mar 7 at 5:05

hoangdv

1,8741614

asked Mar 7 at 3:29

rajutibco35rajutibco35

1

share|improve this question

edited Mar 7 at 5:05

hoangdv

1,8741614

asked Mar 7 at 3:29

rajutibco35rajutibco35

1

edited Mar 7 at 5:05

hoangdv

1,8741614

edited Mar 7 at 5:05

hoangdv

1,8741614

asked Mar 7 at 3:29

rajutibco35rajutibco35

1

asked Mar 7 at 3:29

rajutibco35rajutibco35

1

1 Answer
1

active

oldest

votes

1

a new Calculated Column using the Rank() function coupled with a Limit By expression can handle this for you.

1. create a new Caluclated Column called [Rank] with the expression Rank([column])
   


2. on the visualization properties, on the Data page, where it says Limit Data by Expression, use the expression [Rank] <=5
   

share|improve this answer

answered Mar 8 at 19:15

nikoniko

3,069719

add a comment | 

Your Answer

StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");

StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);



);

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55035597%2fhow-to-show-top-5-customer-id-in-color-or-any-python-script-in-spotfire%23new-answer', 'question_page');

);

Post as a guest

Name

Email

Required, but never shown

1

a new Calculated Column using the Rank() function coupled with a Limit By expression can handle this for you.

1. create a new Caluclated Column called [Rank] with the expression Rank([column])
   


2. on the visualization properties, on the Data page, where it says Limit Data by Expression, use the expression [Rank] <=5
   

share|improve this answer

answered Mar 8 at 19:15

nikoniko

3,069719

add a comment | 

1

a new Calculated Column using the Rank() function coupled with a Limit By expression can handle this for you.

1. create a new Caluclated Column called [Rank] with the expression Rank([column])
   


2. on the visualization properties, on the Data page, where it says Limit Data by Expression, use the expression [Rank] <=5
   

share|improve this answer

answered Mar 8 at 19:15

nikoniko

3,069719

add a comment | 

a new Calculated Column using the Rank() function coupled with a Limit By expression can handle this for you.

1. create a new Caluclated Column called [Rank] with the expression Rank([column])
   


2. on the visualization properties, on the Data page, where it says Limit Data by Expression, use the expression [Rank] <=5
   

share|improve this answer

answered Mar 8 at 19:15

nikoniko

3,069719

share|improve this answer

answered Mar 8 at 19:15

nikoniko

3,069719

answered Mar 8 at 19:15

nikoniko

3,069719

answered Mar 8 at 19:15

nikoniko

3,069719