Export powerchart

ezzat_wan · February 14, 2025, 8:31am

Hi,

i have export powerchart to csv. but i generate both same timestamp for each data. but the value is different. what does it mean?

Thanks

Ezt.

jonathan.taylor · February 14, 2025, 10:22am

Is your data query asking for min/max values?

pturmel · February 14, 2025, 12:57pm

Also, your time steps are odd, probably because you have a fixed return size and the start and end timestamps are further apart than that many hours. Failing to normalize the endpoints makes for weird and unreliable interpolations.

ezzat_wan · February 17, 2025, 1:56am

I believe the powerchart is all built in things. I didn't use my own custom query to export it to csv. So I don't think it's asking for min max

Transistor · February 17, 2025, 2:34am

You can check this by hitting the button, Pens tab, ✎, Aggregation Mode (at the bottom of the dialog).

ezzat_wan · February 17, 2025, 3:27am

Hi @Transistor ,

Aggregation Mode is set to Default.

ezzat_wan · February 17, 2025, 4:28am

I checked, Aggregation Mode in Default is set to min/max. But it will better if can export only 1 row for each data.

Transistor · February 17, 2025, 9:14am

Your options, according to Perspective - Power Chart | Ignition User Manual, are,

aggregateMode: Mode to use to group the data. Options are: default (MinMax), Average, MinMax, LastValue, SimpleAverage, Sum, Minimum, Maximum, DurationOn, DurationOff, CountOn, CountOff, Count, Range, Variance, StdDev, PctGood, or PctBad. Value is string.

Try one of the modes I've highlighted. Each of those should return a single value.