11 Replies Latest reply on Mar 3, 2017 5:12 PM by Mia Lee

    Dates and pivoting to combine multiple dates field

    Béatrice LORIOT

      Hi all,

       

      i've seen a lot of questionning around "combining multiple field dates into one", and answers are always the same : either pivoting or doing some SQL. :-)

       

      But what do you do when you can't pivot or SQL ? Which is the case when being directy connected to a database which does not allow any of those.

       

      I have 4 fields :

       

      • Customers ID
      • Providers ID
      • Provider creation date
      • Customer creation date

       

      I would like to be able to count all providers and customer created during the same period and use one date filter. (month and Q)

       

      Thanks