Search the Community
Showing results for tags 'kpi'.
Found 1 result
I am trying to chart and analyze sale data. In particular, "Most popular product(from a specific product category) this quarter/month/year/etc" and things of that nature. In this database there are several tables: I will try to explain how they are linked Sales Order -Sales Order Line Item --Product Product Category -Product --Sales Order Line Item For example, I want to see the most popular product during a certain fiscal quarter do do so, I need to filter the line items by the following criteria and then have a calculation of the sum of found line items grouped by product * order quantity: Based on the tables this criteria needs to be met: SalesOrder::OrderStatus /= "Open" (not equal) (i.e. closed/completed orders) SalesOrder::Year=CurrentYear SalesOrder::Quarter = Fiscal Quarter(or can be month or can be omitted entirely) Product::Category="my category"(whatever) I've tried many solutions and getting somewhat close, but I get stuck with Un-Index-able match fields(keys) dues to calculations from related tables or circular references. Any tips would be great. Lastly, I think I can accomplish the same thing with a script and perform multiple searches against the LineItems based on related tables, but wanted to know if there is a more direct way via the relationship graph. I'm happy to provide more details if needed. Thanks in advance.