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?


Comments

 

harald dauwa-stummer said:

cool stuff !

March 22, 2010 10:48 AM
 

ted_snyder said:

Whoah....

March 24, 2010 4:36 PM
 

dathey said:

Kevin-

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

-Dave

March 27, 2010 8:17 PM
 

uggkensington said:

http://www.uggkensingtons.org/

http://www.uggkensingtons.org/ugg-fox-fur-short-boots-5531-c-54.html | UGG Fox Fur Short Boots 5531

http://www.uggkensingtons.org/ugg-kensington-boots-5678-c-2.html | UGG Kensington Boots 5678

http://www.uggkensingtons.org/ugg-rainier-eskimo-boots-5189-c-85.html | UGG Rainier Eskimo Boots 5189

http://www.uggkensingtons.org/ugg-retro-cargo-boots-1895-c-3.html | UGG Retro Cargo Boots 1895

December 27, 2011 8:13 PM
 

uggskensingtonsale said:

www.uggskensingtonsale.org

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

Leave a Comment

(required) 
(optional)
(required) 
Submit

Syndication

Other Spotfire Blogs

Spotfire's interactive information visualization and analytic solutions give users a remarkable experience for quickly and easily querying data and reporting results for superior business intelligence. From portfolio management and customer retention programs to key processes such as CRM, marketing, research, bioinformatics, yield and asset management and design for manufacturing, enterprises around the world rely on Spotfire's business analytics software to improve operational performance.

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