Showing results for 
Search instead for 
Did you mean: 

The Houdini Report

7 - Data Storage
7 - Data Storage

We are finally releasing our Analytics Suite to our customers and I would like to create a Dashboard/Report to specifically show items that have "Disappeared" from weekly sales.  If an item was consistently sold for 3 weeks or more and then 3 weeks goes by WITHOUT it being sold, the system would flag this item and display it, display its weekly average (for when it was sold) and how much "Lost sales" this equates to in revenue. 

Items, quantity sold, and a line_extension (invoiced amount total per item)  are the three metrics I believe I would need to interact with.  These are the column headers (although not their actual names just to more easily understand this project) 

I'm sure this needs a bit more detail from me but I figured I could maybe get the ball rolling.  Thanks in advance for your insight and help!