2 Different Date Data Sets

Grecs5
Grecs5 Member
edited March 2021 in Charting

I have a problem where I need to match up 2 different data sets to show funnel. Create Date & Demo Date. I need to show this data by week number. A demo date can be weeks after the create date. Here is my example:

Data set 1

Week Create Count

1 10

2 20


Data Set 2

Week Demo Count

1 3

2 8


How can I merge these data sets do I can get matching numbers as shown below:

Week Create Demo

1 10 3

2 20 8

Answers

  • You need to join these two datasets together to make one dataset. The easiest way to do this is with Magic ETL. The below example shows you more than just joining, but the idea is that you can use the join tile to join your two datasets together. You would join on week. You might want to review this KB article to better understand the different types of joins if you are unfamiliar with the concept.



    **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.
  • Hi @Grecs5

    alternatively you can use a data set view to join your two datasets together.


    another option to think about might be instead of joining your data together you UNION / stack your data together such that you have

    TYPE | WEEK | COUNT

    Demo | 1 | 3

    Create | 1 | 10

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**
  • Sorry @GrantSmith and @MarkSnodgrass hard disagree.


    Don't JOIN the data. APPEND them.

    If you get to the point where you have multiple rows per week OR if dataset 1 is at a different granularity than dataset2 then you end up with row growth (because you're JOINING) and you have to crazy math to 'SUM DISTINCT).


    1) add a constant "Activity Type" to each dataset so you know what type of metric you're dealing with

    2) duplicate the date column and call it "Activity Date" for both datasets. (then use Activity Date in Analyzer).

    3) UNION the data

    https://www.youtube.com/watch?v=PVbOeLSae9o&t=772s

    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"