simple line chart not working

[#1]

Hi all,

I am trying to make a simple line chart but it does not seem to work.

Athough it shows the data as a straight table the line chart does not render.

See attached example.

Regards.

[kaushiknsolanki]

Hi,

     This is because the TourqueValue is not in Number format, its in string format.

     Do following change in the script.

     Use the Num#() Function, to change string to number

TorqueData:

LOAD id,

  serial,

  firmware,

  SubField(TorqueVal,',',1) as Turn,

  num#(SubField(TorqueVal,',',2)) as TorqueValue,

  TestDate

Resident TorqueDataTmp;

Regards,

Kaushik Solanki

[Clever_Anjos · Accepted solution]

Your "TorqueValue" is loading as a text

Change

SubField(TorqueVal,',',2) as TorqueValue,

into

num#(trim(SubField(TorqueVal,',',2))) as TorqueValue,

Another point is that you need a aggregation function into your graph, maybe SUM() will fit

[#4]

Thaks you both of you for the quick reply.

How haven't I notice. Hmm its probably the lack of sleep