Flow for dates

mroker
mroker Member
edited October 2022 in Magic ETL

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…

Tagged:

Best Answer

  • MarkSnodgrass
    MarkSnodgrass Coach
    edited October 2022 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.

    https://youtu.be/9iNpzSL5V6U


    This is what your ETL would look like.

    image.png

    Hope this helps.

    **Check out my Domo Tips & Tricks Videos

    **Make sure to <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.

Answers

  • MarkSnodgrass
    MarkSnodgrass Coach
    edited October 2022 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.

    https://youtu.be/9iNpzSL5V6U


    This is what your ETL would look like.

    image.png

    Hope this helps.

    **Check out my Domo Tips & Tricks Videos

    **Make sure to <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.
  • mroker
    mroker Member

    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
    MarkSnodgrass Coach

    @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 to <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.

Categories