PE-GPR/9.0.0/Help/viewDatasets - Revision history

Vivian: Published

2020-08-04T12:38:15Z

Published

WikiSysop: Text replacement - "\|Platform=([^\|])GenesysEngage-onpremises([\|])" to "|Platform=$1GenesysEngage-cloud$2"

2020-07-25T02:30:57Z

Text replacement - "\|Platform=([^\|]*)GenesysEngage-onpremises([\|]*)" to "|Platform=$1GenesysEngage-cloud$2"

WikiSysop: Text replacement - "\|Platforms?=([^\|])PureEngage([\|])" to "|Platform=$1GenesysEngage-onpremises$2"

2020-07-15T11:45:35Z

Text replacement - "\|Platforms?=([^\|]*)PureEngage([\|]*)" to "|Platform=$1GenesysEngage-onpremises$2"

Vivian: Published

2020-03-05T19:59:22Z

Published

New page

{{Article
|Standalone=No
|DisplayName=View uploaded datasets
|TocName=View uploaded datasets
|Context=View a list of all of your datasets, the schema for each individual dataset, and the uploads that make up each dataset.
|ComingSoon=No
|Platform=PureEngage
|Section={{Section
|alignment=Vertical
|structuredtext=<blockquote>'''WARNING:''' Although the Predictive Routing web application includes data upload functionality, its use is deprecated in favor of data uploads using Data Loader. If you upload from the GPR web application, note that using both Data Loader and the UI to upload data creates conflicts and presents a high risk of data corruption.</blockquote>
|Status=No
}}{{Section
|sectionHeading=Open the datasets schema page
|anchor=openDS schema
|alignment=Vertical
|structuredtext=After you create a dataset, it appears in the table of datasets on the '''Settings: Datasets''' window.
[[File:SettingsDatasetList.png|left|700px]]

*To delete a dataset from the list, select the check box in the leftmost column, then click '''Delete Selected'''.
*Click a dataset name to view that dataset and the individual uploads that are included in it.
|Status=No
}}{{Section
|sectionHeading=View a dataset
|alignment=Vertical
|structuredtext=When you click a dataset name in the '''Settings: Datasets''' list, the Dataset Schema tab is displayed. It shows all of the columns in your schema and includes the following information:

*'''Field Name''' and '''Type''' - the name of the column in the dataset and the datatype for that field. The field specified as the '''Created At''' Timestamp field is marked with a green identifying box.
*'''Cardinality''' - the number of unique values that occur in that column. If there are more than 1000, this field shows the value as '''1000+'''. Click the cardinality value to open a pop-up window that displays the first 1000 unique values that occur in the field.
*'''Missing Values''' and '''Invalid Values''' - The number of rows in which the value for that column is either missing or is in some way invalid. For example, there might be an alphabetical string in a numeric field. The number is followed by the percentage of rows with missing or invalid values. Use these fields to determine whether the data quality is satisfactory.
**Invalid values are discarded from the dataset. If the '''Created At''' Timestamp row contains missing or invalid values, the entire row is discarded
*'''PII''' - Anonymized fields have a check mark in this column.

You can sort the table by clicking any column header.
|Status=No
}}{{Section
|sectionHeading=The Uploads tab
|anchor=uploads
|alignment=Vertical
|structuredtext=[[File:AppendDatasets.png|left|thumb|List of CSV files in Dataset]]Click the '''Uploads''' tab to view a table listing the CSV files uploaded to the current dataset. For each CSV file, the table shows information to help you evaluate the source and quality of your data.

*Red numbers in the '''Missing Values''' and '''Invalid Values''' columns indicate gaps or inconsistencies in the data.
*The '''Status''' column provides a quick view of whether any CSV files have data issues that can cause problems when using the dataset for training Models or scoring agents. Hover your mouse over the status icon in a row to see a tooltip that explains the reason for the status.
*:The way the status is calculated depends on the number of uploads you have done. For the first five uploads, the status is calculated based on a simple percentage of successfully-imported values. For the sixth and later uploads, the status is calculated relative to the average results of all uploads.

{{{!}} border="1"
{{!}}-
!Status
!Uploads 1-5
!Uploads 6 and above
Calculated based on the average of the missing + invalid values for all previous uploads
{{!}}-
{{!}}Green checkmark icon = Success
{{!}}Fewer than 5% of all values in the CSV file are missing or invalid.
{{!}}From 0% to (average% + 3%)
{{!}}-
{{!}}Yellow caution icon = Warning
{{!}}between 5% and 50% of the values are missing or invalid.
{{!}}From (average% + 3%) to (average% + 13%)
{{!}}-
{{!}}Yellow half-circle icon = Warning
{{!}}The CSV file contained more than 2.5 million rows, so that some rows were not uploaded.
{{!}}The CSV file contained more than 2.5 million rows, so that some rows were not uploaded.
{{!}}-
{{!}}Red stop icon = Error
{{!}}More than 50% of the values in the CSV file are missing or invalid.
{{!}}From (average% + 13%) to 100%
{{!}}}You can remove a problematic CSV file from the dataset without deleting the entire dataset. To do so:

*Click the check box on the left side of the CSV row, and then click the trashcan icon that appears above the table.
|Status=No
}}
}}

@@ Line 13: / Line 13: @@
 |sectionHeading=Open the datasets schema page
 |anchor=openDS schema
-|alignment=Vertical
+|alignment=Horizontal
 |structuredtext=After you create a dataset, it appears in the table of datasets on the '''Settings: Datasets''' window.
 *To delete a dataset from the list, select the check box in the leftmost column, then click '''Delete Selected'''.
@@ Line 25: / Line 26: @@
 |structuredtext=When you click a dataset name in the '''Settings: Datasets''' list, the Dataset Schema tab is displayed. It shows all of the columns in your schema and includes the following information:
-*'''Field Name''' and '''Type''' - the name of the column in the dataset and the datatype for that field. The field specified as the '''Created At''' Timestamp field is marked with a green identifying box.
+*'''Field Name''' and '''Type''' - the name of the column in the dataset and the datatype for that field.
 *'''Cardinality''' - the number of unique values that occur in that column. If there are more than 1000, this field shows the value as '''1000+'''. Click the cardinality value to open a pop-up window that displays the first 1000 unique values that occur in the field.
 *'''Missing Values''' and '''Invalid Values''' - The number of rows in which the value for that column is either missing or is in some way invalid. For example, there might be an alphabetical string in a numeric field. The number is followed by the percentage of rows with missing or invalid values. Use these fields to determine whether the data quality is satisfactory.

@@ Line 5: / Line 5: @@
 |Context=View a list of all of your datasets, the schema for each individual dataset, and the uploads that make up each dataset.
 |ComingSoon=No
-|Platform=GenesysEngage-onpremises
+|Platform=GenesysEngage-cloud
 |Section={{Section
 |alignment=Vertical

PE-GPR/9.0.0/Help/viewDatasets - Revision history

Vivian: Published

WikiSysop: Text replacement - "\|Platform=([^\|]*)GenesysEngage-onpremises([\|]*)" to "|Platform=$1GenesysEngage-cloud$2"

WikiSysop: Text replacement - "\|Platforms?=([^\|]*)PureEngage([\|]*)" to "|Platform=$1GenesysEngage-onpremises$2"

Vivian: Published

WikiSysop: Text replacement - "\|Platform=([^\|])GenesysEngage-onpremises([\|])" to "|Platform=$1GenesysEngage-cloud$2"

WikiSysop: Text replacement - "\|Platforms?=([^\|])PureEngage([\|])" to "|Platform=$1GenesysEngage-onpremises$2"