<DataSources> <SqlDataSource Name="SQL Data Source 1" ComponentName="dashboardSqlDataSource1"> <Connection Name="localhost_HQR_Connection" ProviderKey="MSSqlServer"> <Parameters> <Parameter Name="server" Value="localhost" /> <Parameter Name="database" Value="" /> <Parameter Name="useIntegratedSecurity" Value="True" /> <Parameter Name="read only" Value="1" /> <Parameter Name="generateConnectionHelper" Value="false" /> <Parameter Name="userid" Value="" /> <Parameter Name="password" Value="" /> </Parameters> </Connection> <Query Type="StoredProcQuery" Name="POSDashBoardKPIHour"> <Parameter Name="@FromDate" Type="System.DateTime">552877920000000000</Parameter> <Parameter Name="@ToDate" Type="System.DateTime">552877920000000000</Parameter> <Parameter Name="@UserId" Type="System.Guid">AAEAAAD/////AQAAAAAAAAAEAQAAAAtTeXN0ZW0uR3VpZAsAAAACX2ECX2ICX2MCX2QCX2UCX2YCX2cCX2gCX2kCX2oCX2sAAAAAAAAAAAAAAAgHBwICAgICAgICAAAAAAAAAAAAAAAAAAAAAAs=</Parameter> <Parameter Name="@Parity" Type="System.Boolean">True</Parameter> <Parameter Name="@PeriodType" Type="DevExpress.DataAccess.Expression">(System.String)(?PeriodType)</Parameter> <Parameter Name="@StoreId" Type="DevExpress.DataAccess.Expression">(System.Int32)(?StoreId)</Parameter> <ProcName>POSDashBoardKPIHour</ProcName> </Query> <ResultSchema> <DataSet Name="SQL Data Source 1"> <View Name="POSDashBoardKPIHour"> <Field Name="Period" Type="String" /> <Field Name="RangeInterval" Type="String" /> <Field Name="CountIn" Type="Int32" /> <Field Name="ReceiptCount" Type="Int32" /> <Field Name="TotalUnitSales" Type="Decimal" /> <Field Name="TotalQuantitySales" Type="Decimal" /> <Field Name="Amount" Type="Decimal" /> <Field Name="GiftCardSalesAmount" Type="Decimal" /> </View> </DataSet> </ResultSchema> <ConnectionOptions CloseConnection="true" /> <CalculatedFields> <CalculatedField Name="CV Calc" Expression="ToDecimal(SUM([ReceiptCount]))/ToDecimal(SUM([CountIn]))" DataType="Auto" DataMember="POSDashBoardKPIHour" /> <CalculatedField Name="Avg Receipt Calc" Expression="ToDecimal(SUM([Amount]))/ToDecimal(SUM([ReceiptCount]))" DataType="Auto" DataMember="POSDashBoardKPIHour" /> <CalculatedField Name="UPT Calc" Expression="ToDecimal(SUM([TotalUnitSales]))/ToDecimal(sum([ReceiptCount]))" DataType="Auto" DataMember="POSDashBoardKPIHour" /> <CalculatedField Name="Total Quantity" Expression="ToDecimal(SUM([TotalUnitSales]))" DataType="Auto" DataMember="POSDashBoardKPIHour" /> </CalculatedFields> </SqlDataSource> </DataSources> <Parameters> <Parameter Name="Parity" Type="System.Boolean" Value="true" AllowNull="true" Visible="false" /> <Parameter Name="ComparePeriod" Value="Last Year" Visible="false"> <StaticListLookUpSettings> <Values> <Value>Yesterday</Value> <Value>Last Week</Value> <Value>Last Year</Value> </Values> </StaticListLookUpSettings> </Parameter> <Parameter Name="FromDate" Type="System.DateTime" AllowNull="true" Description="From Date" Visible="false" /> <Parameter Name="ToDate" Type="System.DateTime" AllowNull="true" Description="To Date" Visible="false" /> <Parameter Name="PeriodType" Value="Today" Description="Period"> <StaticListLookUpSettings> <Values> <Value>Today</Value> <Value>Yesterday</Value> <Value>This Week</Value> <Value>Last Week</Value> <Value>This Month</Value> <Value>Last Month</Value> <Value>This Year</Value> </Values> </StaticListLookUpSettings> </Parameter> <Parameter Name="StoreId" Type="System.Int32" Value="1" AllowNull="false" Visible="false" /> </Parameters> <Items> <TabContainer ComponentName="tabContainerDashboardItem1" Name="Tab Container 1"> <Pages> <Page ComponentName="dashboardTabPage1" Name="Page 1" /> <Page ComponentName="dashboardTabPage2" Name="Page 2" /> </Pages> </TabContainer> <Chart ComponentName="chartDashboardItem1" Name="Conversion rate" ShowCaption="false" ParentContainer="dashboardTabPage1" DataSource="dashboardSqlDataSource1" DataMember="POSDashBoardKPIHour"> <DataItems> <Dimension DataMember="RangeInterval" DefaultId="DataItem1" /> <Measure DataMember="CV Calc" DefaultId="DataItem2" /> </DataItems> <Arguments> <Argument DefaultId="DataItem1" /> </Arguments> <Panes> <Pane Name="Pane 1"> <Series> <Simple> <Value DefaultId="DataItem2" /> </Simple> </Series> </Pane> </Panes> </Chart> <Pivot ComponentName="pivotDashboardItem2" Name="Business Driver" ParentContainer="dashboardTabPage2" DataSource="dashboardSqlDataSource1" DataMember="POSDashBoardKPIHour"> <DataItems> <Dimension DataMember="RangeInterval" DefaultId="DataItem0" /> <Measure DataMember="CountIn" Name="Visitors" DefaultId="DataItem1"> <NumericFormat FormatType="Number" Precision="0" Unit="Ones" IncludeGroupSeparator="true" /> </Measure> <Measure DataMember="ReceiptCount" Name="Transact." DefaultId="DataItem2" /> <Measure DataMember="Avg Receipt Calc" Name="Avg Receipt" DefaultId="DataItem3" /> <Measure DataMember="UPT Calc" Name="UPT" DefaultId="DataItem4"> <NumericFormat FormatType="Number" Unit="Ones" IncludeGroupSeparator="true" /> </Measure> <Measure DataMember="Amount" Name="Sale Amount" DefaultId="DataItem6"> <NumericFormat FormatType="Currency" IncludeGroupSeparator="true" /> </Measure> <Measure DataMember="GiftCardSalesAmount" Name="Gift Card" DefaultId="DataItem9"> <NumericFormat FormatType="Currency" IncludeGroupSeparator="true" /> </Measure> <Dimension DataMember="Period" DefaultId="DataItem7" /> <Measure DataMember="CV Calc" Name="CV" DefaultId="DataItem8"> <NumericFormat FormatType="Percent" IncludeGroupSeparator="true" /> </Measure> <Measure DataMember="Total Quantity" DefaultId="DataItem5"> <NumericFormat FormatType="Number" Unit="Ones" CustomFormatString="" /> </Measure> </DataItems> <FormatRules> <PivotItemFormatRule Name="FormatRule 1" ApplyToRow="true" DataItem="DataItem1" DataItemApplyTo="DataItem1"> <FormatConditionTopBottom RankType="Number" Rank="4"> <AppearanceSettings AppearanceType="FontBold" /> </FormatConditionTopBottom> <PivotItemFormatRuleLevel /> </PivotItemFormatRule> </FormatRules> <Rows> <Row DefaultId="DataItem7" /> <Row DefaultId="DataItem0" /> </Rows> <Values> <Value DefaultId="DataItem1" /> <Value DefaultId="DataItem2" /> <Value DefaultId="DataItem8" /> <Value DefaultId="DataItem3" /> <Value DefaultId="DataItem4" /> <Value DefaultId="DataItem6" /> <Value DefaultId="DataItem9" /> <Value DefaultId="DataItem5" /> </Values> <AutoExpandRowGroups>true</AutoExpandRowGroups> <ShowColumnGrandTotals>false</ShowColumnGrandTotals> <ShowRowGrandTotals>false</ShowRowGrandTotals> <ShowColumnTotals>false</ShowColumnTotals> <ColumnTotalsPosition>Near</ColumnTotalsPosition> </Pivot> </Items> <LayoutTree> <LayoutGroup Orientation="Vertical" Weight="100"> <LayoutTabContainer DashboardItem="tabContainerDashboardItem1" Weight="100"> <LayoutTabPage Orientation="Vertical" DashboardItem="dashboardTabPage2" Weight="100"> <LayoutItem DashboardItem="pivotDashboardItem2" Weight="100" /> </LayoutTabPage> <LayoutTabPage Orientation="Vertical" DashboardItem="dashboardTabPage1" Weight="100"> <LayoutItem DashboardItem="chartDashboardItem1" Weight="100" /> </LayoutTabPage> </LayoutTabContainer> </LayoutGroup> </LayoutTree> </Dashboard>