Dynamic Goals by employee title
I'm trying to set up a card to show employee performance against a corporate goal that is variable based on the employee title. Certain employees need to submit a report, and the # of reports they have to submit is either a certain number per day, per week, or per site visit, depending on their title.
I have one dataset that captures report submitted by employee and the date submitted, and another dataset that captures the goal definition and title (i.e. 3 per week | employeeTitle).
I'm not sure how to structure this dataset to determine if the goal is being met.
Has anyone done something similar to this, or have some suggestions of how to approach it?
Best Answer
-
If your employee report dataset contains employee title then I would take that dataset and then bring into Magic ETL and use then join it to your goals dataset that contains employee title, frequency (day, week, visit), and goal number (3, 5, 9, etc.).
I would then use multiple filter tiles to separate them, one for each frequency. Next, use group by tiles to group by day for your day filter, group by week for the week filter, and site for the site filter.
At this point, you should be able to append them all back together. You may want to think about a common date field such as month/year if you want to be able to show activities during a particular month. You can create this field during your ETL process.
For card type, I would suggest the Bullet Chart as it has an actual value field and a target value field, which would work nicely for this data.
Hope this helps.
**Check out my Domo Tips & Tricks Videos
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.1
Answers
-
If your employee report dataset contains employee title then I would take that dataset and then bring into Magic ETL and use then join it to your goals dataset that contains employee title, frequency (day, week, visit), and goal number (3, 5, 9, etc.).
I would then use multiple filter tiles to separate them, one for each frequency. Next, use group by tiles to group by day for your day filter, group by week for the week filter, and site for the site filter.
At this point, you should be able to append them all back together. You may want to think about a common date field such as month/year if you want to be able to show activities during a particular month. You can create this field during your ETL process.
For card type, I would suggest the Bullet Chart as it has an actual value field and a target value field, which would work nicely for this data.
Hope this helps.
**Check out my Domo Tips & Tricks Videos
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.1 -
@MarkSnodgrass thank you! That's a really helpful starting point and definitely puts me in the right direction.
0
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