<Dashboard>
  <Title Text="test" />
  <DataSources>
    <SqlDataSource ComponentName="DataSource1">
      <Name>customer_energy_dashboard</Name>
      <Connection Name="ConnectionString" FromAppConfig="true" />
      <Query Type="SelectQuery" Name="customer_energy_dashboard">
        <Tables>
          <Table Name="customer_energy_dashboard" />
        </Tables>
        <Columns>
          <Column Table="customer_energy_dashboard" Name="id" />
          <Column Table="customer_energy_dashboard" Name="customer_id" />
          <Column Table="customer_energy_dashboard" Name="customer_name" />
          <Column Table="customer_energy_dashboard" Name="site_id" />
          <Column Table="customer_energy_dashboard" Name="site_name" />
          <Column Table="customer_energy_dashboard" Name="meter_id" />
          <Column Table="customer_energy_dashboard" Name="meter_name" />
          <Column Table="customer_energy_dashboard" Name="meter_type" />
          <Column Table="customer_energy_dashboard" Name="meter_location" />
          <Column Table="customer_energy_dashboard" Name="period_start" />
          <Column Table="customer_energy_dashboard" Name="period_end" />
          <Column Table="customer_energy_dashboard" Name="aggregation_level" />
          <Column Table="customer_energy_dashboard" Name="kwh_consumed" />
          <Column Table="customer_energy_dashboard" Name="kwh_peak" />
          <Column Table="customer_energy_dashboard" Name="kwh_off_peak" />
          <Column Table="customer_energy_dashboard" Name="cost_gbp" />
          <Column Table="customer_energy_dashboard" Name="kwh_previous_period" />
          <Column Table="customer_energy_dashboard" Name="kwh_change_percent" />
          <Column Table="customer_energy_dashboard" Name="kwh_budget" />
          <Column Table="customer_energy_dashboard" Name="kwh_vs_budget_percent" />
          <Column Table="customer_energy_dashboard" Name="co2_tonnes" />
          <Column Table="customer_energy_dashboard" Name="co2_saving_vs_previous" />
          <Column Table="customer_energy_dashboard" Name="reading_count" />
          <Column Table="customer_energy_dashboard" Name="data_quality_score" />
          <Column Table="customer_energy_dashboard" Name="alert_flag" />
          <Column Table="customer_energy_dashboard" Name="alert_message" />
          <Column Table="customer_energy_dashboard" Name="bics_eligible" />
          <Column Table="customer_energy_dashboard" Name="bics_potential_saving_gbp" />
          <Column Table="customer_energy_dashboard" Name="last_updated" />
          <Column Table="customer_energy_dashboard" Name="refresh_status" />
        </Columns>
      </Query>
      <ConnectionOptions CloseConnection="true" />
    </SqlDataSource>
  </DataSources>
  <Items>
    <Grid ComponentName="gridDashboardItem1" Name="Grid 1">
      <GridOptions />
    </Grid>
    <Pivot ComponentName="pivotDashboardItem1" Name="Pivot 1" DataSource="DataSource1" DataMember="customer_energy_dashboard">
      <DataItems>
        <Measure DataMember="kwh_consumed" DefaultId="DataItem0" />
        <Dimension DataMember="site_name" DefaultId="DataItem2" />
        <Dimension DataMember="meter_name" DefaultId="DataItem1" />
      </DataItems>
      <Columns>
        <Column DefaultId="DataItem2" />
      </Columns>
      <Rows>
        <Row DefaultId="DataItem1" />
      </Rows>
      <Values>
        <Value DefaultId="DataItem0" />
      </Values>
    </Pivot>
  </Items>
  <LayoutTree>
    <LayoutGroup Weight="100">
      <LayoutItem DashboardItem="gridDashboardItem1" Weight="100" />
      <LayoutItem DashboardItem="pivotDashboardItem1" Weight="100" />
    </LayoutGroup>
  </LayoutTree>
</Dashboard>