2 Replies Latest reply on Aug 30, 2016 4:16 AM by Mattia Balzarini

    Using 2 data sets in the same area chart

    Mattia Balzarini

      Hi everybody,

      I have a visualization that is sending me nuts. I ask for your help to keep my brain mentally sane

       

      I have 3 columns. Number of rows is not unique per users, but it's actually all transactions of users.

      UserId (string)

      RegistrationDate (date & time)

      FirstPaidDate (date & time)

       

      Now what I wanna achieve is having on X axis a scale which is a date.

      On Y I have my users (just the ones from a specific Month(FirstPaidDate).

      The graph should be a pile of lines(each line a user) with as starting point the RegistrationDate and as ending point the FirstPaidDate

       

      The problem is to have the 2 dates fit in a unique scale. Dual axis wouldn't work because it would show the point of registration and the point of firstpaid but without connecting them for each user.

       

      I found possible workarounds like creating the datedifference between the 2 dates and use it on the X axis, this would give me something very similar.

      But I really need to have an actual date scale on the X axis.

       

      Any Ideas?

       

      Thanks

       

      Mattia