Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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;
Thanks bro it worked,,,:)