chart with time of timestamp

[vdcastro]

Hello everyone,

i am trying to build a line chart timestamp vs value. The timestamp must be in format HH:MM and just 30 in 30 minutes.

I have this table:

Timestamp(tstamp)	Value
26-07-2016 17:00:10	25
26-07-2016 17:00:15	26
26-07-2016 17:30:00	25
26-07-2016 17:30:05	25
26-07-2016 17:42:00	25
26-07-2016 17:42:05	34
26-07-2016 17:43:10	25
26-07-2016 17:43:16	25,1
26-07-2016 18:00:10	27
26-07-2016 18:00:15	27

My line chart has as dimension the time from timestamp (HH:MM) (17:00, 17:30, 18:00, etc) and has as expression the value.

My current result is:

My dimension is:

=if(Minute(tstamp)=00 or Minute(tstamp)=30 ,timestamp(Timestamp(tstamp, 'YYYY-MM-DD HH:MM:SS'),'h:mm'))

My expression is the value.

Can someone help me with this problem?

Greetings

[vdcastro]

It helps..thanks a lot

Greetings