[Kst] Combine date / time columns to one x-axis

[Peter Kümmel]

On 20.11.2012 23:58, Nicolas Brisset wrote:
> Hi Alexander,
>
> sorry for not answering before. With 2.0.7 (beta4 currently available for Windows on sf.net, otherwise from svn) you could merge time and date if the columns were separated only by whitespace (no semicolon). We'll have to see whether we can also accept a semicolon or other separator, it should be feasible.

In case of reading the date the delimiteris not important, only that there is only one space between date and time.
Here the needed options in the Ascii dialog:
  - "Data starts at line:" 2
  - "Read field names from line:" 1
  - select "Custom Delemiter" and set it to ;
  - Interpret Date as Formatted Time
  - use "Time Format" dd.MM.yyyy; hh:mm:ss;

Load all vectors but "Date" and "Time", then "Create XY plots" -> "Create from field" -> Date

Double click on the Time axis:
  - Interpret as "Standard C time"
  - Display as -> select a format, e.g. QDateTime format string
  - check "For Offset to axis Minimum"



> In order to do so, in the ASCII configuration dialog you have to set in the General options Interpret Column1 as Formatted String and use as Time/Date format: dd.MM.yyyy hh:mm:ss
> Doing so Column1 gets read as C time, and you can then turn on C time interpretation and time display options in the X axis dialog (double-click on the values on an X axis, then select multiple to select all plot, then select time interpretation/display options).
>
> I hope that's clear, if not don't hesitate to ask for details.
>
> Nicolas
>
> ----- Mail original -----
>> De: "Alexander Poddey" <alexander.poddey at gmx.net>
>> À: kst at kde.org
>> Envoyé: Samedi 17 Novembre 2012 08:15:57
>> Objet: [Kst] Combine date / time columns to one x-axis
>>
>> Hi all,
>>
>> from a controller, I have data with separate date / time column
>>
>> Date;Time;Sens1;Sens2;Sens3;Sens4;Sens5
>> 01.11.2012; 00:03:10; 7.8; 71.8; 55.1; 58.3; 22.6
>> 01.11.2012; 00:08:10; 7.8; 71.8; 55.1; 58.1; 22.7
>> 01.11.2012; 00:13:10; 7.8; 71.8; 55.1; 57.8; 22.6
>> 01.11.2012; 00:18:10; 7.9; 71.7; 55.1; 57.5; 22.7
>>
>> is it possible to combine the first two cloumns as x-axis and plot
>> x,y1,y2
>> etc.?
>> The data is equiapced; perhaps it might be easier to plot as
>> equispaced
>> y-values, using date & time as labels?
>>
>> Thx
>> Alex
>>
>>
>> _______________________________________________
>> Kst mailing list
>> Kst at kde.org
>> https://mail.kde.org/mailman/listinfo/kst
>>
> _______________________________________________
> Kst mailing list
> Kst at kde.org
> https://mail.kde.org/mailman/listinfo/kst
>