Analyzing Profit

Hey All -

Working to find a solution for a seemingly simple ask. My company is in retail and for the holiday season they want to see a report that is sent automatically every hour that reflects Sales, Orders and Margin.

That being said, we currently use SAINT classifications for product information so I am trying to add a Numeric Classification for the cost of goods (again, a seemingly simple ask). The cost of goods is a fixed value at the product level, but should be multiplied by things like quantity when looking at orders. I.e. if a product's cost of goods is $1, but there were 3 in an order, the overall cost of goods for the order would be $3.

My question for the community is: what would I use for the cost rate and cost hinge? Would they both just be fixed?

Also, once I have that resolved, there's still the issue of the hourly aggregated report. Is it possible to pull that value in report builder and aggregate it for the hour (via a product report) without pulling the thousands of product IDs associated with it?

Any insight is appreciated!