• Actual Values
  • Count
  • Distinct Count
  • Treat as Geo
  • Geo Location
  • Actual Values
  • Actual Values
  • Seasonal/Cyclic
  • Year
    E.g., 2003, 2004
  • Quarter
    E.g.,Q1, Q2.
  • Quarter & Year
    E.g., Q1 2004.
  • Month
    E.g.,January, February
  • Month & Year
    E.g., March 2004.
  • Week
    E.g.,Week 1, Week 2.
  • Week & Year
    E.g., W1 2004.
  • Week Day
    E.g., Sunday, Monday
  • Full Date
    E.g., 1/1/2000
  • Day of Month
    E.g., 1 to 31
  • Date & Time
    E.g., 01 Jan, 2000 00:00:07 hrs
  • Hour of Day
    E.g., 0 to 23 hrs
  •  
  • Count
  • Distinct Count
  • Actual Values
  • Seasonal
  • Relative
    E.g., Last Week..
  • Count
  • Distinct Count
  • Maximum Date
  • Minimum Date
  • Count
  • Distinct Count
  • Maximum Date
  • Minimum Date
  • Actual Values
  • Running Total
  • Difference From
  • % of Difference From
  • % of Previous Value
  • 100% Group
  • Moving Calculation
  • Actual Values
  • Running Total
  • % of Row
  • % of Row in Group
  • % of Column
  • % of Column in Group
  • % of Total
  • Difference From
  • % of Difference From
  • % of Previous Value
  • Lookup Value
  • Summary
  • Actual Values
  • Sum
  • Maximum [Max]
  • Minimum [Min]
  • Average [Avg]
  • Std Dev [Std]
  • Std Dev [Std]
  • Median
  • Mode
  • Percentile
  • Variance
  • Count
  • Distinct Count
  • Actual Values
  • Measure [Actual(M)]
    Treat as Number
  • Actual Values
  • Dimension [Actual(D)]
    Treat as Text
  • Range [Actual(R)]
    Group Values
  • Treat as Geo
  • Geo Location
  • Edit Formula
  • Geo Location
  • Treat as Text
  • Actual Values
  • Count
  • Distinct Count
  • Geo Location
  • Actual Values
  • Measure [Actual(M)]
    Treat as Number
  • Dimension [Actual(D)]
    Treat as Text
  • Geo Location
Show Data As
  • Normal
  • Running Total
  • % of Row
  • % of Row in Group
  • % of Column
  • % of Column in Group
  • % of Total
  • Difference From
  • % of Difference From
  • % of Previous Value
  • Lookup Value
Show Data As
  • Normal
  • Running Total
  • % of Total
  • Difference From
  • % of Difference From
  • % of Previous Value
  • 100% Group
  • Moving Calculation
Show Data As
  • Normal
  • Running Total
  • % of Total
  • Difference From
  • % of Difference From
  • % of Previous Value
  • 100% Group
  • Moving Calculation
  • Year
  • Quarter
  • Quarter & Year
  • Month
  • Month & Year
  • Week
  • Week & Year
  • Week Day
  • Full Date
  • Day of Month
  • Date & Time
  • Hour of Day
  • Normal
  • Maximum Date
  • Minimum Date
  • Default Range
  • + Add New Range
       
        
  • Continent
  • Country
  • State/Province
  • County/District
  • City
  • Zip Code
  • Airport
  • Custom Geo Location
  • Latitude
  • Longitude
  • Continent
  • Country
  • State/Province
  • County/District
  • City
  • Zip Code
  • Airport
  • Custom Geo Location









Column Name:
Percentile Value:
Function Selected:
Calculation:
Compare With:
Select Base Field to Apply: