Logi DataLayer Cols

Sample DataLayer Columns

Custom Column Examples
Raw Data	Seq #	Formatted	Calculated	Rank	Difference	Moving Avg	Running Total	Aggreg Sum	Percentage
32.38	1	$32.38	1.46	5	0.00	32.38	32.38	726.67	4.46%
11.61	2	$11.61	0.52	2	-20.77	22.00	43.99	726.67	1.60%
65.83	3	$65.83	2.96	10	54.22	36.61	109.82	726.67	9.06%
41.34	4	$41.34	1.86	6	-24.49	37.79	151.16	726.67	5.69%
51.3	5	$51.30	2.31	7	9.96	40.49	202.46	726.67	7.06%
58.17	6	$58.17	2.62	9	6.87	43.44	260.63	726.67	8.01%
22.98	7	$22.98	1.03	4	-35.19	40.52	283.61	726.67	3.16%
148.33	8	$148.33	6.67	13	125.35	53.99	431.94	726.67	20.41%
13.97	9	$13.97	0.63	3	-134.36	49.55	445.91	726.67	1.92%
81.91	10	$81.91	3.69	11	67.94	52.78	527.82	726.67	11.27%
140.51	11	$140.51	6.32	12	58.60	60.76	668.33	726.67	19.34%
3.25	12	$3.25	0.15	1	-137.26	55.97	671.58	726.67	0.45%
55.09	13	$55.09	2.48	8	51.84	55.90	726.67	726.67	7.58%

<DataTable AjaxPaging="True" AltRowClass="ThemeAlternatingRow TD" Caption="Custom Column Examples" CaptionClass="font11pt" ID="dtCustomCols" Width="1050" WidthScale="px" IdeDisplayStatus="Collapsed">
  <DataLayer ID="dlOrdersXML" Type="XMLFile" XMLFile="NW_Orders.xml" IdeDisplayStatus="Collapsed">
    <DataLayerLink ID="lnkOrderData" />
    <ConditionFilter Condition=" &lt; 10261" />
    <Note Note="Each of the following elements creates a new column within the datalayer" />
    <AggregateColumn AggregateColumn="Freight" AggregateFunction="Sum" DataType="Number" ID="Aggregate" />
    <CalculatedColumn Formula=" * .045" ID="Calculated" />
    <DifferenceColumn DataColumn="Freight" ID="Difference" ReCalculateAfterSort="True" />
    <FormattedColumn DataColumn="Freight" Format="Currency" ID="Formatted" />
    <MovingAverageColumn DataColumn="Freight" ID="MovingAverage" MovingAveragePeriod="100" ReCalculateAfterSort="True" />
    <PercentOfTotalColumn DataColumn="Freight" ID="PercentTotal" />
    <RankColumn DataColumn="Freight" ID="Rank" RankType="Rank" />
    <RunningTotalColumn DataColumn="Freight" ID="RunningTotal" ReCalculateAfterSort="True" />
    <SequenceColumn ID="Sequence" />
  </DataLayer>
  <DataTableColumn Class="ThemeAlignRight" Header="Raw Data" ID="colRawData" IdeDisplayStatus="Collapsed">
    <Label Caption="" ID="lblFreight" />
    <DataColumnSort DataColumn="Freight" DataType="Number" />
  </DataTableColumn>
  <DataTableColumn Class="ThemeAlignCenter" Header="Seq #" ID="colSequence" IdeDisplayStatus="Collapsed">
    <Label Caption="" ID="lblSequence" />
    <DataColumnSort DataColumn="Sequence" DataType="Number" />
  </DataTableColumn>
  <DataTableColumn Class="ThemeAlignRight" Header="Formatted" ID="colFormatted" IdeDisplayStatus="Collapsed">
    <Label Caption="" ID="lblFormatted" />
    <DataColumnSort DataColumn="Freight" DataType="Number" />
  </DataTableColumn>
  <DataTableColumn Class="ThemeAlignRight" Header="Calculated" ID="colCalculated" IdeDisplayStatus="Collapsed">
    <Label Caption="" Format="###,###,##0.00" ID="lblCalculated" />
    <DataColumnSort DataColumn="Calculated" DataType="Number" />
  </DataTableColumn>
  <DataTableColumn Class="ThemeAlignCenter" Header="Rank" ID="colRank" IdeDisplayStatus="Collapsed">
    <Label Caption="" ID="lblRank" />
    <DataColumnSort DataColumn="Rank" DataType="Number" />
  </DataTableColumn>
  <DataTableColumn Class="ThemeAlignRight" Header="Difference" ID="colDifference" IdeDisplayStatus="Collapsed">
    <Label Caption="" Format="###,###,##0.00" ID="lblDifference" />
    <DataColumnSort DataColumn="Difference" DataType="Number" />
  </DataTableColumn>
  <DataTableColumn Class="ThemeAlignRight" Header="Moving Avg" ID="colMovingAverage" IdeDisplayStatus="Collapsed">
    <Label Caption="" Format="###,###,##0.00" ID="lblMovingAverage" />
    <DataColumnSort DataColumn="MovingAverage" DataType="Number" />
  </DataTableColumn>
  <DataTableColumn Class="ThemeAlignRight" Header="Running Total" ID="colRunningTotal" IdeDisplayStatus="Collapsed">
    <Label Caption="" Format="###,###,##0.00" ID="lblRunningTotal" />
    <DataColumnSort DataColumn="RunningTotal" />
  </DataTableColumn>
  <DataTableColumn Class="ThemeAlignRight" Header="Aggreg Sum" ID="colAggregate" IdeDisplayStatus="Collapsed">
    <Label Caption="726.67" Format="###,###,##0.00" ID="lblAggregate" />
    <DataColumnSort DataColumn="Aggregate" DataType="Number" />
  </DataTableColumn>
  <DataTableColumn Class="ThemeAlignCenter" Header="Percentage" ID="colPercent" IdeDisplayStatus="Collapsed">
    <Label Caption="" Format="Percent" ID="lblPercentageTotal" />
    <DataColumnSort DataColumn="PercentTotal" DataType="Number" />
  </DataTableColumn>
</DataTable>

Logi Analytics, Inc. 7900 Westpark Drive, Suite A-200, McLean, Virginia 22102 U.S.A.