4 Replies Latest reply on Jul 27, 2018 1:10 PM by Dan Hong

    How to create calculated field that orders dates by a dimension?

    Dan Hong

      I know that the RANK function is great for ordering anything in visible table, but I was wondering if it's possible to rank dates by a specific dimension to use later in an aggregation? For example, in the table below, Date Order would be a calculated field (not a table calculation):

       

      UserDateDate Order
      Jack7/2/20181
      Jack7/5/20182
      Jill7/10/20181
      Jack7/10/20183
      Jill7/26/20182

       

      Then:

       

      Date OrderUser Count
      12
      22
      31