Analyzing Profit

Avatar

Avatar
Validate 1
Level 1
creges
Level 1

Like

1 like

Total Posts

2 posts

Correct reply

0 solutions
Top badges earned
Validate 1
Boost 1
View profile

Avatar
Validate 1
Level 1
creges
Level 1

Like

1 like

Total Posts

2 posts

Correct reply

0 solutions
Top badges earned
Validate 1
Boost 1
View profile
creges
Level 1

14-11-2017

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!

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Seeker
Moderator
PratheepArunRaj
Moderator

Likes

315 likes

Total Posts

870 posts

Correct reply

264 solutions
Top badges earned
Seeker
Bedrock
Engage 1
Affirm 250
Contributor
View profile

Avatar
Seeker
Moderator
PratheepArunRaj
Moderator

Likes

315 likes

Total Posts

870 posts

Correct reply

264 solutions
Top badges earned
Seeker
Bedrock
Engage 1
Affirm 250
Contributor
View profile
PratheepArunRaj
Moderator

15-11-2017

Hello Creges,

Can you check the list of Examples to get an idea for your 1st question? Hope it will be covered.

Reagrding Report Builder, you should if you have dedicated event for it or subtotal it using Product IDs.

Thank You!

Arun

Answers (0)