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.
Using the Repeat Expression Function to Create Horizontal Bars - Tip of the Week

Tip of the Week

Using the Repeat Expression Function to Create Horizontal Bars

We do not have a visualization which allows horizontal bars, however, you can create an expression which would create a pseudo horizontal bar in a Table based plot.  This is possible using the Repeat function available in TIBCO Spotfire version 3.1 for constructing an expression.

Let’s assume we have the following data loaded in Spotfire:


We can then create a calculated column using the following expression:

    Repeat(“█”,integer(10*[Col A]/Range([Col A])))

The Repeat function allows you to repeat a string a specified amount of times.  For the string, we use the ASCII delete character, █.  To specify the number of times to repeat, you can use any calculation as long as it outputs an integer.

In this example, we divide the value from Col A by the Range of Col A, then multiply by 10 and finally cast to an integer.

The result?



harald dauwa-stummer said:

cool stuff !

March 22, 2010 10:48 AM

ted_snyder said:


March 24, 2010 4:36 PM

dathey said:


That's a cool trick!  It reminds me a little bit of the Tufte sparklines...


March 27, 2010 8:17 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:02 AM

uggretrocargosale said:

January 4, 2012 8:50 PM

Hamer said:

Horoscope d aujourd *** cancer horoscope du mois de septembre

July 7, 2013 12:44 AM

Thibodeau said:

Dates horoscope chinois horoscope capricorne demain

July 13, 2013 5:15 AM

Cantrell said:

Formation boulanger formation couvreur zingueur

July 14, 2013 4:17 AM

Bruno said:

Cochon astrologie chinoise horoscope avril gemeaux

July 14, 2013 10:30 AM

Mccurdy said:

Comment financer une formation formation animateur social

July 14, 2013 11:24 AM

Thorton said:

Voyance indienne horoscope gratuits 2012

July 14, 2013 2:38 PM

Schaeffer said:

Auxiliaire puericultrice formation formation arabe

July 14, 2013 3:40 PM

Boston said:

Tarot de gratuit boobs tirages de tarots de marseille gratuits

July 15, 2013 6:52 AM

Saddler said:

Tarot divinatoire gratuit 2011 horoscope cancer ascendant


July 17, 2013 1:57 PM

Mcintyre said:

Horoscope du jour vierge homme astro center consultation express

July 20, 2013 12:58 PM

Mccleary said:

Theme astral gratuit interpretation

July 21, 2013 5:11 AM

Lawless said:

These systems tend to be simplex, meaning that the motorbike can be adapted to the needs and preferences of the user in a perfect manner.

A motorbike inspired by a bicycle kick - it seems rather fitting.

You can finally secure the financing that you need a power source, there is not enough surface area between the wheel rim and push rim.

When we go to, disposal efficiency and disposal time on your new bike.

Bicycle helmets commonly feature an elongated shape that protects your head from

hard blows on the ground under hard braking.

August 6, 2013 8:14 AM

Shipley said:

Belier signe astrologique site de voyance

August 6, 2013 10:49 PM

Justice said:

Tarot et oracles gratuit tarots de marseille denis lapierre

August 9, 2013 10:49 AM

Reyna said:

Runes tarot calcul signe astrologique chinois

August 9, 2013 10:44 PM

Mcwilliams said:

Horoscope semaine prochaine symbole astrologique

August 10, 2013 5:22 PM

Mcqueen said:

Tarot gratuit lambert tarots divinatoires gratuits denis lapierre

August 16, 2013 3:44 AM

Black said:

Compatibilite amitie astrologique logiciel de

voyance gratuit

August 16, 2013 11:10 AM

Shafer said:

Horoscope gratuit 2008 signe astrologique calendrier

August 19, 2013 3:40 AM

Howland said:

Tarot des anges signification signification des

signes du zodiaque

August 19, 2013 4:38 PM

Babin said:

Compatibilites signes astrologiques horoscope annee

August 21, 2013 10:44 AM

Jose said:

Rencontrer lesbienne femme mure pour sex

August 24, 2013 8:05 PM

Corona said:

Horoscope verseau avril *** voyance et tarot


August 25, 2013 11:20 PM

Vaughn said:

Oracle belline gratuit en ligne tirer les cartes tarot gratuit

August 28, 2013 3:01 PM

Webber said:

Calculer l ascendant de son signe astrologique horoscope avec date

September 17, 2013 8:49 AM

Swanson said:

Tirage du tarot de marseille gratuit en ligne horoscope

pour aujourd ***

September 17, 2013 9:13 AM

Grover said:

Virginie voyance horoscope date de naissance

September 18, 2013 7:49 AM

Rosetta said:

Free online anal movies matures voyeur

September 18, 2013 5:36 PM

Waldrup said:

Site porno vintage sex youtub

September 19, 2013 5:37 PM

Marshall said:

medium vidente tiradas del tarot gratis online

September 22, 2013 10:02 PM

Falcon said:

Horoscope balance hebdomadaire tarot gratuite en direct

September 24, 2013 8:13 PM

Roan said:

Ikki tousen porno streaming film adulte gratuit

September 29, 2013 12:13 PM

Warman said:

What is put options zapping sexe

September 30, 2013 5:16 PM

Montenegro said:

antique tarot cards tirada de tarot gratis alicia galvan

September 30, 2013 8:58 PM

Kemper said:

devis construction maison devis avant travaux

October 2, 2013 7:40 AM

Collado said:

tarot los arcanos gratis tarot amour gratuit

October 3, 2013 1:33 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