Hello, I have using XY Chart for show line running status [image] for the data i have binded the dataset tag. It contains starttime,endtime and some more columns.Then i have added "Add Transform" script for convert dataset to json. Then the endtime of the last row of dataset should be show curre…

You are turning your datetime objects into strings. Don't do that. Just pass them through directly from the dataset. (They will become 64-bit integer milliseconds in the json.)

Please show a sample of your data and your transform code. (Paste as text and use the "Preformatted text" button in the forum editor to style it as code.)

This the Dataset i have binded: [image] : script: num_rows = value.getRowCount() if num_rows > 0: # Get the last row index (0-based) last_row_index = num_rows - 1 # Get the current date and time current_datetime = system.date.now() # Update the 'endtime' of the last row with…

Hello @pturmel , It is working!. But the tooltip shows only date format [image] i need HH:mm:ss (at least HH:mm) [image] [image]

[image] GOKULAKANNAN_P: 'reson2' btw careful for typo

Try setting xAxes.date.break.format. From here: https://docs.inductiveautomation.com/display/DOC81/Perspective+-+XY+Chart#PerspectiveXYChart-Properties

this topic has a bunch of examples of formats [image] Perspective XY Chart xAxes tooltip text {dateX} Ignition Further examples: [AM Charts dateX] Count: [bold]{valueY}[/] Time: [bold]{dateX.formatDate('HH:mm')}[/] {dateX.formatDate('yyyy-MMM-dd')} {dateX.formatDate('EE…

@pturmel it is not working . already the format is with HH:mm [image]

Thankyou!. @victordcq it is working. thank you @pturmel for your quick response. can you both give solution/idea for the my 2 nd point? Then the endtime of the last row is changed to current time when the propery binding is works. but i need the last row of end time should be always current tim…

you could do the forming of this data in a seperate custom property and then do a structered binding to this custom prop and on a now(5000) (best choose a delay) which only changes the last value. i wouldnt do it in the same script else you will have to loop through all the data every second(or wha…

Perspective xychart

General Discussion

victordcq July 24, 2023, 11:25am 8

this topic has a bunch of examples of formats