Flow for dates
I have the following table:
Id Service Start Stop
12 Mobile Jan May
13 TV Feb Sep
what I want to do is reshape for a line chart to have counts of accounts for active services:
id date service
12 feb mobile
12 march mobile
12 Apr mobile
12 May mobile
13 Feb tv
etc…
Best Answer
-
You are going to want to utilize the Domo Dimensions Connector and the Calendar dataset to build out your months that are in between your start and end dates to create new rows. You would do this in Magic ETL. I've created a video that shows you how to do it.
This is what your ETL would look like.
Hope this helps.
**Check out my Domo Tips & Tricks Videos
**Make sure toany users posts that helped you.
**Please mark as accepted the ones who solved your issue.1
Answers
-
You are going to want to utilize the Domo Dimensions Connector and the Calendar dataset to build out your months that are in between your start and end dates to create new rows. You would do this in Magic ETL. I've created a video that shows you how to do it.
This is what your ETL would look like.
Hope this helps.
**Check out my Domo Tips & Tricks Videos
**Make sure toany users posts that helped you.
**Please mark as accepted the ones who solved your issue.1 -
Can I answer awesome 10 times? Thank you so much Mark. This was truly helpful and thanks for making a video so it is even clearer.
2 -
@mroker LOL! I wish you could hit awesome 10 times! Glad it helped you and will hopefully help others.
**Check out my Domo Tips & Tricks Videos
**Make sure toany users posts that helped you.
**Please mark as accepted the ones who solved your issue.1
Categories
- 10.6K All Categories
- 8 Connect
- 918 Connectors
- 250 Workbench
- 474 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 478 Datasets
- 214 Visualize
- 259 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
- 190 Product Ideas
- 1.2K Ideas Exchange
- 11 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive