Excel Report for last 24 hours

[bryanh]

I have a series of point that update every day at midnight. I am trying to export an excel report using the excel widget that only includes the values from this morning.

Which settings for the time period will give me those values?

I have tried past 24 hours, previous 24 hours, 11 pm yesterday to 8 am this morning, past 1 days, previous 1 days. None of those options give me the data I am looking for.

Any suggestions?

[JoelHaggar]

It sounds like what you want is the single cell data option. You can find this in the help documentation inside the Excel Reports Module:

This works by creating a named range such as "voltage" and then in your excel template give a single cell the named range of voltage.lastValue

Now link your voltage data point to the voltage named range.

From the help documentation:

Mango Data Available

Mango can insert various types of data into an Excel named range. Some are single cell while others require a column or row.

Single Cell Data

Single cell data can be assigned into cells by creating a named range with a .{data_name} postfix. For example to insert the XID for a data point one would use the named rangevoltage.average. Then via the Mango template configuration page one can link a data point to a named range of voltage. This will allow any named range that starts with voltage prefix to be filled in the the available single cell data. The following are a lists of available single cell data:

For any point:

xid - The XID of the linked point
name - The name of the linked point
deviceName - the device name of the linked point

For Numeric Points:

firstValue - The first value of the time period
firstTime - The date of the first value of the time period
lastValue - The last value of the time period
lastTime - The date of the last value of the time period
minimumValue - The statistical minimum value of the time period
minimumTime - The date of the statistical minimum value of the time period
maximumValue - The statistical maximum value of the time period
maximumTime - The date of the statistical maximum value of the time period
average - The statistical average value of the time period
integral - The statistical integral value of the time period
sum - The statistical sum of the time period
count - The count of samples within the time period

See more in the help documentation

[bryanh]

I modified my named ranges to include only a single cell and tried to run the report again. This time I got this alarm:

This alarm is present for all named ranges and disappears if I include one more cell in the named range.

However when I do so I still cannot read the data from this morning.

[JoelHaggar]

I think you misunderstood the single cell ranges. You still need a multi cell rage for time stamps and all historical values.. You would then add a single cell range called point2.LastValue and you will get the last value for the data point associated with the names range point2