How to enter sales goal figures for individual salespeople
Hey everyone -
I have a question regarding sales goal figures. I have a set of data with individual sales listed on it, with the date of the invoice, salesperson, sale total, and other data detailing each unique sale. On a separate spreadsheet, I have each sales goal for each person, for the year, and also for each month. How would I go about combining these two sets of data so that I can use graphs that show both the sales goal, and then the monthly/yearly progress? The sales sheet updates automatically, but the sales goals sheet will stay the same throughout the year.
Thank you for any help, it's much appreciated!
Comments
-
Hi,
You will have to use a dataflow. You can use redshift dataflow to join the two tables, something like:
Select Sales.* , Goals.MonthGoal, Goals.YearGoal From Sales Left Outer Join Goals ON
Sales.salesperson= Goals.Salesperson AND DATEPART(y,Sales.Date) =Goals.Year AND DATEPART(mon, Sales.Date) = Goals.Month
This will give you on each record information about sales goal for that SalesPerson on the month and year of the invoice. Then you can use A MAX() Aggregate on the card to get a unique Goal value for each month or year.. This is the best i can do not accurately knowing your data schema.
There are certainly other ways to achieve this.
Hope this helps
Ricardo Granada
**If the post solves your problem, mark it by clicking on "Accept as Solution"
**You can say "Thank you" by clicking the thumbs up in the post that helped you.0
Categories
- 10.6K All Categories
- 8 Connect
- 918 Connectors
- 250 Workbench
- 477 Transform
- 1.8K Magic ETL
- 69 SQL DataFlows
- 478 Datasets
- 218 Visualize
- 260 Beast Mode
- 2.1K Charting
- 12 Variables
- 19 Automate
- 356 APIs & Domo Developer
- 89 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 249 Distribute
- 65 Domo Everywhere
- 243 Scheduled Reports
- 21 Manage
- 42 Governance & Security
- 191 Product Ideas
- 1.2K Ideas Exchange
- 11 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive