3 Replies Latest reply on Oct 10, 2018 7:00 PM by Shinichiro Murakami

    Combine different fields

    Derrick Mankaruse

      Hi,

       

      I am trying to pull two different data sets (each set built on different rules) and I would like to combine those together in one graph...

       

       

      for example, I am looking at # of users add this month (along with some other filters i added to get this sample of user) .. lets say that 100 users..

      I would like to add those 100 users to (the 50 users from last month) but those 50 from last month, they have different filters than the 100 users..

       

      finally, I want to take these two groups, and combine them in a final graph...

       

       

      lets say the target goal is 200....

       

      i have 100 and 50, i would like to show them both separate and how they line up with that target total...

       

                100              50                    200

      |----------------| |--------|                    |

       

       

       

      I have them in different sheets, having trouble bringing them all together, is there a way to make this a calculated field or something???

       

      Thanks!