Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Converting data in field with number formatting

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;

10 Replies
Not applicable
Author

Thanks bro it worked,,,:)