<Dashboard>
  <Title Text="using stored proc" />
  <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>
          <AllColumns Table="customer_energy_dashboard" />
        </Columns>
      </Query>
      <ConnectionOptions CloseConnection="true" />
    </SqlDataSource>
  </DataSources>
  <Parameters>
    <Parameter Name="Parameter1" />
    <Parameter Name="Parameter2" />
    <Parameter Name="Parameter3" />
  </Parameters>
  <Items>
    <Grid ComponentName="gridDashboardItem1" Name="Meter Consumption" DataSource="DataSource1" DataMember="customer_energy_dashboard">
      <DataItems>
        <Dimension DataMember="period_start" DateTimeGroupInterval="DateHour" DefaultId="DataItem1" />
        <Measure DataMember="kwh_consumed" SummaryType="Max" DefaultId="DataItem0">
          <NumericFormat FormatType="Number" Unit="Ones" IncludeGroupSeparator="true" />
        </Measure>
        <Dimension DataMember="meter_name" DefaultId="DataItem2" />
      </DataItems>
      <GridColumns>
        <GridDimensionColumn>
          <Dimension DefaultId="DataItem1" />
        </GridDimensionColumn>
        <GridDimensionColumn>
          <Dimension DefaultId="DataItem2" />
        </GridDimensionColumn>
        <GridMeasureColumn>
          <Measure DefaultId="DataItem0" />
        </GridMeasureColumn>
      </GridColumns>
      <GridOptions />
    </Grid>
    <ListBox ComponentName="listBoxDashboardItem2" Name="Site" DataSource="DataSource1" DataMember="customer_energy_dashboard" ShowAllValue="false" ListBoxType="Radio">
      <DataItems>
        <Dimension DataMember="site_name" DefaultId="DataItem0" />
      </DataItems>
      <FilterDimensions>
        <Dimension DefaultId="DataItem0" />
      </FilterDimensions>
    </ListBox>
    <Chart ComponentName="chartDashboardItem1" Name="Chart 1" ShowCaption="false" DataSource="DataSource1" DataMember="customer_energy_dashboard">
      <DataItems>
        <Dimension DataMember="meter_name" DefaultId="DataItem1" />
        <Measure DataMember="kwh_consumed" SummaryType="Max" DefaultId="DataItem2">
          <NumericFormat FormatType="Number" Unit="Ones" IncludeGroupSeparator="true" />
        </Measure>
        <Dimension DataMember="period_start" DefaultId="DataItem0" />
        <Dimension DataMember="period_start" DateTimeGroupInterval="Month" DefaultId="DataItem4" />
        <Dimension DataMember="period_start" DateTimeGroupInterval="Day" DefaultId="DataItem5" />
        <Dimension DataMember="period_start" DateTimeGroupInterval="Hour" DefaultId="DataItem6" />
      </DataItems>
      <SeriesDimensions>
        <SeriesDimension DefaultId="DataItem1" />
      </SeriesDimensions>
      <Arguments>
        <Argument DefaultId="DataItem0" />
        <Argument DefaultId="DataItem4" />
        <Argument DefaultId="DataItem5" />
        <Argument DefaultId="DataItem6" />
      </Arguments>
      <Panes>
        <Pane Name="Pane 1">
          <Series>
            <Simple>
              <Value DefaultId="DataItem2" />
            </Simple>
          </Series>
        </Pane>
      </Panes>
    </Chart>
    <ListBox ComponentName="listBoxDashboardItem1" 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>
    <ListBox ComponentName="listBoxDashboardItem3" Name="Meter" DataSource="DataSource1" DataMember="customer_energy_dashboard">
      <DataItems>
        <Dimension DataMember="meter_name" DefaultId="DataItem0" />
      </DataItems>
      <FilterDimensions>
        <Dimension DefaultId="DataItem0" />
      </FilterDimensions>
    </ListBox>
  </Items>
  <LayoutTree>
    <LayoutGroup Orientation="Vertical" Weight="100">
      <LayoutGroup Weight="71.545827633378934">
        <LayoutItem DashboardItem="listBoxDashboardItem1" Weight="25.925925925925924" />
        <LayoutItem DashboardItem="listBoxDashboardItem2" Weight="57.744107744107751" />
        <LayoutItem DashboardItem="listBoxDashboardItem3" Weight="57.744107744107751" />
        <LayoutItem DashboardItem="gridDashboardItem1" Weight="216.32996632996634" />
      </LayoutGroup>
      <LayoutGroup Weight="128.45417236662107">
        <LayoutGroup Orientation="Vertical" Weight="100">
          <LayoutItem DashboardItem="chartDashboardItem1" Weight="200.54719562243503" />
        </LayoutGroup>
      </LayoutGroup>
    </LayoutGroup>
  </LayoutTree>
</Dashboard>