Vmurrell: Vmurrell moved page Resultset Metrics - FXLData - Draft to Resultset Metrics - FXLData

2024-07-25T11:05:54Z

Vmurrell moved page Resultset Metrics - FXLData - Draft to Resultset Metrics - FXLData

Vmurrell: Created page with "Category:How to and other features in FXLData =Resultset Metrics= Metrics are shown in the first row of the result set if headers are enabled.
File:Example Metrics 0..."

2024-07-22T10:20:48Z

Created page with "Category:How to and other features in FXLData =Resultset Metrics= Metrics are shown in the first row of the result set if headers are enabled.<br> File:Example Metrics 0..."

New page

[[Category:How to and other features in FXLData]]
=Resultset Metrics=
Metrics are shown in the first row of the result set if headers are enabled.<br>
[[File:Example Metrics 0 7 0.JPG|thumb|Example Metrics]]

===Series Count===
100/3608 series

<base series retrieved>/<base series available> ''series''

* <base series retrieved> is the number of base series retrieved ''before any calculated measures are added or aggregations performed''.<br>
* <base series available> is the total number of base series available for the query.

====The effect of calculated measures====
If the query includes calculated measures such as percentage change or moving average, the actual number of series retrieved will be '''higher''' than the reported base series. The actual number of series in the result set can generally be calculated as:

''<base series retrieved> * (1 + <number of calculated measures>)''

Note that this formula does not hold true when combining aggregations with calculated measures.

====The effect of aggregations====
Aggregations reduce the number of series retrieved due to the removal of one or more dimensions. Thus, the series retrieved will be '''lower''' than the reported base series.

===Function Execution Time===
0.29 seconds

<execution time> ''seconds''

The actual time the function took to retrieve the data from the Fusion Registry and return the result set to Excel.

===Resultset freshness timestamp===
18/11/2021 17:10:07

<date time>

The date and time the resultset was last refreshed from the Fusion Registry data source.

====Controlling when metrics are displayed====
For parameterised functions (=FXLData() and =FXLDataV()), metrics are displayed when the ''IncludeHeader'' argument is <code>TRUE</code>. Set to <code>FALSE</code> to omit metrics.<br>
For URL functions (=FXLDataUrl() and =FXLDataUrlV()), metrics are displayed if the REST API parameter <code>excludeHeader=false</code>. Set the parameter to <code>excludeHeader=true</code> to omit metrics.

← Older revision	Revision as of 11:05, 25 July 2024
(No difference)

Resultset Metrics - FXLData - Revision history

Vmurrell: Vmurrell moved page Resultset Metrics - FXLData - Draft to Resultset Metrics - FXLData

Vmurrell: Created page with "Category:How to and other features in FXLData =Resultset Metrics= Metrics are shown in the first row of the result set if headers are enabled. File:Example Metrics 0..."

Vmurrell: Created page with "Category:How to and other features in FXLData =Resultset Metrics= Metrics are shown in the first row of the result set if headers are enabled.
File:Example Metrics 0..."