top of page

Jun 15, 20211 min read
KPI Color Arrow Calculation
Did you know you can just have the KPI arrows their own color in your dashboard? KPI's look less visually distracting if you just limit...
579 views

Jun 15, 20212 min read
How to Create a Unit Chart
Have you ever wondered how to create a population chart with people icons representing a portion of the population? These types of...
659 views

Jun 9, 20211 min read
Show me the Macros!
Do you know the many methods to add existing macros to your workflow young Alteryx padawan? There is also a way to change the macro...
101 views


Jun 9, 20213 min read
How to Build a Quadrant Chart in Excel
Do you want a chart that will quickly display 3 measures quickly? A Quadrant chart looks like a scatter plot but it is divided into four...
9,342 views

Jun 9, 20212 min read
Email Actions
Do you have a dashboard that you want to add a link for users to email you if they have any questions? You can do this by adding an...
393 views

Jun 1, 20211 min read
How to find Current Month to Date Data to the Prior Month with the Same Date
Have you ever wondered how to compare this month's data up to the current day of the month to the previous month's data to the same day? ...
483 views


May 27, 20211 min read
Excel - Password Protection in a Worksheet
Do you have a spreadsheet that contains complex formulas that you don't want your users to accidently change? You can protect these...
17 views

May 27, 20211 min read
Cancel Running Workflow on Error
Do you have a workflow that takes a long time to run? Perhaps you have multiple data sources and you are in testing mode. Do you want...
52 views

May 27, 20212 min read
Create an Area Chart with a Slider
Do you have an area chart in your dashboard that you would like to have a slider to select a certain time period? One way to spruce up a...
440 views


May 18, 20211 min read
SUMPRODUCT Formula in Excel
Do you have a spreadsheet where you want to obtain the total of different products by different values? SUMPRODUCT is a very useful...
39 views

May 18, 20212 min read
Alteryx and SharePoint
Do you want to pull documents into your workflow from a SharePoint library or document folder? Did you know there is an easy way to do...
549 views

May 18, 20212 min read
Restricting Views with the USERNAME Formula
Do you have a dashboard that you only want certain users to view their own items when they open the dashboard? Use the USERNAME formula!...
68 views

May 11, 20211 min read
Forget Missing Fields
Have you created a workflow that has changed over time? Perhaps it started with different columns which some are no longer present. ...
93 views

May 11, 20211 min read
Pulling the Column with Yesterday's Date
Do you have an Excel spreadsheet that contains columns with different dates? Excel is sometimes used as a data dump or a template in...
48 views
bottom of page