Julie Sebby

How to Reduce the Size of an Alteryx Data Set

I love that I can run huge amounts of data thru Alteryx. However, I also have to think about how much data I’m going to take from Alteryx and push to a BI application like Spotfire or PowerBI. As a general rule, less is more. Now, you may think you can’t do anything to reduce the size of your data set without cutting columns or rows, but that’s not true. Read on to learn two quick tricks to materially reduce the size of your data set.

Read More »How to Reduce the Size of an Alteryx Data Set

Why Do Counts Aggregate Differently in Spotfire?

Last week, I wrote a post on using Axis Names on Cross Tables. My examples calculated the difference in Amounts between two scenarios on a cross table. I also needed to know the difference in well counts between scenarios, this time on a bar chart. But, when I changed the aggregation from a Sum to a CountDistinct, the calculations didn’t work anymore. That is because counts aggregate differently than the other aggregation methods. Read on if you want to get your counts right!

Read More »Why Do Counts Aggregate Differently in Spotfire?

Alteryx Hack For Ensuring Data Granularity

In our last sprint, the AAET team worked up a series of Alteryx workflows for our annual planning process that combines forecast and actual data. It’s a massive data set that pulls from a new forecasting database, so we are beginners with this data. One of my coworkers, Jack Stewart, showed me an Alteryx hack he uses with Cross Tab tools to ensure the granularity of the data is what he thinks it is. As I took over his workflows, this hack saved me multiple times when I didn’t realize records had been duplicated. Read on to learn a new Alteryx trick!

Read More »Alteryx Hack For Ensuring Data Granularity

Spotfire Prompts to Install Over and Over

This week, I ran into an issue with a user whose Spotfire desktop application kept prompting him to install the latest version of Spotfire (to match the latest version installed on the server). He would click install, and the installation would run. The next time Spotfire opened, the process would repeat itself. Fixing this isn’t a simple reinstall, but it is a relatively easy fix. Read on to learn how to solve this problem.

Read More »Spotfire Prompts to Install Over and Over

Data Limiting with Expression versus Show Hide

A few weeks ago, I wrote a post on data limiting in Spotfire when column names change. I provided solutions using both data limiting with expression and the Show Hide Items function. I struggled to get working solutions in both because I expected them to work the same way, but they do not. Therefore, this week, I developed a comprehensive tutorial to show you what they can do and how they are different. Read on to learn more.

Read More »Data Limiting with Expression versus Show Hide

Do You Even Cache, Bro?

I love the data caching feature in Alteryx. However, I learned this week I wasn’t using it as efficiently as possible. I showed my team members this discovery and none of them were aware of it. Are you missing it as well? Check out this post to learn more about caching data in Alteryx.

Read More »Do You Even Cache, Bro?