One thing we all agree - Big IronPython codes are boomerang. They Always Come Back to Developer 🥺
The real problem is there is no perfect code ☹️,
What we can do is - do a better Error Reporting to minimize time required to pin point issue. For this purpose, I usually take help of traceback and NotificationService Modules...
Dynamic Links in Spotfire
My friend asked me recently -
"I need to trigger a URL from Spotfire, where URL should change as per User inputs"
Interesting 🤓
Usually when people try doing it from IronPython webbrowser code, It doesn't work in Webplayer. So we need something which works everywhere 🙂
To do this, I will...
Adding Styles to Date Picker
While working with date range filters, date-pickers are very helpful. They allow to select date ranges of our interest in a very convenient manner. They are nice right ??
Well what about this one ?
💡 Liked it? Then add this code to a HTML Text area to have this look and feel -
<style>
.DatePicker...
Styles for Tooltip
Tooltips in Spotfire are great for showing insights on mouse over. We use them a lot for showing information which should appear only when we need. But what if you feel that their look and feel is not matching with you theme ?
Question here is - How to add Style to tooltips ? 🤔🤔
Answer is, below...
Conditional Coloring of Spotfire Buttons
My friend was willing to color Spotfire Action buttons based on a value.
It is a small but effective way of representation. You will actually come to know what are your expectations even before clicking on a color coded button.
Challenge here, This color should be picked automatically
Challenge Accepted...
Show/Hide Pages with a Button
A friend from Community asked for a Button to toggle visibility of a Spotfire page.
So, this post is about same 😎Lets Start -
Create a button in TextArea with id Hider. If you are suffering from HTML Sanitization, you can use my alternative code. This one re-purposes span as button 😜<span...
Capturing Hierarchy Axis Changes to Document Property
My friend recently asked an Interesting Question -
I have a chart where I am using a Hierarchy as Category Axis. I want to capture changes in that Axis (Hierarchy) to a Property Control. Is there a way to do this ?
Sounds interesting 🙃
Well , Let's start doing it !
Add a Input field property...
Adding some styles to Notifications
Default Notifications Dialog is boring!
Agree?
If yes, then this post is for you. Try Adding below code to a text area and then have a look at notifications again-
<style id="AlienBox">
.sf-modal-dialog-content textarea {
color: azure;
background-color: brown;
}
.sfc-default-theme.sf-element-modal-dialog...
Interacting with Subsets with IronPython
What if you have to compare All Data with current Selections (Marking, Filtering etc.) ?
What if you have to compare your two selections?
I know answer will be - using (Subsets).
But, What If you want to make this comparison on-Demand only ?
My Answer is below IronPython code -
from Spotfire.Dxp.Application.Visuals...
Adding Styles to Legend Area
Recently I have posted a few ways to style different Spotfire elements. Now I have one more, for Legends this time.
This is what I have been able to achieve so far -
Here is the code you need to Add to one of the HTML Text Area -
<style id="AlienBox">
.StyledScrollbar.LegendScroll {
...
Display Current User Information on Menu Bar
I recently posted about how to add Information to Menu Bar . I have been asked on LinkedIn - "How to display Current Logged in Username here ?"
I will not say it is difficult, but involves a little more number of steps, because we have to use some extra steps to get current user details as well.
So,...
Utilizing Space under Legends for Additional Information
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;
...