Dashboard Information
Dashboard Name:
Advantech
Dashboard ID:
da09ded8-79e6-44b6-b4a1-cb4bcf8cd0f4
Source:
XAF Application Database
Type:
DevExpress Dashboard (v17.1)
Dashboard Structure
Dashboard Items:
  • Charts
  • Pivot Tables
Data Sources:

Connected

<Dashboard>
  <Title Visible="false" Text="Advantech" />
  <DataSources>
    <SqlDataSource ComponentName="DataSource1">
      <Name>sensorreading</Name>
      <Connection Name="EasyTestConnectionString" FromAppConfig="true" />
      <Query Type="SelectQuery" Name="sensorreading">
        <Tables>
          <Table Name="sensorreading" />
        </Tables>
        <Columns>
          <AllColumns Table="sensorreading" />
        </Columns>
      </Query>
      <ConnectionOptions CloseConnection="true" />
    </SqlDataSource>
  </DataSources>
  <Items>
    <Pivot ComponentName="pivotDashboardItem1" Name="Pivot 1" ShowCaption="false" DataSource="DataSource1" DataMember="sensorreading">
      <DataItems>
        <Measure DataMember="TemperatureC" ShowTotals="false" ShowGrandTotals="false" SummaryType="Max" DefaultId="DataItem0" />
        <Dimension DataMember="CreatedUtc" DateTimeGroupInterval="DateHourMinute" DefaultId="DataItem1" />
        <Dimension DataMember="BatteryV" DefaultId="DataItem3" />
        <Measure DataMember="BatteryV" ShowTotals="false" ShowGrandTotals="false" SummaryType="Max" DefaultId="DataItem4" />
        <Dimension DataMember="ReadingTimeUtc" DefaultId="DataItem2" />
        <Dimension DataMember="ReadingTimeUtc" DateTimeGroupInterval="DayMonthYear" DefaultId="DataItem5" />
        <Dimension DataMember="ReadingTimeUtc" DateTimeGroupInterval="Hour" DefaultId="DataItem6" />
      </DataItems>
      <Rows>
        <Row DefaultId="DataItem5" />
        <Row DefaultId="DataItem6" />
      </Rows>
      <Values>
        <Value DefaultId="DataItem0" />
        <Value DefaultId="DataItem4" />
      </Values>
      <ShowColumnGrandTotals>false</ShowColumnGrandTotals>
      <ShowRowGrandTotals>false</ShowRowGrandTotals>
      <ShowColumnTotals>false</ShowColumnTotals>
      <ShowRowTotals>false</ShowRowTotals>
    </Pivot>
    <Chart ComponentName="chartDashboardItem1" Name="Temperature" DataSource="DataSource1" DataMember="sensorreading">
      <DataItems>
        <Dimension DataMember="ReadingTimeUtc" DateTimeGroupInterval="DayMonthYear" DefaultId="DataItem1" />
        <Dimension DataMember="ReadingTimeUtc" DateTimeGroupInterval="Hour" DefaultId="DataItem4" />
        <Measure DataMember="TemperatureC" SummaryType="CountDistinct" Expression="Max([TemperatureC])" DefaultId="DataItem0">
          <WindowDefinition>
            <ChartWindowDefinition />
          </WindowDefinition>
        </Measure>
      </DataItems>
      <Arguments>
        <Argument DefaultId="DataItem1" />
        <Argument DefaultId="DataItem4" />
      </Arguments>
      <Panes>
        <Pane Name="Pane 1">
          <AxisY Title="Deg C" />
          <Series>
            <Simple Name="Temperature" SeriesType="Line">
              <Value DefaultId="DataItem0" />
            </Simple>
          </Series>
        </Pane>
      </Panes>
    </Chart>
    <Chart ComponentName="chartDashboardItem2" Name="Battery" DataSource="DataSource1" DataMember="sensorreading">
      <DataItems>
        <Measure DataMember="BatteryV" SummaryType="CountDistinct" Expression="Max([BatteryV])" DefaultId="DataItem0">
          <WindowDefinition>
            <ChartWindowDefinition />
          </WindowDefinition>
        </Measure>
        <Dimension DataMember="ReadingTimeUtc" DateTimeGroupInterval="DayMonthYear" DefaultId="DataItem1" />
        <Dimension DataMember="ReadingTimeUtc" DateTimeGroupInterval="Hour" DefaultId="DataItem2" />
      </DataItems>
      <Arguments>
        <Argument DefaultId="DataItem1" />
        <Argument DefaultId="DataItem2" />
      </Arguments>
      <Panes>
        <Pane Name="Pane 1">
          <AxisY Title="Volts" />
          <Series>
            <Simple SeriesType="Line">
              <Value DefaultId="DataItem0" />
            </Simple>
          </Series>
        </Pane>
      </Panes>
    </Chart>
    <RangeFilter ComponentName="rangeFilterDashboardItem1" Name="Range Filter 1" DataSource="DataSource1" DataMember="sensorreading">
      <DataItems>
        <Measure DataMember="TemperatureC" SummaryType="CountDistinct" Expression="Max([TemperatureC])" DefaultId="DataItem0">
          <WindowDefinition>
            <RangeFilterWindowDefinition />
          </WindowDefinition>
        </Measure>
        <Dimension DataMember="ReadingTimeUtc" DateTimeGroupInterval="DateHour" DefaultId="DataItem1" />
      </DataItems>
      <Argument DefaultId="DataItem1" />
      <Series>
        <Simple SeriesType="Line">
          <Value DefaultId="DataItem0" />
        </Simple>
      </Series>
    </RangeFilter>
    <Chart ComponentName="chartDashboardItem3" Name="X-Axis" ShowCaption="false" DataSource="DataSource1" DataMember="sensorreading">
      <DataItems>
        <Measure DataMember="X_Velocity" SummaryType="CountDistinct" Expression="Max([X_Velocity])" DefaultId="DataItem0">
          <WindowDefinition>
            <ChartWindowDefinition />
          </WindowDefinition>
        </Measure>
        <Dimension DataMember="ReadingTimeUtc" DateTimeGroupInterval="DayMonthYear" DefaultId="DataItem1" />
        <Dimension DataMember="ReadingTimeUtc" DateTimeGroupInterval="Hour" DefaultId="DataItem2" />
        <Dimension DataMember="ReadingTimeUtc" DateTimeGroupInterval="Minute" DefaultId="DataItem3" />
      </DataItems>
      <Arguments>
        <Argument DefaultId="DataItem1" />
        <Argument DefaultId="DataItem2" />
        <Argument DefaultId="DataItem3" />
      </Arguments>
      <Panes>
        <Pane Name="Pane 1">
          <AxisY Title="Velocity X" />
          <Series>
            <Simple Name="Velocity X">
              <Value DefaultId="DataItem0" />
            </Simple>
          </Series>
        </Pane>
      </Panes>
    </Chart>
    <Chart ComponentName="chartDashboardItem4" Name="Y-Axia" ShowCaption="false" DataSource="DataSource1" DataMember="sensorreading">
      <DataItems>
        <Measure DataMember="Y_Velocity" SummaryType="CountDistinct" Expression="Max([Y_Velocity])" DefaultId="DataItem0">
          <WindowDefinition>
            <ChartWindowDefinition />
          </WindowDefinition>
        </Measure>
        <Dimension DataMember="ReadingTimeUtc" DateTimeGroupInterval="DayMonthYear" DefaultId="DataItem1" />
        <Dimension DataMember="ReadingTimeUtc" DateTimeGroupInterval="Hour" DefaultId="DataItem2" />
        <Dimension DataMember="ReadingTimeUtc" DateTimeGroupInterval="Minute" DefaultId="DataItem3" />
      </DataItems>
      <Arguments>
        <Argument DefaultId="DataItem1" />
        <Argument DefaultId="DataItem2" />
        <Argument DefaultId="DataItem3" />
      </Arguments>
      <Panes>
        <Pane Name="Pane 1">
          <AxisY Title="Velocity Y" />
          <Series>
            <Simple Name="Velocity Y">
              <Value DefaultId="DataItem0" />
            </Simple>
          </Series>
        </Pane>
      </Panes>
    </Chart>
    <Chart ComponentName="chartDashboardItem5" Name="Chart 2" ShowCaption="false" DataSource="DataSource1" DataMember="sensorreading">
      <DataItems>
        <Measure DataMember="Z_Velocity" SummaryType="CountDistinct" Expression="Max([Z_Velocity])" DefaultId="DataItem0">
          <WindowDefinition>
            <ChartWindowDefinition />
          </WindowDefinition>
        </Measure>
        <Dimension DataMember="ReadingTimeUtc" DateTimeGroupInterval="DayMonthYear" DefaultId="DataItem1" />
        <Dimension DataMember="ReadingTimeUtc" DateTimeGroupInterval="Hour" DefaultId="DataItem2" />
        <Dimension DataMember="ReadingTimeUtc" DateTimeGroupInterval="Minute" DefaultId="DataItem3" />
      </DataItems>
      <Arguments>
        <Argument DefaultId="DataItem1" />
        <Argument DefaultId="DataItem2" />
        <Argument DefaultId="DataItem3" />
      </Arguments>
      <Panes>
        <Pane Name="Pane 1">
          <AxisY Title="Velocity Z" />
          <Series>
            <Simple Name="Velocity Z">
              <Value DefaultId="DataItem0" />
            </Simple>
          </Series>
        </Pane>
      </Panes>
    </Chart>
  </Items>
  <LayoutTree>
    <LayoutGroup Orientation="Vertical" Weight="100">
      <LayoutGroup Orientation="Vertical" Weight="100">
        <LayoutGroup Weight="100">
          <LayoutGroup Orientation="Vertical" Weight="140.62326099053979">
            <LayoutItem DashboardItem="chartDashboardItem3" Weight="114.66347519169129" />
            <LayoutItem DashboardItem="chartDashboardItem4" Weight="107.58775509109682" />
            <LayoutItem DashboardItem="chartDashboardItem5" Weight="99.26266480423358" />
            <LayoutItem DashboardItem="rangeFilterDashboardItem1" Weight="31.097569881131108" />
          </LayoutGroup>
          <LayoutGroup Orientation="Vertical" Weight="59.376739009460209">
            <LayoutItem DashboardItem="chartDashboardItem1" Weight="67.596379551936579" />
            <LayoutItem DashboardItem="chartDashboardItem2" Weight="65.591039226926782" />
            <LayoutItem DashboardItem="pivotDashboardItem1" Weight="193.37149576023049" />
          </LayoutGroup>
        </LayoutGroup>
      </LayoutGroup>
    </LayoutGroup>
  </LayoutTree>
</Dashboard>