Goals vs. Actual
Okay, so I'm trying to visualize two sets of information on one card. The first is our stored Goal, which is in one datasource being pulled into Domo. It's stored by Month and Year (two separate fields unfortunately, but I can work with that in ETL), and is a given number for the goal value - let's just say 100 for December 2017.
Then our actual traction towards that goal, is determined by a date field in a different dataset - so I need to count, based on whether that date's month and year match the goal's month and year. This could be say, 97 currently.
How would some of you approach this scenario, to show these values side by side...and filterable based on Goal Period?
Comments
-
Hi!
We do this all the time in our datasets.
We have a dataset for targets (aka goals/quotas/forecast/budget/etc). Usually broken down by time (month/year) and person or product. Like 100000 01-May-2017 Jackson, Theresa
Then we have regular sales data. Our sales data is at the transaction level. In order to bring the sales together with the targets, we bring both into a dataflow. First step is to roll up the actual sales to the same level as the targets. In this case, monthly by person. With the target and the sales at the same level, you can put them together. At this point you have a choice to make: join the entries into single rows, or stack them with a label for measure type.
97000 100000 01-May-2017 Jackson, Theresa
OR
Sales 97000 01-May-2017 Jackson, Theresa
Target 100000 01-May-2017 Jackson, Theresa
I've found it much easier to deal with the possibility that data is missing (products changing, people leaving, etc) from either side by opting for the second path. I've also found it easier to work with the data if the date information is actually a date datatype, instead of a split column of month and day strings. That will require some manipulation on your part.
This is a high level view, so let me know if you have questions about the detail.
Aaron
MajorDomo @ Merit Medical
**Say "Thanks" by clicking the heart in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"1
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 296 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 614 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 729 Beast Mode
- 53 App Studio
- 40 Variables
- 677 Automate
- 173 Apps
- 451 APIs & Domo Developer
- 45 Workflows
- 8 DomoAI
- 34 Predict
- 14 Jupyter Workspaces
- 20 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 121 Manage
- 118 Governance & Security
- Domo Community Gallery
- 32 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive