Compare multiple data streams
Learn how to use Stream mode to compare multiple data streams on one screen by adding streams in the Variant Stream dropdown, such as budget, stretch budget, and previous sales. Variances appear as values and percentages, and you can show them as a target percentage and sort the columns. Switch to summary and a line chart to see how you're tracking against your targets for the year.
Supporting documentation
Related video tutorials
Explain the variance, don't just log it
Learn how to find the cause of cycle count and adjustment variances so they stop recurring. You'll view a stock snapshot over 12 months, switch to variances, and compare product groups to spot the largest discrepancy. Drilling into that item turns unknown shrinkage into a specific pattern or location, such as a bin or user, where your data supports it.
Use Matrix Variance and Matrix Share mode
Learn how to build on Matrix mode with Matrix variance, which adds previous period and variance columns, and Matrix share, which shows each row as a percentage split. You'll also learn how to simplify matrix column headings with matrix captions, and how to sort the share results to find customers who buy fewer of one item than expected.
Show positive or negative variance
Learn how to switch to Variance mode to see current sales, previous sales, and the difference in dollars or percentage for each customer or product. You'll change the period, sort by the largest positive or negative variance, and apply the same approach to any dimension.
See churn risk across your whole patch
Learn how to see which customers are slipping and who to call first. Ask Workspaces which customers are declining in sales and margin this month, then compare month over month in Analytics to surface customers whose sales fell across three consecutive months. You can make the report dynamic so it updates as new sales come in, and share it with your reps.