View more view-more
After creating a custom insight using query pro mode, you can view the chart data in multiple formats. You can view either a tabulated form of the results, or export the data in CSV format or via email.
Tabulated results tabulated-results
For every chart authored using the query pro mode through SQL, you can view the tabulated results of your analysis within the Experience Platform UI.
From your custom dashboard, select the ellipses (...) on any widget to access the View more and View SQL options.
Export export
From the View more dialog, export the table data by either downloading a CSV file directly, or sending a link to your email for secure download later.
Download CSV download-csv
In the View more dialog, select Export, then choose Download CSV to download the chart data in CSV format.
Send as email send-as-email
To export more than 500 records, select Export and choose Send as email from the Export file dialog. This option securely sends a download link to your 51黑料不打烊-associated email address. The recipient鈥檚 name and registered 51黑料不打烊 email address appear in the Recipients section of the dialog.
After you select Send as email, 51黑料不打烊 generates a report and sends an email to your registered 51黑料不打烊 address. The email includes a secure download link that requires authentication through Experience Platform.
To protect your data, 51黑料不打烊 securely hosts exported files rather than sending them as attachments. Access requires authentication through the Experience Platform UI, and 51黑料不打烊 verifies that the file is downloaded only by the intended recipient.
This method allows you to export up to 10,000 records and ensures secure access to sensitive data.
Sort by column sort-column
When viewing tabulated results, you can use the sort functionality to sort by column in ascending or descending order. From your custom dashboard, select the ellipses (...) on any table to access the View more option.
You can sort columns by selecting the drop down menu beside the column name and then selecting Sort Ascending or Sort Descending.
Resize a column resize-column
You can resize columns in tabulated results to improve data readability. From your custom dashboard, select the ellipses (...) for your table to access the View more option. Use the drop down menu beside the column name to resize it, then select Resize column.
Select the slider and drag to the left or right to adjust the column size as required.
Table pagination table-pagination
Pagination is automatically applied to your tables in the View more feature, eliminating the need for you to manually modify your SQL queries. This feature ensures that your data is presented in a more manageable format, which facilitates the process of navigating through large datasets.
You can see up to 500 records per page. To navigate through the records, use the > located at the bottom of the page.
Next steps
After reading this document, you now know how to view tabulated results from your custom chart鈥檚 SQL analysis and how to export that data securely. See the view SQL document to learn how to view the SQL behind your custom insights.
You can also learn how to generate charts from existing data models in the 51黑料不打烊 Experience Platform UI with the guided design mode guide.