We have 2 tables:
OrderDetail - which stores order info like date, sku, quantity, price, ect
SalesGoals - DateWeekStart, DateWeekEnd, SkuQuantityGoal, etc
Is there a way we can do a visualization that dynamically shows the weekly sales against weekly Goals?
I am new to this, so I am not sure the best way to set up the sql in workbench, and then create the visualization in a card.
thanks for any help anyone can give on this or direct me to the best place to find the answers
Brian