In power chart I need 12hours Data (43200). I mean in every second I need to read data from 26tags. while exporting to csv I need to display each second of data.
Just configure your history on the tags, you probably want to set it to periodic if this 1 second requirement is important.
Power chart will export whatever is visualised on the chart, annoyingly this also includes interpolation. I normally use a button to export so I can specify exactly what I want to export, using a script, for example:
results = system.tag.queryTagHistory(paths=tags, startDate=startTime, endDate=endTime, returnSize=-1, aggregationMode="LastValue", returnFormat='Wide')
csv = system.dataset.toCSV(dataset = results, showHeaders = True)
filename = "Foo_Bar.CSV"
system.perspective.download(filename, csv)
How will you show 43200 data points on your display? What is its horizontal resolution?
If you want the data in CSV format it may be better to run that as a separate regular query.
I want CSV File only ,but when I export 12hours last 2min data not fetching. Like when I exported 24 hours last 4 min data not fetching in csv file .
Your thread title says this a a Power Chart question but now you say it's a CSV export question.
Are you trying to export via the Power Chart? Why?
Hi Transistor ,I already mention above , Power chart export normal button to exporting while exporting time CSV file last 12hours 2.21seconds is not fetching data .
I will ask again:
@Hayden_Watson gave you a script solution and that is how I would recommend doing the task. I would set the history query to "As Stored" to get all the records from the tag history. The results will depend on how you configured the history deadband, mode as well as the minimum and maximum time between records.