<Dashboard>
  <Title Visible="false" Text="Hednesford" />
  <DataSources>
    <SqlDataSource ComponentName="DataSource1">
      <Name>meterreading</Name>
      <Connection Name="ConnectionString" FromAppConfig="true" />
      <Query Type="SelectQuery" Name="meterreading">
        <Tables>
          <Table Name="meterreading" />
          <Table Name="site" />
          <Table Name="energymeter" />
          <Relation Type="Inner" Parent="energymeter" Nested="site">
            <KeyColumn Parent="Site" Nested="Oid" />
          </Relation>
          <Relation Type="Inner" Parent="meterreading" Nested="energymeter">
            <KeyColumn Parent="Meter" Nested="Oid" />
          </Relation>
        </Tables>
        <Columns>
          <Column Table="energymeter" Name="Oid" />
          <Column Table="energymeter" Name="Site" />
          <Column Table="energymeter" Name="SerialNumber" />
          <Column Table="energymeter" Name="DisplayName" />
          <Column Table="energymeter" Name="InstallDate" />
          <Column Table="energymeter" Name="Multiplier" />
          <Column Table="energymeter" Name="OptimisticLockField" />
          <Column Table="energymeter" Name="GCRecord" />
          <Column Table="meterreading" Name="Oid" Alias="meterreading_Oid" />
          <Column Table="meterreading" Name="Meter" />
          <Column Table="meterreading" Name="TimestampUtc" />
          <Column Table="meterreading" Name="KWhTotal" />
          <Column Table="meterreading" Name="Quality" />
          <Column Table="meterreading" Name="Source" />
          <Column Table="meterreading" Name="IngestedAtUtc" />
          <Column Table="meterreading" Name="Notes" />
          <Column Table="meterreading" Name="OptimisticLockField" Alias="meterreading_OptimisticLockField" />
          <Column Table="meterreading" Name="GCRecord" Alias="meterreading_GCRecord" />
          <Column Table="site" Name="Oid" Alias="site_Oid" />
          <Column Table="site" Name="Name" />
          <Column Table="site" Name="Code" />
          <Column Table="site" Name="TimeZoneId" />
          <Column Table="site" Name="OptimisticLockField" Alias="site_OptimisticLockField" />
          <Column Table="site" Name="GCRecord" Alias="site_GCRecord" />
        </Columns>
      </Query>
      <ConnectionOptions CloseConnection="true" />
    </SqlDataSource>
  </DataSources>
  <Items>
    <Grid ComponentName="gridDashboardItem1" Name="Grid 1" DataSource="DataSource1" DataMember="meterreading">
      <DataItems>
        <Dimension DataMember="Name" DefaultId="DataItem1" />
        <Dimension DataMember="DisplayName" DefaultId="DataItem0" />
        <Measure DataMember="KWhTotal" SummaryType="Max" DefaultId="DataItem2" />
      </DataItems>
      <GridColumns>
        <GridDimensionColumn>
          <Dimension DefaultId="DataItem1" />
        </GridDimensionColumn>
        <GridDimensionColumn>
          <Dimension DefaultId="DataItem0" />
        </GridDimensionColumn>
        <GridMeasureColumn>
          <Measure DefaultId="DataItem2" />
        </GridMeasureColumn>
      </GridColumns>
      <GridOptions />
    </Grid>
    <Pivot ComponentName="pivotDashboardItem1" Name="Pivot 1" DataSource="DataSource1" DataMember="meterreading">
      <DataItems>
        <Measure DataMember="KWhTotal" SummaryType="Max" DefaultId="DataItem0" />
        <Measure DataMember="Meter" SummaryType="Count" DefaultId="DataItem1" />
        <Dimension DataMember="Name" DefaultId="DataItem3" />
        <Dimension DataMember="DisplayName" DefaultId="DataItem2" />
        <Dimension DataMember="KWhTotal" DefaultId="DataItem4" />
        <Dimension DataMember="TimestampUtc" DateTimeGroupInterval="DayMonthYear" DefaultId="DataItem5" />
        <Measure DataMember="KWhTotal" SummaryType="Max" DefaultId="DataItem6">
          <Calculation>
            <DifferenceCalculation />
          </Calculation>
          <WindowDefinition>
            <PivotWindowDefinition />
          </WindowDefinition>
        </Measure>
      </DataItems>
      <Rows>
        <Row DefaultId="DataItem3" />
        <Row DefaultId="DataItem2" />
        <Row DefaultId="DataItem5" />
        <Row DefaultId="DataItem4" />
      </Rows>
      <Values>
        <Value DefaultId="DataItem0" />
        <Value DefaultId="DataItem6" />
      </Values>
    </Pivot>
    <Chart ComponentName="chartDashboardItem1" Name="Chart 1" DataSource="DataSource1" DataMember="meterreading">
      <DataItems>
        <Dimension DataMember="TimestampUtc" DefaultId="DataItem0" />
        <Dimension DataMember="TimestampUtc" DateTimeGroupInterval="Month" DefaultId="DataItem1" />
        <Dimension DataMember="TimestampUtc" DateTimeGroupInterval="Day" DefaultId="DataItem2" />
        <Dimension DataMember="SerialNumber" DefaultId="DataItem3" />
        <Measure DataMember="KWhTotal" SummaryType="Max" DefaultId="DataItem4">
          <Calculation>
            <DifferenceCalculation />
          </Calculation>
          <WindowDefinition>
            <ChartWindowDefinition />
          </WindowDefinition>
        </Measure>
      </DataItems>
      <SeriesDimensions>
        <SeriesDimension DefaultId="DataItem3" />
      </SeriesDimensions>
      <Arguments>
        <Argument DefaultId="DataItem0" />
        <Argument DefaultId="DataItem1" />
        <Argument DefaultId="DataItem2" />
      </Arguments>
      <Panes>
        <Pane Name="Pane 1">
          <Series>
            <Simple>
              <Value DefaultId="DataItem4" />
            </Simple>
          </Series>
        </Pane>
      </Panes>
    </Chart>
  </Items>
  <LayoutTree>
    <LayoutGroup Orientation="Vertical" Weight="100">
      <LayoutGroup Weight="100">
        <LayoutItem DashboardItem="gridDashboardItem1" Weight="56.705620478575405" />
        <LayoutItem DashboardItem="pivotDashboardItem1" Weight="143.29437952142459" />
      </LayoutGroup>
      <LayoutItem DashboardItem="chartDashboardItem1" Weight="100" />
    </LayoutGroup>
  </LayoutTree>
</Dashboard>