The Spotfire Community is moving to TIBCOmmunity and this forum location has closed. During the transition, you can still search the old forums but posting has been disabled. We encourage you to pick up the discussion at the new Spotfire community on TIBCOmmunity.
Conditional Coloring to Highlight Top and Bottom Values - Tip of the Week

Tip of the Week

Conditional Coloring to Highlight Top and Bottom Values

In this week's post, we will introduce you to another excited new feature of TIBCO Spotfire 3.1, Conditional Coloring.  Let’s assume you have a Data Table which provides sales data for a particular store. The sales are broken up into three separate product categories: Furniture, Office Supplies, and Technology, and sales are measured across the different store locations per state.

Let’s assume we want to highlight the top 5 sales result and the bottom 5 sales result for the combination of products and states. To do this, we can use TIBCO Spotfire’s Conditional Coloring to color the top 5 values green and the bottom 5 values red.

We configure these settings inside the Color section of the Table’s Properties Dialog. First we create a Color Scheme Group that includes all the product columns: Furniture, Office Supplies, and Technology. We then add a Conditional Coloring rule, using the ‘Add Rule’ button and select the Top rule and set the value to 5 as shown below:

This will then color the table so that the top 5 highest sales are colored green.

As you can see, all 5 are from the office supplies column. What if we wanted to see the top 5 for each product? We then change the color scaling for this group to be by Column.

The result now shows the top 5 sales in each product colored.


We can now repeat this, but using the Bottom rule instead of Top to color the bottom 5 sales in each product red.


Some of the additional benefits of using the Conditional Coloring Rules are that the coloring is updated to reflect the changes in the data , including filtering.  In addition, you can expose the values for top and bottom as Property Controls so that the business user can alter the values when desired.  

In the screen shot below, you can see we exposed the top and bottom values as a slider control to let the user define how many values to color.


More details on Conditional Coloring, including Color Schemes, Color Scaling, Using Expressions in Coloring, additional Conditional Coloring Rules, and other updates are discussed in detail in both the 3.1 Delta Training Course and the TIBCO Spotfire Business Author Bootcamp.




Rich Ellis said:

Can conditional coloring be applied to an entire row, or just a single column?  I'd like to be able to identify a row by a special value in one column (say a "status" column with values of "pass" or "fail") and have the color highlight the entire row -- to make it even more obvious when scanning through the data.

April 13, 2010 5:49 PM

Tip of the Week said:

In previous posts , we have discussed the use of conditional coloring to color based off rules such as

May 9, 2010 8:21 PM

Knowledge Base said:

In previous posts , we have discussed the use of conditional coloring to color based off rules such as

May 9, 2010 9:20 PM

mianzubair said:

@Rich Ellis ... did you get the answer to your question ? i am looking for the same, i-e color code a complete row based on the value of one column.


August 4, 2011 3:19 PM

uggkensington said: | UGG Fox Fur Short Boots 5531 | UGG Kensington Boots 5678 | UGG Rainier Eskimo Boots 5189 | UGG Retro Cargo Boots 1895

December 27, 2011 8:13 PM

uggskensingtonsale said:

www.uggskensingtonsale.orgugg-adirondack-boots-ii-c-6.html | UGG Adirondack Boots II

www.uggskensingtonsale.orgugg-adirondack-tall-boots-c-11.html | UGG Adirondack Tall Boots

www.uggskensingtonsale.orgugg-amberlee-boots-c-34.html | UGG Amberlee Boots

www.uggskensingtonsale.orgugg-annabelle-boots-c-35.html |

December 28, 2011 4:07 AM

uggretrocargosale said:

January 4, 2012 8:50 PM

Newman said:

Greetings from Idaho! I'm bored to death at work so I decided to check out your site on my iphone during lunch break. I enjoy the info you present here and can't wait to take a look when

I get home. I'm amazed at how quick your blog loaded on my phone .. I'm not even using WIFI, just 3G .

. Anyhow, great blog!

November 21, 2012 7:14 PM

Kendrick said:

Horoscope gratuit taureau du jour tirage gratuit tarots

de marseille

July 7, 2013 2:55 AM

White said:

Voyance amour gratuite par email horoscope gratuit capricorne 2011

July 12, 2013 12:29 PM

Loper said:

Horoscope amour du mois tirage en ligne gratuit du tarot de


July 13, 2013 4:55 AM

Mojica said:

L independant horoscope judith voyance

July 13, 2013 12:35 PM

Slater said:

Institut formation sophrologie dresseur canin formation

July 14, 2013 5:12 AM

Melvin said:

Formation creation site internet formation dentaire

July 14, 2013 6:31 PM

Alston said:

Horoscope femina gratuit belline gratuit

July 19, 2013 3:15 AM

Lightner said:

Horoscope chinois pour 2012 voyance sur internet

July 19, 2013 8:58 PM

Cronin said:

La numerologie gratuite voyance gratuite par mail en direct

July 20, 2013 5:45 PM

Lanham said:

Had you thought-about having nests of different

tables for a coffee table? When I lived in my

college room, because it was super small, I wound up making use of them all the time and they are awesome

July 31, 2013 11:44 AM

Fender said:

In this week's of Tarou's weekly WoW Report, I'll cover ingame news, Patch 4. In World of Warcraft take that to the next one directly into your email by clicking the link in the description below. Because of the fact that it isn't really about sex 1:45.

I want every player to enjoy WoW just as much as $6 to $8 per click,

according to people like /s@.

August 2, 2013 1:05 PM

Kohler said:

Voyantes connues affinite des signes astrologiques

August 5, 2013 6:48 PM

Easley said:

She was gone before the Policeman could think about what to think about,

concerning rainwater attire and overcoats so you can ensure your footage is right-side-up.

Driving on tyres when they are cruising down the crowded highway safely as motorbike the police officer bends down to talk to the MCs in your area.

August 7, 2013 11:15 PM

Barker said:

Horoscope du jour taureau gratuit tirages tarots denis lapierre

August 10, 2013 4:20 AM

Allison said:

Tirage tarots gratuit horoscope jour sagittaire

August 10, 2013 8:15 AM

Schindler said:

Verseaux horoscope tirage tarot des anges gratuit

August 10, 2013 1:27 PM

Holliman said:

Tirage des cartes gratuitement horoscope michelle perras

August 16, 2013 10:20 AM

Hightower said:

Tarot denis compatibilite signe astrologique et ascendant

August 17, 2013 12:15 AM

Whittington said:

Voyance gratuite en direct par mail oracles et tarots

August 19, 2013 2:52 AM

Slade said:

Astro magazine horoscope du jour signe sagittaire

August 19, 2013 5:34 AM

Norfleet said:

Les plus grands voyants ton avenir par le tarot de marseille

August 20, 2013 6:39 PM

Fields said:

Vieille porno v ideo sexe

August 22, 2013 4:39 AM

Willett said:

Horoscope chinois calcul horoscope taureau 2012 amour

August 27, 2013 10:59 PM

Mcnutt said:

Hello! I could have sworn I've visited this web site before but

after looking at some of the posts I realized it's

new to me. Anyways, I'm certainly pleased I came across it and I'll be book-marking it and checking

back often!

August 29, 2013 8:50 AM

Shanahan said:

Signe zodiaque date peepshow voyance pas chere

August 29, 2013 10:27 AM

Creamer said:

Consulter une voyante gratuitement nudist asiaflash compatibilite amoureuse

August 30, 2013 5:39 AM

Barrows said:

Hello, I enjoy reading all of your article post. I wanted to write

a little comment to support you.

September 5, 2013 4:44 AM

Suarez said:

Thank you for the auspicious writeup. It in fact was a amusement

account it. Look advanced to far added agreeable from you! By the way, how could we communicate?

September 5, 2013 6:55 PM

Stratton said:

Hi, I do think this is an excellent site. I stumbledupon it ;) I may come

back yet again since i have book marked it. Money and

freedom is the best way to change, may you be rich and continue to help others.

September 5, 2013 11:35 PM

Clarkson said:

Hi there everybody, here every one is sharing such knowledge,

therefore it's nice to read this website,

and I used to visit this web site all the time.

September 10, 2013 5:53 AM

Fite said:

Wow, this paragraph is fastidious, my sister is analyzing such things, thus I am going to tell her.

September 10, 2013 7:45 AM

Rutledge said:

Hi! I know this is kind of off topic but I was wondering

if you knew where I could locate a captcha plugin for

my comment form? I'm using the same blog platform as yours and I'm having difficulty finding one?

Thanks a lot!

September 15, 2013 2:50 AM

Hoy said:

Great information. Lucky me I recently found your site by accident (stumbleupon).

I have saved it for later!

September 15, 2013 3:02 AM

Pearce said:

Horoscope belier du jour gratuit oracle en ligne gratuit

September 17, 2013 8:17 AM

Pena said:

I know this if off topic but I'm looking into starting

my own weblog and was curious what all is required to get setup?

I'm assuming having a blog like yours would cost a pretty penny?

I'm not very web smart so I'm not 100% certain.

Any suggestions or advice would be greatly appreciated.

Appreciate it

September 18, 2013 7:20 AM

Vaughan said:

Every weekend i used to visit this site, beccause i want enjoyment, ass this this website

conations genuinely nice funny data too.

September 18, 2013 6:03 PM

De Chair said:

Hidden camera masturbation amateur clip porn

September 18, 2013 11:45 PM

Whish said:

Sexe tirez moi sex toyes

September 19, 2013 4:49 PM

Scullin said:

This web site certainly has all the information and facts I wanted concerning this subject and didn't know who

to ask.

September 20, 2013 10:48 PM

Metz said:

tarot bilbao cartas del tarot del si o no

September 22, 2013 10:05 PM

Tomasini said:

gabinetes de tarot free tarot fortune telling

September 23, 2013 6:15 AM

Moriarty said:

Horoscope lion gratuit 2012 horoscope vierge

September 25, 2013 1:38 AM

Opitz said:

Tirage de madame indira horoscope

September 25, 2013 4:37 AM

Gosselin said:

devis travaux renovation appartement devis en

ligne fenetre

September 28, 2013 1:27 PM

Moncrieff said:

I've been exploring for a little bit for any high quality articles or weblog posts on this sort

of area . Exploring in Yahoo I eventually stumbled

upon this web site. Reading this information So i'm satisfied to show that I've a very good uncanny feeling I

came upon exactly what I needed. I so much undoubtedly will make certain to

don?t omit this web site and give it a look regularly.

September 30, 2013 12:08 AM

Wessel said:

What's up to every body, it's my first pay a quick visit of this blog; this web site includes remarkable and genuinely good data in support

of visitors.

September 30, 2013 2:11 AM

Reiter said:

Thanks for ones marvelous posting! I certainly enjoyed reading it, you may be a great author.I will be sure to

bookmark your blog and will often come back down the road.

I want to encourage you to ultimately continue your great posts, have a nice evening!

September 30, 2013 2:18 AM

Duggan said:

las cartas del tarot del amor gratis consulta tarot gratis por chat

September 30, 2013 9:28 PM

Baca said:

Hi! Someone in my Myspace group shared this site with us

so I came to check it out. I'm definitely enjoying the information.

I'm book-marking and will be tweeting this to my followers!

Outstanding blog and amazing design.

October 1, 2013 10:27 PM

Dixson said:

whoah this weblog is magnificent i like studying your

posts. Keep up the good work! You already know,

many persons are hunting around for this

info, you can help them greatly.

October 3, 2013 5:30 PM

Boisvert said:

It's in fact very complicated in this active life to listen news on TV, thus I

simply use the web for that purpose, and take the newest information.

October 3, 2013 7:01 PM

Reichert said:

I am really loving the theme/design of your blog.

Do you ever run into any browser compatibility issues?

A small number of my blog audience have complained about my

site not working correctly in Explorer but looks

great in Safari. Do you have any solutions to help fix this


October 3, 2013 9:42 PM

Agaundo said:

My relatives every time say that I am wasting my time here at web, but I

know I am getting knowledge everyday by reading such good articles or reviews.

October 3, 2013 11:50 PM

Addis said:

Hi to all, since I am in fact eager of reading this blog's post to be updated on a regular basis.

It consists of fastidious material.

October 4, 2013 4:37 AM

Cade said:

Hi, i read your blog occasionally and i own a similar one and i

was just curious if you get a lot of spam remarks?

If so how do you protect against it, any plugin or anything you can advise?

I get so much lately it's driving me crazy so any help is very

much appreciated.

October 5, 2013 2:36 PM

Ziesemer said:

I know this if off topic but I'm looking into starting my own blog and was curious what all is needed to get setup?

I'm assuming having a blog like yours would cost a pretty penny?

I'm not very web smart so I'm not 100% positive. Any

recommendations or advice would be greatly appreciated. Many thanks

October 5, 2013 5:20 PM

Bigge said:

Hurrah, that's what I was seeking for, what a material!

present here at this website, thanks admin of this website.

October 6, 2013 2:37 AM

O'Neill said:

I every time emailed this web site post page to all my friends, since if like

to read it then my contacts will too.

October 10, 2013 10:47 AM

Provost said:

Yes! Finally something about fish.

October 12, 2013 11:57 PM

Considine said:

I blog often and I genuinely appreciate your information.

The article has truly peaked my interest. I'm going to take a note

of your site and keep checking for new information

about once per week. I opted in for your RSS feed too.

October 13, 2013 1:55 AM

Leave a Comment



Other Spotfire Blogs

©Copyright 2000-2011 TIBCO Software Inc | Privacy Policy | Terms of Use I Blog I Contact Us I Content Center