Documentation Hub

Some analyses and settings depend on the data type of the column you want to analyze. For your convenience, QSuite natively supports several data types, which are automatically detected for each column when you import or paste your dataset. However, in some cases automatic detection may identify the wrong data type, particularly when it is ambiguous. With QSuite you can easily verify the detected data type and change it in a very simple way.

Viewing the Data Type

Each column displays an icon that indicates the detected data type. QSuite currently supports the following data types:

• Categorical: This data type is represented by the symbol "T". Categorical data is data on which arithmetic operations such as addition, subtraction, averages, etc. cannot be performed. This data represents labels or categories such as: colors, phone numbers, city, country, day of the week, unique identifier, etc.
• Integer: Represented by the symbol "123". Integer data is also known as count data and refers to values where a decimal point does not make sense. For example: number of accidents, number of non-conformances, number of people, etc.
• Decimal: Represented by the symbol "1.5". Examples of this data include sales, costs, time, and any other variable that can be expressed with a decimal point.

• Date: Represented by a calendar icon. QSuite supports several date formats and will attempt to identify the format your data uses. However, when the date format is ambiguous QSuite will mark the column with a question mark "?" so you can manually specify the correct date format.
• Time: This data format is represented by a clock icon.

The image below shows an example of the different icons representing each data type.

Changing the Data Type of a Column

To change the data type of a column, do the following:

1. Click on the icon corresponding to the data type. A dropdown list will appear with the different options.
2. Select the correct data type for your column from the list.

Working with Dates

QSuite will try to automatically identify the date format of your data. However, when your date is ambiguous a question mark will appear on the column icon.

To tell QSuite the date format of your data, follow these steps:

1. Click on the question mark "?" on the column

2. Click on "Change date format". A dialog box will appear so you can specify the correct format.

3. Drag the "Day", "Month", and "Year" labels into the correct order. For example, if your date format is "mm/dd/yyyy", the correct order would be Month / Day / Year.
4. Check the "Values include time" checkbox if the column combines both dates and times. Otherwise, leave it unchecked.
5. Click Save.

If your data follows the date format you specified, QSuite will make the change automatically. Otherwise, an error message will appear indicating that one or more values do not match the specified date format.