Revision history [back]

You cannot escape post-processing in that case. That falls in your own lap, E+ will not help with it.

As far as how you go about it, that's totally up to you, but personally I would just request the Output:SQLite,SimpleAndTabular; and then query the SQL directly, using Python for eg. It's quite easy then to single output Reporting Frequencies:

SELECT * FROM ReportVariableWithTime WHERE ReportingFrequency = "Hourly"

I'm pretty sure you can also figure out something in Excel directly using a combination of Pivot table and/or VBA, but that's not something I would personally spend time on.

You cannot escape post-processing in that case. That falls in your own lap, E+ will not help with it.

As far as how you go about it, that's totally up to you, but personally I would just request the Output:SQLite,SimpleAndTabular; and then query the SQL directly, using Python for eg. It's quite easy then to single output Reporting Frequencies:

SELECT * FROM ReportVariableWithTime WHERE ReportingFrequency = "Hourly"

Or probably better yet;

SELECT EnvironmentPeriodIndex, Month, Day, Hour, Minute, KeyValue, Name, Units, Value
FROM ReportVariableWithTime
WHERE ReportingFrequency = "Hourly"

I'm pretty sure you can also figure out something in Excel directly using a combination of Pivot table and/or VBA, but that's not something I would personally spend time on.