Calculation Type in Elastic Report

[Hari]

Hi,

The possible calculation types of data items:
* Val – the value of the bound input channel at the current time point,
* FirstVal – the value at the first time point of the working period,
* LastVal – the value at the last time point of the working period,
* Diff – the difference between the values at the current and previous time points,
* DiffNext – the difference between the values at the next and current time points,
* Const – the constant value to insert in an appropriate cell,
* Formula – the formula to insert in an appropriate cell. Supported for Excel output format only,
* Now – the report building time.

Similarly, Any other Calculation Type is available to calculate average of that time?

[Mikhail]

Hi,

In Elastic Report, to calculate average by column or row, use calcAvg attribute. See ElasticRepExample.xml

[Hari]

I want to calculate average of particular time, for eg. Average value of 3.00AM – 4.00AM

We are using CalcAvg formula to calculate average value of entire column, but I need to calculate average value of particular hour.

[Mikhail]

If you mean that you need an average of all datapoints between 3 and 4am, you should use averaging formulas in the configuration database.

[Hari]

Can you explain where i need to add that average formula in configuration database?

[Mikhail]

You should add the formulas into the Formulas table. Then upload configuration to check if it still works. If OK, set formulas to input channels as written here.

[Hari]

Thanks Mikhail

[Hari]

Hi Mikhail,

If i add those formulas in the formula table and upload that configuration, in browser it is showing as Server is Unavailable.

[Mikhail]

Hi,

Check server log for errors.

[Author]

Posts