<Dashboard>
  <Title Text="Timet 4P Energy Monitor" />
  <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="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_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="cost_gbp" />
          <Column Table="customer_energy_dashboard" Name="co2_tonnes" />
          <Column Table="customer_energy_dashboard" Name="kwh_peak" />
          <Column Table="customer_energy_dashboard" Name="kwh_off_peak" />
          <Column Table="customer_energy_dashboard" Name="kwh_previous_period" />
          <Column Table="customer_energy_dashboard" Name="kwh_change_percent" />
          <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="bics_eligible" />
          <Column Table="customer_energy_dashboard" Name="bics_potential_saving_gbp" />
          <Column Table="customer_energy_dashboard" Name="meter_multiplier" />
          <Column Table="customer_energy_dashboard" Name="quality_avg" />
          <Column Table="customer_energy_dashboard" Name="last_updated" />
          <Column Table="customer_energy_dashboard" Name="refresh_status" />
        </Columns>
      </Query>
      <ConnectionOptions CloseConnection="true" />
      <CalculatedFields>
        <CalculatedField Name="4P - TT10 (LV)" Expression="Iif([meter_name] = '4P Incomer (ACB 2500A)', [kwh_consumed], 0)" DataType="Auto" DataMember="customer_energy_dashboard" />
        <CalculatedField Name="4P2 - 300 A Fuse Board" Expression="Iif([meter_name] = '4P2 (MCB 1200A)', [kwh_consumed], 0)" DataType="Auto" DataMember="customer_energy_dashboard" />
        <CalculatedField Name="4P3 - Shop Relrole Bank" Expression="Iif([meter_name] = '4P3 (MCB 1250A FF7)', [kwh_consumed], 0)" DataType="Auto" DataMember="customer_energy_dashboard" />
        <CalculatedField Name="4P4 - Furnace FF7" Expression="Iif([meter_name] = '4P4 (MCB 1250A FF8)', [kwh_consumed], 0)" DataType="Auto" DataMember="customer_energy_dashboard" />
        <CalculatedField Name="4P5 - Furnace FF8" Expression="Iif([meter_name] = '4P5 (MCB 1250A FF10)', [kwh_consumed], 0)" DataType="Auto" DataMember="customer_energy_dashboard" />
      </CalculatedFields>
    </SqlDataSource>
  </DataSources>
  <Items>
    <ListBox ComponentName="listBoxAggregation" Name="Range" DataSource="DataSource1" DataMember="customer_energy_dashboard" ShowAllValue="false" ListBoxType="Radio">
      <DataItems>
        <Dimension DataMember="aggregation_level" DefaultId="DataItem0" />
      </DataItems>
      <FilterDimensions>
        <Dimension DefaultId="DataItem0" />
      </FilterDimensions>
    </ListBox>
    <Chart ComponentName="chartConsumption" Name="kWh Consumption" DataSource="DataSource1" DataMember="customer_energy_dashboard">
      <DataItems>
        <Dimension DataMember="period_start" DefaultId="DataItem1" />
        <Dimension DataMember="period_start" DateTimeGroupInterval="Month" DefaultId="DataItem2" />
        <Dimension DataMember="period_start" DateTimeGroupInterval="Day" DefaultId="DataItem3" />
        <Dimension DataMember="period_start" DateTimeGroupInterval="Hour" DefaultId="DataItem4" />
        <Measure DataMember="4P2 - 300 A Fuse Board" DefaultId="DataItem5" />
        <Measure DataMember="4P3 - Shop Relrole Bank" DefaultId="DataItem6" />
        <Measure DataMember="4P4 - Furnace FF7" DefaultId="DataItem7" />
        <Measure DataMember="4P5 - Furnace FF8" DefaultId="DataItem8" />
        <Measure DataMember="4P - TT10 (LV)" DefaultId="DataItem0" />
      </DataItems>
      <Arguments>
        <Argument DefaultId="DataItem1" />
        <Argument DefaultId="DataItem2" />
        <Argument DefaultId="DataItem3" />
        <Argument DefaultId="DataItem4" />
      </Arguments>
      <Panes>
        <Pane Name="Pane 1">
          <Series>
            <Simple SeriesType="Line">
              <Value DefaultId="DataItem0" />
            </Simple>
            <Simple SeriesType="StackedBar">
              <Value DefaultId="DataItem5" />
            </Simple>
            <Simple SeriesType="StackedBar">
              <Value DefaultId="DataItem6" />
            </Simple>
            <Simple SeriesType="StackedBar">
              <Value DefaultId="DataItem7" />
            </Simple>
            <Simple SeriesType="StackedBar">
              <Value DefaultId="DataItem8" />
            </Simple>
          </Series>
        </Pane>
      </Panes>
    </Chart>
    <RangeFilter ComponentName="rangeFilter1" Name="Date Range" DataSource="DataSource1" DataMember="customer_energy_dashboard">
      <DataItems>
        <Dimension DataMember="period_start" DateTimeGroupInterval="DayMonthYear" DefaultId="DataItem1" />
        <Measure DataMember="4P - TT10 (LV)" DefaultId="DataItem0" />
      </DataItems>
      <Argument DefaultId="DataItem1" />
      <Series>
        <Simple SeriesType="Line">
          <Value DefaultId="DataItem0" />
        </Simple>
      </Series>
    </RangeFilter>
    <Chart ComponentName="chartDashboardItem1" Name="Chart 1" ShowCaption="false" DataSource="DataSource1" DataMember="customer_energy_dashboard">
      <DataItems>
        <Dimension DataMember="period_start" DefaultId="DataItem1" />
        <Dimension DataMember="period_start" DateTimeGroupInterval="Month" DefaultId="DataItem2" />
        <Dimension DataMember="period_start" DateTimeGroupInterval="Day" DefaultId="DataItem3" />
        <Dimension DataMember="period_start" DateTimeGroupInterval="Hour" DefaultId="DataItem4" />
        <Measure DataMember="4P2 - 300 A Fuse Board" DefaultId="DataItem0" />
      </DataItems>
      <Arguments>
        <Argument DefaultId="DataItem1" />
        <Argument DefaultId="DataItem2" />
        <Argument DefaultId="DataItem3" />
        <Argument DefaultId="DataItem4" />
      </Arguments>
      <Panes>
        <Pane Name="Pane 1">
          <Series>
            <Simple>
              <Value DefaultId="DataItem0" />
            </Simple>
          </Series>
        </Pane>
      </Panes>
    </Chart>
    <Chart ComponentName="chartDashboardItem2" Name="Chart 2" ShowCaption="false" DataSource="DataSource1" DataMember="customer_energy_dashboard">
      <DataItems>
        <Dimension DataMember="period_start" DefaultId="DataItem1" />
        <Dimension DataMember="period_start" DateTimeGroupInterval="Month" DefaultId="DataItem2" />
        <Dimension DataMember="period_start" DateTimeGroupInterval="Day" DefaultId="DataItem3" />
        <Dimension DataMember="period_start" DateTimeGroupInterval="Hour" DefaultId="DataItem4" />
        <Measure DataMember="4P4 - Furnace FF7" DefaultId="DataItem0" />
      </DataItems>
      <Arguments>
        <Argument DefaultId="DataItem1" />
        <Argument DefaultId="DataItem2" />
        <Argument DefaultId="DataItem3" />
        <Argument DefaultId="DataItem4" />
      </Arguments>
      <Panes>
        <Pane Name="Pane 1">
          <Series>
            <Simple>
              <Value DefaultId="DataItem0" />
            </Simple>
          </Series>
        </Pane>
      </Panes>
    </Chart>
    <Chart ComponentName="chartDashboardItem3" Name="Chart 3" ShowCaption="false" DataSource="DataSource1" DataMember="customer_energy_dashboard">
      <DataItems>
        <Measure DataMember="4P5 - Furnace FF8" DefaultId="DataItem0" />
        <Dimension DataMember="period_start" DefaultId="DataItem1" />
        <Dimension DataMember="period_start" DateTimeGroupInterval="Month" DefaultId="DataItem2" />
        <Dimension DataMember="period_start" DateTimeGroupInterval="Day" DefaultId="DataItem3" />
        <Dimension DataMember="period_start" DateTimeGroupInterval="Hour" DefaultId="DataItem4" />
      </DataItems>
      <Arguments>
        <Argument DefaultId="DataItem1" />
        <Argument DefaultId="DataItem2" />
        <Argument DefaultId="DataItem3" />
        <Argument DefaultId="DataItem4" />
      </Arguments>
      <Panes>
        <Pane Name="Pane 1">
          <Series>
            <Simple>
              <Value DefaultId="DataItem0" />
            </Simple>
          </Series>
        </Pane>
      </Panes>
    </Chart>
    <Chart ComponentName="chartDashboardItem4" Name="Chart 4" ShowCaption="false" DataSource="DataSource1" DataMember="customer_energy_dashboard">
      <DataItems>
        <Measure DataMember="4P3 - Shop Relrole Bank" DefaultId="DataItem0" />
        <Dimension DataMember="period_start" DefaultId="DataItem1" />
        <Dimension DataMember="period_start" DateTimeGroupInterval="Month" DefaultId="DataItem2" />
        <Dimension DataMember="period_start" DateTimeGroupInterval="Day" DefaultId="DataItem3" />
        <Dimension DataMember="period_start" DateTimeGroupInterval="Hour" DefaultId="DataItem4" />
      </DataItems>
      <Arguments>
        <Argument DefaultId="DataItem1" />
        <Argument DefaultId="DataItem2" />
        <Argument DefaultId="DataItem3" />
        <Argument DefaultId="DataItem4" />
      </Arguments>
      <Panes>
        <Pane Name="Pane 1">
          <Series>
            <Simple>
              <Value DefaultId="DataItem0" />
            </Simple>
          </Series>
        </Pane>
      </Panes>
    </Chart>
  </Items>
  <LayoutTree>
    <LayoutGroup Weight="100">
      <LayoutGroup Orientation="Vertical" Weight="100">
        <LayoutGroup Weight="25.432225978487473">
          <LayoutItem DashboardItem="chartDashboardItem1" Weight="51.419960442651437" />
          <LayoutItem DashboardItem="chartDashboardItem4" Weight="50.486453023864492" />
          <LayoutItem DashboardItem="chartDashboardItem2" Weight="51.11667684956312" />
          <LayoutItem DashboardItem="chartDashboardItem3" Weight="51.907190997455473" />
        </LayoutGroup>
        <LayoutGroup Weight="56.510990340051038">
          <LayoutGroup Orientation="Vertical" Weight="95.525876460767947">
            <LayoutItem DashboardItem="chartConsumption" Weight="121.92375101502851" />
            <LayoutGroup Weight="73.602125445739432">
              <LayoutItem DashboardItem="listBoxAggregation" Weight="5.9362301876496995" />
              <LayoutItem DashboardItem="rangeFilter1" Weight="43.94336148856906" />
            </LayoutGroup>
          </LayoutGroup>
        </LayoutGroup>
      </LayoutGroup>
    </LayoutGroup>
  </LayoutTree>
</Dashboard>