A few weeks ago, a user reached out with a question regarding an IronPython script he was using to change the formatting on visualizations. I’ve never used IronPython for this purpose, but it was fun to learn how to format visualizations with IronPython in Spotfire. And, I wanted to share. Read on to learn more.
Read More »How to Format Visualizations With IronPython
Welcome to Part 3 of my series on learning to manage analytics assets with Microsoft Azure DevOps (ADO). In Part 1, I explained how our analytics team works and why we needed an application to manage analytics assets. In Part 2, I talked ADO structure and terminology. This week, I’ll cover five questions to ask before setting up Azure DevOps to avoid rework. Read on to plan your ADO project.
Read More »5 Questions to Ask and Answer Before Setting Up Azure DevOpsA few weeks ago, I wrote a post on how to resolve query timeouts using batch macros. Shortly after publishing, Mark Frisch of CReW Macros reached out to me to say that my post wasn’t wrong (whew!), BUT there is another way to fix query timeouts without resorting to macros. It’s taken me a while to get around to it, but I wanted to share his solution as well. Read on to learn another way to solve query timeout issues in Alteryx.
Read More »Solve Query Timeout Issues in Alteryx
This week, I ran into a data engineering problem where I needed to extract a JV number from a string of numbers. The JV number can have 3,4, or 6 digits. For any number less than 6 digits, the system adds leading zeros. At first, I thought I needed to dig into some Regex, but there was a much simpler answer to remove leading zeros in Alteryx. Read on to add another tool to your Alteryx toolbox.
Read More »Remove Leading Zeros in AlteryxTIBCO designed Spotfire to bring data into the application, wrangle it into a useable form, and display visualizations for analysis. It’s not really designed to modify source data, but that doesn’t mean that people don’t want to or that you can’t. In fact, it’s easy to modify individual values in Spotfire if you know where to look, just like clicking on a cell in Excel. Read on for more information.
Read More »How to Modify Individual Values in Spotfire
Last week, I wrote a blog post on how to fix query timeouts in Alteryx, and part of that solution involved using Detour tools. But, Detour tools are so useful that I thought they deserved their own post. Read on to learn more about how to improve your Alteryx development with Detour tools.
Read More »Speed Up Alteryx Development With Detour ToolsOccasionally, I have a really hard time coming up with a good title for a post. This is one of those circumstances. But what I’m going to show you here is important if you want to sharpen your troubleshooting skills. A user reached out to me this week for help with a calculation on a cross table. It seemed like Spotfire was calculating inconsistently, but software doesn’t work that way. So, we had to be missing something. Would you have figured this out? How quickly would you have solved this puzzle? Can you find data hiding in Spotfire? Read on to learn more.
Read More »The Danger of Hiding Data in Spotfire
Last week, I built a large workflow while querying a subset of the data. With the workflow complete, I need to “open ‘er up”. However, doing so resulted in time-out errors. The query was so large it couldn’t complete. Transactional finance data….am I right??? I came up with two ways to solve this problem. Read on to learn how to fix query timeouts in Alteryx.
Read More »How to Fix Query Timeouts in Alteryx
Last week, I kicked off a series that explains how we manage analytics assets with Microsoft Azure DevOps (ADO). I started by providing background information on our team structure, how we work, and the type of work we do. This week, I will explain ADO structure to provide context for how we use it, which will be the next post.
Read More »Speaking the Azure DevOps Language
Spotfire does a good job of summarizing major changes each time a new release hits the deck. They always update the What’s New Page. But sometimes the change is either too small to include, or I just don’t get the time to go thru everything on that page. Occasionally, I just stumble upon updates. I don’t know when this feature was introduced, but I just noticed a “new to me” feature to help save space in Spotfire tooltips. Read more to find out what it is.
Read More »How to Save Space in Spotfire Tooltips