<Dashboard>
  <Title Text="GreenHouse" />
  <DataSources>
    <SqlDataSource ComponentName="DataSource1">
      <Name>hydroponics.hydroponic_1</Name>
      <Connection Name="Greenhouse" FromAppConfig="true" />
      <Query Type="StoredProcQuery" Name="hydroponics.hydroponic_1">
        <ProcName>hydroponics.hydroponic_1</ProcName>
      </Query>
      <ConnectionOptions CloseConnection="true" />
      <CalculatedFields>
        <CalculatedField Name="Temp_formated" Expression="[temperature] / 10" DataType="Decimal" DataMember="hydroponics.hydroponic_1" />
        <CalculatedField Name="Hum_formated" Expression="[humidity] / 10" DataType="Decimal" DataMember="hydroponics.hydroponic_1" />
      </CalculatedFields>
    </SqlDataSource>
  </DataSources>
  <Items>
    <Pivot ComponentName="pivotDashboardItem1" Name="Pivot 1" DataSource="DataSource1" DataMember="hydroponics.hydroponic_1">
      <DataItems>
        <Dimension DataMember="DateString" DateTimeGroupInterval="DayMonthYear" DefaultId="DataItem0" />
        <Measure DataMember="baro" ShowTotals="false" ShowGrandTotals="false" SummaryType="Max" DefaultId="DataItem1">
          <NumericFormat FormatType="Number" Unit="Ones" />
        </Measure>
        <Dimension DataMember="DateString" DateTimeGroupInterval="DayMonthYear" DefaultId="DataItem4" />
        <Dimension DataMember="DateString" DateTimeGroupInterval="MonthYear" DefaultId="DataItem6" />
        <Dimension DataMember="DateString" DateTimeGroupInterval="Day" DefaultId="DataItem7" />
        <Dimension DataMember="DateString" DateTimeGroupInterval="Hour" DefaultId="DataItem8" />
        <Measure DataMember="Hum_formated" ShowTotals="false" ShowGrandTotals="false" SummaryType="Max" DefaultId="DataItem5">
          <NumericFormat FormatType="Number" Unit="Ones" />
        </Measure>
        <Measure DataMember="Temp_formated" ShowTotals="false" ShowGrandTotals="false" SummaryType="Max" DefaultId="DataItem2">
          <NumericFormat FormatType="Number" Unit="Ones" />
        </Measure>
      </DataItems>
      <Rows>
        <Row DefaultId="DataItem6" />
        <Row DefaultId="DataItem7" />
        <Row DefaultId="DataItem8" />
      </Rows>
      <Values>
        <Value DefaultId="DataItem1" />
        <Value DefaultId="DataItem5" />
        <Value DefaultId="DataItem2" />
      </Values>
    </Pivot>
    <Chart ComponentName="chartDashboardItem1" Name="Chart 1" DataSource="DataSource1" DataMember="hydroponics.hydroponic_1">
      <DataItems>
        <Dimension DataMember="DateString" DateTimeGroupInterval="MonthYear" DefaultId="DataItem1" />
        <Dimension DataMember="DateString" DateTimeGroupInterval="Day" DefaultId="DataItem2" />
        <Dimension DataMember="DateString" DateTimeGroupInterval="Hour" DefaultId="DataItem3" />
        <Measure DataMember="Temp_formated" SummaryType="Max" DefaultId="DataItem0">
          <NumericFormat FormatType="Number" Unit="Ones" />
        </Measure>
        <Measure DataMember="NPK_Temp" SummaryType="Max" Expression="Max([NPK_Temp] * 0.1)" DefaultId="DataItem5">
          <WindowDefinition>
            <ChartWindowDefinition />
          </WindowDefinition>
        </Measure>
      </DataItems>
      <Arguments>
        <Argument DefaultId="DataItem1" />
        <Argument DefaultId="DataItem2" />
        <Argument DefaultId="DataItem3" />
      </Arguments>
      <Panes>
        <Pane Name="Pane 1">
          <Series>
            <Simple SeriesType="Line">
              <Value DefaultId="DataItem0" />
            </Simple>
            <Simple Name="NPK_Temp" SeriesType="Line">
              <Value DefaultId="DataItem5" />
            </Simple>
          </Series>
        </Pane>
      </Panes>
    </Chart>
    <RangeFilter ComponentName="rangeFilterDashboardItem1" Name="Range Filter 1" DataSource="DataSource1" DataMember="hydroponics.hydroponic_1">
      <DataItems>
        <Dimension DataMember="DateString" DateTimeGroupInterval="DayMonthYear" DefaultId="DataItem0" />
        <Measure DataMember="Temp_formated" SummaryType="Max" DefaultId="DataItem1" />
      </DataItems>
      <Argument DefaultId="DataItem0" />
      <Series>
        <Simple SeriesType="Line">
          <Value DefaultId="DataItem1" />
        </Simple>
      </Series>
    </RangeFilter>
    <Chart ComponentName="chartDashboardItem2" Name="Chart 2" DataSource="DataSource1" DataMember="hydroponics.hydroponic_1">
      <DataItems>
        <Dimension DataMember="DateString" DateTimeGroupInterval="MonthYear" DefaultId="DataItem1" />
        <Dimension DataMember="DateString" DateTimeGroupInterval="Day" DefaultId="DataItem2" />
        <Dimension DataMember="DateString" DateTimeGroupInterval="Hour" DefaultId="DataItem3" />
        <Measure DataMember="NPK_N" SummaryType="Max" DefaultId="DataItem0" />
      </DataItems>
      <Arguments>
        <Argument DefaultId="DataItem1" />
        <Argument DefaultId="DataItem2" />
        <Argument DefaultId="DataItem3" />
      </Arguments>
      <Panes>
        <Pane Name="Pane 1">
          <Series>
            <Simple SeriesType="Line">
              <Value DefaultId="DataItem0" />
            </Simple>
          </Series>
        </Pane>
      </Panes>
    </Chart>
    <Pie ComponentName="pieDashboardItem1" Name="NPK" DataSource="DataSource1" DataMember="hydroponics.hydroponic_1" ShowPieCaptions="false">
      <DataItems>
        <Measure DataMember="NPK_Hum" SummaryType="Max" DefaultId="DataItem0" />
        <Measure DataMember="NPK_K" Name="K" SummaryType="Max" DefaultId="DataItem2" />
        <Measure DataMember="NPK_P" Name="P" SummaryType="Max" DefaultId="DataItem3" />
        <Measure DataMember="NPK_N" Name="N" SummaryType="Max" DefaultId="DataItem4" />
      </DataItems>
      <HiddenMeasures>
        <Measure DefaultId="DataItem0" />
      </HiddenMeasures>
      <Values>
        <Value DefaultId="DataItem2" />
        <Value DefaultId="DataItem3" />
        <Value DefaultId="DataItem4" />
      </Values>
    </Pie>
  </Items>
  <LayoutTree>
    <LayoutGroup Orientation="Vertical" Weight="100">
      <LayoutGroup Weight="100">
        <LayoutGroup Orientation="Vertical" Weight="100">
          <LayoutGroup Weight="100">
            <LayoutGroup Orientation="Vertical" Weight="100">
              <LayoutItem DashboardItem="pivotDashboardItem1" Weight="89.554531490015364" />
              <LayoutItem DashboardItem="pieDashboardItem1" Weight="110.44546850998464" />
            </LayoutGroup>
          </LayoutGroup>
        </LayoutGroup>
        <LayoutGroup Orientation="Vertical" Weight="100">
          <LayoutGroup Weight="134.37644196484752">
            <LayoutItem DashboardItem="chartDashboardItem1" Weight="156.95708712613785" />
          </LayoutGroup>
          <LayoutItem DashboardItem="chartDashboardItem2" Weight="132.71889400921663" />
          <LayoutItem DashboardItem="rangeFilterDashboardItem1" Weight="32.904664025935872" />
        </LayoutGroup>
      </LayoutGroup>
    </LayoutGroup>
  </LayoutTree>
</Dashboard>