Set goals in ETL

ericziengsGB
Member
in Magic ETL
Hi,
I'd like to take a dataset (for instance sessions per day in Google Analytics or followers on LinkedIn per day) and and daily targets to it.
So lets say these are the dates and number of sessions for March until now:
1: 25
2: 35
3:25:
4: 30
5: 56
6: 66
7: 10
Then I'd like to put in the goals for each day that I have in a Google Spreadsheet.
How do I join them properly? When joining in ETL I get some very strange numbers - especially because the session numbers can be divided into what device they were on (mobile, tablet, desktop).
Anyone has a solution for this?
Thanks!
Eric
0
Best Answer
-
APPEND your data instead of JOINing it.
Jae Wilson
Check out my 🎥 Domo Training YouTube Channel 👨💻
**Say "Thanks" by clicking the ❤️ in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"2
Answers
-
APPEND your data instead of JOINing it.
Jae Wilson
Check out my 🎥 Domo Training YouTube Channel 👨💻
**Say "Thanks" by clicking the ❤️ in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"2
Categories
- All Categories
- 2K Product Ideas
- 2K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 311 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 3.8K Transform
- 657 Datasets
- 115 SQL DataFlows
- 2.2K Magic ETL
- 815 Beast Mode
- 3.3K Visualize
- 2.5K Charting
- 81 App Studio
- 45 Variables
- 775 Automate
- 190 Apps
- 481 APIs & Domo Developer
- 81 Workflows
- 23 Code Engine
- 40 AI and Machine Learning
- 20 AI Chat
- 1 AI Playground
- 1 AI Projects and Models
- 18 Jupyter Workspaces
- 410 Distribute
- 120 Domo Everywhere
- 280 Scheduled Reports
- 10 Software Integrations
- 144 Manage
- 140 Governance & Security
- 8 Domo Community Gallery
- 48 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 114 Community Announcements
- 4.8K Archive