KPI: Growth in Customer Base

CollapseAll image

Collapse image KPI properties


 Property   Value 
 Associated measure group   Internet Sales 
 Description   The ratio between the customer count in the current period to that of the previous period. 
 Display folder   Customer Perspective\Expand Customer Base 
 Status indicator   Road Signs 
 Trend indicator   Standard Arrow 

Collapse image Value expression


[Measures].[Growth in Customer Base]

Collapse image Goal expression


Case
    When [Date].[Fiscal].CurrentMember.Level Is [Date].[Fiscal].[Fiscal Year]
    Then .30
    When [Date].[Fiscal].CurrentMember.Level Is [Date].[Fiscal].[Fiscal Semester]
    Then .15
    When [Date].[Fiscal].CurrentMember.Level Is [Date].[Fiscal].[Fiscal Quarter]
    Then .075
    When [Date].[Fiscal].CurrentMember.Level Is [Date].[Fiscal].[Month]
    Then .025
    Else "NA"
End

Collapse image Status expression


Case
    When KpiValue( "Growth in Customer Base" ) >= 
         KpiGoal ( "Growth in Customer Base" ) 
    Then 1
    When KpiValue( "Growth in Customer Base" ) >= 
         KpiGoal ( "Growth in Customer Base" ) * .90
         And
         KpiValue( "Growth in Customer Base" ) < 
         KpiGoal ( "Growth in Customer Base" )         
    Then 0
    Else -1
End

Collapse image Trend expression


Case
    When IsEmpty
         (
           ParallelPeriod
           (
             [Date].[Fiscal].[Fiscal Year],
             1,
             [Date].[Fiscal].CurrentMember
           )
         )
    Then 0  
    When VBA!Abs
         (
          ( 
            KpiValue( "Growth in Customer Base" ) 
            - 
            (
              KpiValue( "Growth in Customer Base" ),
              ParallelPeriod
              ( 
                [Date].[Fiscal].[Fiscal Year],
                1,
                [Date].[Fiscal].CurrentMember
              )
            )
          ) 
          /
          (
            KpiValue( "Growth in Customer Base" ),
            ParallelPeriod
            ( 
              [Date].[Fiscal].[Fiscal Year],
              1,
              [Date].[Fiscal].CurrentMember
            )
          )  
         ) <=.02
    Then 0
    When ( 
           KpiValue( "Growth in Customer Base" ) 
           - 
           (
             KpiValue( "Growth in Customer Base" ),
             ParallelPeriod
             ( 
               [Date].[Fiscal].[Fiscal Year],
               1,
               [Date].[Fiscal].CurrentMember
             )
           ) 
         )
         /
         (
           KpiValue( "Growth in Customer Base" ),
           ParallelPeriod
           ( 
             [Date].[Fiscal].[Fiscal Year],
             1,
             [Date].[Fiscal].CurrentMember
           )
         ) >.02
    Then 1
    Else -1
End

Collapse image See also


About this documentation