@Ribs11380
Could you post a mockup of what you have and what you want?
When concatenating columns, the inputs and outputs are a character type. If you wrap your concatenation in num( your concat formula here ), in the formula editor, if the resulting data is able to be converted into a number, it will be. If you force a character type to become a number via column properties, it will be erased because character types are not numbers.
@StarfruitBob points out the num(...) function will convert character data to numeric. There is also a char(...) function that converts numeric data to character.
You might want to use a formula column for the concatenation of two numeric columns. The formula column's formula might be
char(a) || char(b)
for the numeric columns a and b. You'll probably want to keep numeric data in numeric columns for further work. Converting it to character will cause platforms like fit y by x to produce the wrong report for numeric data.
Name is a character variable that will make logistic, contingency, or oneway plots depending on which axis it is used on, and the type of the other axis.Name is a character variable that will make logistic, contingency, or oneway plots depending on which axis it is used on, and the type of the other axis.Name is a character variable that will make logistic, contingency, or oneway plots depending on which axis it is used on, and the type of the other axis.Name is a character variable that will make logistic, contingency, or oneway plots depending on which axis it is used on, and the type of the other axis.Name is a character variable that will make logistic, contingency, or oneway plots depending on which axis it is used on, and the type of the other axis.Name is a character variable that will make logistic, contingency, or oneway plots depending on which axis it is used on, and the type of the other axis.Name is a character variable that will make logistic, contingency, or oneway plots depending on which axis it is used on, and the type of the other axis.Name is a character variable that will make logistic, contingency, or oneway plots depending on which axis it is used on, and the type of the other axis.Name is a character variable that will make logistic, contingency, or oneway plots depending on which axis it is used on, and the type of the other axis.Name is a character variable that will make logistic, contingency, or oneway plots depending on which axis it is used on, and the type of the other axis.Name is a character variable that will make logistic, contingency, or oneway plots depending on which axis it is used on, and the type of the other axis.Name is a character variable that will make logistic, contingency, or oneway plots depending on which axis it is used on, and the type of the other axis.Name is a character variable that will make logistic, contingency, or oneway plots depending on which axis it is used on, and the type of the other axis.Name is a character variable that will make logistic, contingency, or oneway plots depending on which axis it is used on, and the type of the other axis.Name is a character variable that will make logistic, contingency, or oneway plots depending on which axis it is used on, and the type of the other axis.Name is a character variable that will make logistic, contingency, or oneway plots depending on which axis it is used on, and the type of the other axis.Name is a character variable that will make logistic, contingency, or oneway plots depending on which axis it is used on, and the type of the other axis.Name is a character variable that will make logistic, contingency, or oneway plots depending on which axis it is used on, and the type of the other axis.Name is a character variable that will make logistic, contingency, or oneway plots depending on which axis it is used on, and the type of the other axis.Name is a character variable that will make logistic, contingency, or oneway plots depending on which axis it is used on, and the type of the other axis.Name is a character variable that will make logistic, contingency, or oneway plots depending on which axis it is used on, and the type of the other axis.Name is a character variable that will make logistic, contingency, or oneway plots depending on which axis it is used on, and the type of the other axis.Name is a character variable that will make logistic, contingency, or oneway plots depending on which axis it is used on, and the type of the other axis.Name is a character variable that will make logistic, contingency, or oneway plots depending on which axis it is used on, and the type of the other axis.Name is a character variable that will make logistic, contingency, or oneway plots depending on which axis it is used on, and the type of the other axis.Name is a character variable that will make logistic, contingency, or oneway plots depending on which axis it is used on, and the type of the other axis.Name is a character variable that will make logistic, contingency, or oneway plots depending on which axis it is used on, and the type of the other axis.Name is a character variable that will make logistic, contingency, or oneway plots depending on which axis it is used on, and the type of the other axis.Name is a character variable that will make logistic, contingency, or oneway plots depending on which axis it is used on, and the type of the other axis.Name is a character variable that will make logistic, contingency, or oneway plots depending on which axis it is used on, and the type of the other axis.Name is a character variable that will make logistic, contingency, or oneway plots depending on which axis it is used on, and the type of the other axis.Name is a character variable that will make logistic, contingency, or oneway plots depending on which axis it is used on, and the type of the other axis.Name is a character variable that will make logistic, contingency, or oneway plots depending on which axis it is used on, and the type of the other axis.Name is a character variable that will make logistic, contingency, or oneway plots depending on which axis it is used on, and the type of the other axis.Name is a character variable that will make logistic, contingency, or oneway plots depending on which axis it is used on, and the type of the other axis.Name is a character variable that will make logistic, contingency, or oneway plots depending on which axis it is used on, and the type of the other axis.Name is a character variable that will make logistic, contingency, or oneway plots depending on which axis it is used on, and the type of the other axis.Name is a character variable that will make logistic, contingency, or oneway plots depending on which axis it is used on, and the type of the other axis.Name is a character variable that will make logistic, contingency, or oneway plots depending on which axis it is used on, and the type of the other axis.Name is a character variable that will make logistic, contingency, or oneway plots depending on which axis it is used on, and the type of the other axis.Name is a character variable that will make logistic, contingency, or oneway plots depending on which axis it is used on, and the type of the other axis.Name is a character variable that will make logistic, contingency, or oneway plots depending on which axis it is used on, and the type of the other axis.Name is a character variable that will make logistic, contingency, or oneway plots depending on which axis it is used on, and the type of the other axis.Name is a character variable that will make logistic, contingency, or oneway plots depending on which axis it is used on, and the type of the other axis.Name is a character variable that will make logistic, contingency, or oneway plots depending on which axis it is used on, and the type of the other axis.Name is a character variable that will make logistic, contingency, or oneway plots depending on which axis it is used on, and the type of the other axis.
Fix Y by X produces the expected Bivariate for two numeric columns.
You can concatenate together your Character Worksheet column with your Numeric Date column by using the following formula
:Character Worksheet || "_" || Format(
:Numeric Date,
"ddMonyyyy",
9
)
or in using the Concat() function
Concat( :Character Worksheet, "_",
Format( :Numeric Date, "ddMonyyyy", 9 )
);
The Format() function returns the date as a character string
right-click the top of the new column, pick formula from the pop up menu. Add the formula to do what you need.
the || is the concatenation operator. There are a bunch of date formats you can choose from.the || is the concatenation operator. There are a bunch of date formats you can choose from.the || is the concatenation operator. There are a bunch of date formats you can choose from.the || is the concatenation operator. There are a bunch of date formats you can choose from.the || is the concatenation operator. There are a bunch of date formats you can choose from.the || is the concatenation operator. There are a bunch of date formats you can choose from.the || is the concatenation operator. There are a bunch of date formats you can choose from.the || is the concatenation operator. There are a bunch of date formats you can choose from.the || is the concatenation operator. There are a bunch of date formats you can choose from.the || is the concatenation operator. There are a bunch of date formats you can choose from.
Right-click a column->Column Info is the way I usually re-discover the format names. I'd recommend making names that sort well for most purposes; probably put the year first, then month, day, and sheet number last. Unless you need all the sheet 1s to sort together.
the datetime formats are in a separate category.the datetime formats are in a separate category.the datetime formats are in a separate category.the datetime formats are in a separate category.the datetime formats are in a separate category.the datetime formats are in a separate category.the datetime formats are in a separate category.the datetime formats are in a separate category.the datetime formats are in a separate category.the datetime formats are in a separate category.
