This week, I worked on a dashboard where the user requested a snapshot of yesterday’s operational activities. The dashboard itself was simple enough, a single… Read More »Use Spotfire Date and Time Functions to Create a Dashboard
When I was writing for Ruths.ai, I authored a few posts on Spotfire’s Bookmarks, Tags, and Lists functions. I touched on bookmarks, but not bookmark… Read More »Rearrange Visualizations Using Bookmarks
Last week, my post explained a script from the Spotfire IronPython Quick Reference website that will add a bar chart to a page with IronPython.… Read More »Call Tables with IronPython in Spotfire
This is my third week working thru IronPython scripts from the Spotfire IronPython quick reference. Last week, we looked at for loops. The week before, we used IP to modify titles. This week, we’ll insert visualizations with IronPython and explore the API as we go. We’ll get started learning how to add a bar chart with IronPython to an analysis.
Read More »Add Bar Chart with IronPython
I was trying to wrap up a major project last week, and I wasn’t able to get my weekly post out. It’s really a rare… Read More »Learn to Use For Loops in IronPython
I promised a return to Spotfire API for IronPython posts, and that is finally happening. I had to get a few drafts cleared out, like 5 Ways to Approach Troubleshooting Data Problems, but now I’m back on track discussing how to change visualization titles with IronPython
In October last year, I committed to spending 100 hours learning IronPython. I wrote several “starter” IronPython posts, which can be found in the Data Shop Talk Archive. I have lost count of how much time I’ve spent on IronPython, but the clock starts again today.
My goals haven’t changed. They are still to ….
For the next several weeks, I’ll be using the code snippets posted on The Spotfire IronPython Quick Reference to explore the API. I’ll punctate that with an article here and there are the IronPython/Python structure as I go. Read on for this week’s code snippet.
Read More »Change Visualization Titles with IronPython
I’ve never found a great way to explain what I do. Analogies help right? The first analogous thing that pops into my head is a Rubix cube. My day to day work feels like trying to solve a Rubix cube over and over, and the cube is a big pile of dirty, messy data. Thus, much of my day to day is troubleshooting data wrangling problems.
Some days, it’s incredibly satisfying, as solving a Rubix cube is. Other days, I want to rip the stickers off and throw it out the window. When I drafted this post, I was in “rip the stickers off” mode. I was frustrated with how long it took to solve data wrangling problems. When I get in that mindset, I want to share what I learn so other people don’t suffer as much. Thus, this post discusses my top 5 ways to approach troubleshooting data problems. These methods will apply no matter what application you are working in or if the problem is related to data wrangling or logic problems. Read on for details.
Read More »5 Tip for Troubleshooting Data Wrangling ProblemsI know I said I would revert back to IronPython posts. But, I had to do a bit of TERR work this week that I… Read More »How to Add Calculated Columns With TERR
In Spotfire, there are two ways to change column names. You can modify the column names in Column Properties, or you can change them with Transformations. There are ramifications for which method you use, which I explained in this Data Shop Talk post. Now, speaking to Transformations….For years, I’ve been under the impression that you could only ever change one column name at a time. However, I recently found out that is not the case. It is possible to formulaically change multiple column names in one fell swoop (or expression…as it were). Let me show you how!
Read More »How to Change Multiple Column Names At Once
Welcome to part 7 of my Spotfire Data Limiting Series. The first post in the covered data limiting with the filter and data panels. The second post talked about data limiting in the web player. The third post discussed limiting using filtering schemes. Then, I covered limiting with marking, limiting with expressions, and limiting with subsets. This is the final post in the series discussing data limiting with rules.
Read More »Data Limiting with Rules