2 Replies Latest reply on Jun 29, 2018 3:24 AM by Keith Cheung

    2 dates with 2 attributes on a single record

    Keith Cheung

      Hi

       

      I have the following problem and not sure if it's the problem of the structure of the data source

       

      Table 1 contains the date of user join and a set of user ids

      Table 2 contains the actions that the user made

       

      Using Prep and I've joined them to one table so each record contains two date values, joineddate & actiondate

       

      Now I'd like plot a line with X-axis as the common timeline showing the number of news joiner over time & the number of actions taken.

       

      I tried using both dates on column with dual axis, and then put the distinct count of user id as rows and ended up

       

       

      Which blue line correctly shows the number of new joiners on each day but the red line shows the number of distinct users who took action on that day.

       

      If I put the number of records (i.e. the number actions took) then ended up with 4 lines.

       

      How do I get to 2 lines which shows the number of unique users and number of action make?

       

      Many thanks!!!!

       

      Keith