Flow for dates

mroker · 2022-10-14T01:07:31+00:00

There was an error rendering this rich post.

mroker

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…

Find more posts tagged with

Magic ETL

Accepted answers

MarkSnodgrass

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.

https://youtu.be/9iNpzSL5V6U

This is what your ETL would look like.

Hope this helps.

All comments

MarkSnodgrass

https://youtu.be/9iNpzSL5V6U

This is what your ETL would look like.

Hope this helps.

mroker

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.

MarkSnodgrass

@mroker LOL! I wish you could hit awesome 10 times! Glad it helped you and will hopefully help others.