June 23, 2018 at 1:28 pm #3896
i need different reports based on hours, shift (working) hours, daily, weekly, monthly… and any kind of time period.
Is “Elastic Report” able to define the report time period, i.e. for an 8-hours shift period?
regardsJune 24, 2018 at 11:34 am #3898
Same questions here on Elastic Report. Would like to be able to draw data from minutes and hourly data archive to report on hourly computations, and also for work shifts such as OEE reports (uses at least 3 channels of data).
The ElasticReportExample uses hourly data from 12pm, not sure how to extend that into one or multiple shifts. Also the use of formula in Excel format does not show how to reference values from related channels at the same timeslot.
Thanks.June 24, 2018 at 2:04 pm #3900
Could you provide an example of a required report?June 24, 2018 at 2:11 pm #3902
Hi Mikhail, for example:
One needs to report different energy consumptions for every shift between 00:00-08:00, 08:00-16:00 and 16:00-24:00, additionally hourly, daily, weekly, monthly…
How to achieve that?
RegardsJune 25, 2018 at 4:31 pm #3908
Currently, possible values of the detailing parameter: Hour, Day, Month, BeginEnd.
It means that you can get consumption between every hour, every day, every month or between the beginning and the end of the selected period.
To support custom time period and weekly period, the Elastic Report plugin should be updated.
Would like to be able to draw data from minutes
Elastic Report uses hourly data. If you need minute data, please provide examples.June 26, 2018 at 1:09 pm #3921
… or between the beginning and the end of the selected period.
Could be an alternative solution, if we could enter not only the date, but also concrete beginning and ending time (hours) when we let create the report at the elastic report page… For example: Same day, but only the beginning and ending times differ!?
June 26, 2018 at 2:14 pm #3931
- This reply was modified 1 year ago by jacklondon.
It requires an update of the plugin. We can discuss such development.
The solution that can be implemented using the current plugin version: use Excel formulas to calculate consumption for needed ranges of time. I mean you get a report with hour detailing and Excel refers to the specified cells and calculates required values.July 5, 2018 at 6:38 pm #3968
i think it would be enough for the beginning, to have also a range definition for hours (begin and end) additionally to date range at the page where we call an elasticreport, if possible!?
That way we could give the same date as begin/end and then define the hour range for example for shift begin and end.
RegardsJuly 6, 2018 at 2:51 pm #3970
Could you send me an email to this address? I will estimate a cost of the update and answer by email.February 6, 2019 at 1:47 am #4970
How to set the elastic report to show the maximum value attained for the day of a channel?February 6, 2019 at 1:07 pm #4973
You need an input channel that stores max. value of each day. Than use this channel in your report configuration file.
You must be logged in to reply to this topic.