1 Reply Latest reply on Dec 1, 2018 5:25 AM by Jim Dehner

    Sorting Combined fields

    kumar golla

      Hii ALL,


      I have a Concatenate field as Order_Prompt like OrderID + Billdate + PaidDate.But when sorting has performed it displayed Order_Prompt data based on OrderID.

      but requirement has been sorting on Billdate to get latest value in filter.

      This is Obstruct have been facing .Please share any ideas to solve.




        • 1. Re: Sorting Combined fields
          Jim Dehner

          When you concatenate the fields you created a new dimension that is a string - you are sorting on that string not on "Order Prompt"

          you have 2 options - the first I am guessing you won't like and that is to change the concatenation order to Order date first =


          The second is to include orderdate in the viz and then hide the field

          see below

          here is the concatenated field


          add the oderdate to the viz


          and it returns this


          If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution.  Thank you.