Forum Home › Forums › Understanding the Software › Reading Day in Elastic Report
Tagged: elastic report
- This topic has 17 replies, 3 voices, and was last updated 3 years, 4 months ago by
Hari.
-
AuthorPosts
-
August 11, 2022 at 10:01 am #10468
Hari
ParticipantHi,
Can you explain, what will happen if we change Reading Day to 1 or any other value in elastic report?
This is the example code in Elastic Report xml file.
<!– Day of monthly meter readings –>
<ReadingDay>20</ReadingDay>-
This topic was modified 3 years, 5 months ago by
Mikhail.
August 11, 2022 at 11:02 am #10470
MikhailModeratorHi,
In the example configuration file ElasticRepExample.xml all parameters have descriptions.
ReadingDay – Day of monthly meter readings
It means that this is a day of month that is used to get values if report argument is a month without specific date. For example, if report period is from April to May, the actual data period would be from April 20 to May 20.August 11, 2022 at 12:43 pm #10471Hari
ParticipantThanks Mikhail.
And how to set time range (Reading Hour) for getting single day data. For Eg, I need data for 00:00 to 23:00 for a particular day.
August 12, 2022 at 9:48 am #10472
MikhailModeratorSet ReadingHour to 0.
Select the same start and end dates in the report parameters form.August 12, 2022 at 10:32 am #10473Hari
ParticipantIf I set reading hour to 0 I’m getting data for next day 00hrs also. I have selected Same start and end dates in reports.
I need data for that particular day alone.
August 15, 2022 at 6:23 am #10476
MikhailModeratorThe link does not work. Please provide public access for the link.
August 15, 2022 at 6:28 am #10477August 16, 2022 at 2:14 pm #10480
MikhailModeratorCould you try to set SkipFirstHour parameter of the section to true?
Then publish a screenshot with SkipFirstHour=trueAugust 17, 2022 at 6:53 am #10483August 17, 2022 at 11:08 am #10484
MikhailModeratorThank you for the screenshot.
To solve the issue, a new parameter SkipLastHour should be implemented for the plugin. I’ve added it to the list of features to implement.August 17, 2022 at 11:11 am #10486Hari
ParticipantThanks Mikhail.
August 17, 2022 at 11:17 am #10488Hari
ParticipantIs there any attributes for calculating standard deviation like we have calcAvg to calculate Average?
August 18, 2022 at 10:56 am #10491
MikhailModeratorIf you export reports in Excel format, you could use Excel formulas.
In case of using PFD, there are average, sum, min and max functions available.August 18, 2022 at 11:00 am #10492Hari
ParticipantWe can directly type formulas in that xml file or we have to do calculations only in excel after exporting?
August 28, 2022 at 1:16 am #10562
victorlamParticipantI see that there is “average” column inside the input channel description table? May I know what is the meaning of average here? Not sure why there is average for one channel number value?
-
This topic was modified 3 years, 5 months ago by
-
AuthorPosts
- You must be logged in to reply to this topic.