I have a measurement result data to report. However, the data contain about 20 test and some test result are number and some others are string. currently they are all assigned as string.
In my report, I want to draw trend line for numeric test result. So I need cast numeric test result to float and add to sheet as continuous.
I already created two sets, one for numeric result and one for string result. However, I cannot assign data type for set and I cannot create calculation field for numeric set to cast test result to float.
How could i assign different data type for entries of same column?
Duplicate the data field, set one to number type, and one to string type.