How do i fill in the date gaps?

Options
Tina_Alpaca
Tina_Alpaca Member
in Charting & Analyzer

I have a start date and an end date. How do i have those dates in between appear? (ETLs/Codes)

Tagged:

Answers

  • GrantSmith
    GrantSmith Coach

    You can utilize Magic ETL and the Domo Dimensions connector.

    Using the Domo Dimensions connector pull in the calendar dataset.

    Feed that into a magic ETL, add a constant call 'Join Column' for a value of 1.

    Then use your dataset as an input, add a constant 'Join Column' with a value of 1 to this dataset as well in the ETL.

    Then do a join between both add constant tiles based on the join column. Feed that into a filter tile and filter with a formula where the dt column from the Calendar dataset is between your start and end dates.

    `dt` BETWEEN `Start Date` AND `End Date`

    This will then expand your data so that you have your record for each day between your time range.

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**
  • MarkSnodgrass
    MarkSnodgrass Coach

    @Tina_Alpaca I created a video on how to do this in Magic ETL. You can watch it here:

    https://www.youtube.com/watch?v=9iNpzSL5V6U

    https://www.youtube.com/watch?v=9iNpzSL5V6U

    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.

Categories