10 Replies Latest reply: May 1, 2017 11:05 PM by Goutham V RSS

    Converting data in field with number formatting

    Goutham V

      Hello All

       

      I need to convert the data in the filed(last_accessed_page),

      for example data in the field(last_accessed_page )are like,

       

      last_accessed_page

      1,1,1

      1,1,2

      1,1,3

       

      (Above 1,1,1 specifies page number=1)

      i need to format this  and display it like 1,2,3

       

       

      sub.png

      dimension:

      last_accessed_page

       

      measure:

      Count({<subject_status={'incomplete'}>}last_accessed_page)

       

      Data Load Editor:

       

       

      LOAD `subject_access_track_id`,

          `subject_name`,

          `client_id`,

          `lender_offer_id`,

          `subject_status`,

          last_accessed_page;

      SQL SELECT `subject_access_track_id`,

          `subject_name`,

          `client_id`,

          `lender_offer_id`,

          `subject_status`,

          `last_accessed_page`

      FROM SUBJECTACCESSTRACKING;