Sales fell. Margin slipped. Which version of "it doesn't add up" is yours?
FactorPrism works on any number that adds up across rows, in any table or view with dates and ways to slice it. These are the questions teams bring most often.
The total looks healthy. One region does not.
A company-wide lift covers for a region that is falling behind.
Sales trend analysis The combination mattersNo single slice explains the growth.
Category looks hot, region looks strong; the driver is one category in one region.
Sales growth attribution Offsetting movementOn plan, with two large misses inside.
Explain actual versus budget by where each variance began.
Budget vs actual Board-readyThe revenue bridge that ties to the dollar.
Every step from last period to this one, located and reconciled.
Revenue bridge Mixed signsMargin moved. Cost, price, or mix?
Works for numbers that cross zero, where percent-change math breaks.
Gross margin bridge FlowsNet adds fell. Adds, churn, or a segment shift?
Find the segment where the flow changed, and when it started.
Net adds and churn Conflicting cutsThree dashboards, three stories.
Payer, code and service line, searched together for the one combination behind a denial spike.
Healthcare claims Public data50 million 311 requests.
Which categories and periods really drove New York's change in service requests.
NYC 311 case study AgentsAsk an agent why the number moved.
The FactorPrism skill for Snowflake Cortex Code.
Cortex Code skillA date, a number, and ways to slice it.
One table or view in Snowflake. The number must add up across rows; prepare ratios and averages in a view first. A plan or budget column lets you explain actual versus plan.
Not on the list?
If it is a number in Snowflake that someone keeps asking about, bring it to a guided evaluation.