Have you ever struggled for little space for placing information and Just observed -"Hey! I have some under Legends!". But, That area is not available for editing.
What to do ?
Well, Remember I have shared a post about adding Information to Menu bar ? I have customized that to add some extra...
Add a Little Information to the Menu Bar
When I launched Spotfire today, I saw this menu bar-
Everything is right, but I felt I should add a little fun to this space. I tried to to add some information to it, and I think we can use same for Adding Dashboard Title as well (Anyways this bar remains there regardless of we use it or not) -
Here...
Deleting All visualizations meeting a Specific Condition
How to remove all visualizations meeting one criteria ?
Deleting Visualizations may be very useful in many situations. One example is, if we want to remove all Line Charts (may be I am not interested in trends at the moment). This is how it can be achieved -
from Spotfire.Dxp.Application.Visuals import *
for p in Document.Pages:
for v in p.Visuals:
if str(v.TypeId) == "TypeIdentifier:Spotfire.LineChart":...
Search within column - Limiting values in Property Control
Before we begin, I have a question. Why List Box filter is so special ?
Yes, you got it right! The search within column values. What if we want to implement something similar for List Box Property Control ?
We are going to do it today !!
Let's Start.
We are going to create a Input Field property...
Removing Duplicates - Efficient Way
Duplicates in any source are always painful. We are expecting unique records and we get a lot of duplicates there.
How to deal with them ?
Well, there are many ways bur most of the times they involve a lot of steps.
Here, I am going to give you an approach which involves just one Filter Rows Transformation...
Tracing Data Transformations from IronPython
Have you ever needed to gather details about transformations used in all Data Tables ? I know, you will go to Data Panel 👴
Now a twist - What If you have 20+ Data Tables ? Now you are getting irritated !
That's why we have IronPython ✌.
Although it is programmed to look for very basic details, but can be customized for more stuffs 💪
from Spotfire.Dxp.Data import *
from Spotfire.Dxp.Data.Transformations...
Executing IronPython Codes with Progress Bar
I had a code to reload data table (which takes long time) and end users were keep on hitting Action button as they were not sure if something is happening. Sounds familiar to you as well ?
What to do ?
Probably if they see a progress bar it will be better, right ? Well TIBCO Community already have a...
Be Fair with Filters Panel
I was looking at custom theme option in Spotfire -
Wait, What ?? I cannot customize Filters Panel from here !!
But, You already know I will 👽
With CSS code
<style>
.VirtualListBox .sf-element-list-box-item {
background-color: cadetblue;
color: floralwhite;
...
Elder Brothers of Table : Cross Table, Summary Table and Graphical Table
Recently I published an article about Styling Tables ,and then I observed something. Spotfire reuses the same class elements for most of Cross Table, Summary Table and Graphical. (Now we can understand why there are only a few customization options under Theme 😏)
Anyways, when we are styling stuffs...
Styling Table Visualization
Question : How to add CSS Styles to a Spotfire Table ?
Answer : I have a Code 😊
We need to add below code in a TextArea -
<style>
.sfc-style-root .sf-element-table-cell.sfpc-odd-row {
background-color: chocolate;
color: white;}
.sfc-style-root .sf-element-table-cell...
Beat that HTML Sanitization
I never liked HTML Sanitization in TIBCO Spotfire. Ever time I have a new CSS code to use, and damn -
What to do now ?
We have our savior : JavaScript. Wrap the style in this code and throw it as a JavaScript code -
if(!$('#AlienBox').length){
$('body').append($(`<style id="AlienBox">
//My...
New Spotfire X Transformations - Loading Filtered Data
As a Spotfire Developer, we use Data Limit using expressions many time. sometimes we feel "What if we can Limit whole Dashboard with a Simple Expression ?"
Well .. Spotfire X have made it possible. How ? Follow below steps -
Load Data.
Enable Data Canvas.
Select Data Table
Add Transformation
Select...
Styling Spotfire Action Buttons
Question: How to add Styles to Spotfire Action Buttons ?
Answer :
Just add this code to your text area and you are ready to customize from first moment -
<style>
.sfc-action-button {
color: #ffffff !important;
font-size: 26px !important;
height: 36px !important;
background-color: #858585!important;
background-image:...