LogoLogo
Sign inProduct portalStatus pageSubscribe to updates
  • 👋Hello
  • 🚀Getting Started
    • Getting started
    • First time log in
      • Standalone version
      • Microsoft 365 organisations
      • Google organisations
    • Set up your organisation
      • Add a building
      • Add a floor
      • Add users
      • Add teams
      • Add resources
      • Add neighbourhoods
      • Add devices / apps
    • Set up your hardware
      • Supported hardware
      • Firewall rules
      • Meeting room display
        • Mimo firmware upgrade
      • Applications
        • Recommended hardware
        • Pair an application
        • Booking panel application
        • Office map application
        • Visitor kiosk application
        • Check in application
        • People count application
      • Video conferencing
      • IoT sensors
      • Sensor deployment
    • Settings
      • Regional settings
      • Branding and appearance
      • User settings
      • Visitor settings
      • Support details
      • Auto book / release
      • Booking reminders
    • Policies
      • General policies
      • Desk booking policies
      • Room booking policies
      • Car parking policies
      • 'Other' resource policies
      • Neighbourhood policies
      • Booking requests
    • Maps
      • About our interactive maps
      • Assign resources to map
    • Security
      • FAQ
      • White paper
      • Firewall rules
      • Network architecture
    • Users
      • User roles
      • User sync
    • Teams
    • Neighbourhoods
      • Booking in a neighbourhood
    • Your preferences
  • 📖User Guides
    • User guides
    • Planning your work week
    • Your workspace
    • Resource scheduling
      • Book a desk
      • Book a meeting room
      • Book a parking space
      • Book an 'other' resource
      • Manage your bookings
      • Check in to a booking
      • Book on behalf of
      • Edit / cancel on behalf of
    • Visitor management
      • Visitor log
      • How to invite visitors
      • Check in / out of a building
      • Reports
    • Mobile application
      • Download the mobile app
      • Book a desk
      • Book a meeting room
      • Book a parking space
      • Book an 'other' resource
    • Zones
    • Troubleshooting
      • Password issues
      • Hard refresh my browser
      • How do I report bugs
  • 🤝Integrations
    • Integrations overview
    • Calendar
      • Microsoft 365
        • Microsoft 365 permissions
        • Limit access to mailboxes
        • OAuth authentication flow
        • Global admin requirements
        • Enterprise applications
        • Add resources
        • Room display preparation
        • User sync
      • Google Workspace
        • Google permissions
        • Setup
        • OAuth authentication flow
        • Add resources
        • User sync
    • Video conferencing
      • Cisco
        • Cisco Webex
        • Cisco Meraki
      • Jabra Panacast
    • IoT sensors
      • MQTT
      • Milesight
        • Milesight configuration
        • Milesight DS3604 setup
      • Pressac
        • Pressac configuration
      • Irisys
        • Irisys configuration
    • Okta
    • SCIM provisioning
    • Vecos lockers
    • Crestron x70 Series
  • 📈Data and Reporting
    • Data and reporting
    • Analytics
    • Analytics Pro ✨
      • Dashboard
        • Space Usage
        • Reservations Trend
        • User Reservations Trend
        • Energy Log
        • Occupancy Log
        • Air Quality
        • Co2 Log
        • Temperature Log
        • Ambient Noise
        • Sound Level
        • Humidity Log
      • Functions
        • Aggregate Functions
          • ArrayAgg
          • ArrayAggDistinct
          • Avg
          • AvgIf
          • Corr
          • Count
          • CountDistinct
          • CountDistinctIf
          • CountIf
          • GrandTotal
          • ListAgg
          • ListAggDistinct
          • Max
          • MaxIf
          • Median
          • Min
          • MinIf
          • PercentileCont
          • PercentileDisc
          • PercentOfTotal
          • StdDev
          • Subtotal
          • Sum
          • SumIf
          • SumProduct
          • Variance
          • VariancePop
        • Array Functions
          • Array
          • ArrayContains
          • ArrayDistinct
          • ArrayExcept
          • ArrayIntersection
          • ArrayJoin
          • ArrayLength
          • ArraySlice
          • Sequence
        • Date Functions
          • ConvertTimeZone
          • DateAdd
          • DateDiff
          • DateFormat
          • DateFromUnix
          • DateLookback
          • DatePart
          • DateParse
          • DateTrunc
          • Day
          • EndOfMonth
          • Hour
          • InDateRange
          • InPriorDateRange
          • LastDay
          • MakeDate
          • Minute
          • Month
          • MonthName
          • Now
          • Quarter
          • Second
          • Today
          • Weekday
          • WeekdayName
          • Year
        • Financial Functions
          • CAGR
          • Effect
          • FV
          • IPmt
          • Nominal
          • NPer
          • Pmt
          • PPmt
          • PV
          • XNPV
        • Geography Functions
          • Area
          • Centroid
          • Distance
          • Geography
          • Intersects
          • Json (geography)
          • Latitude
          • Longitude
          • MakeLine
          • MakePoint
          • Perimeter
          • Text (geography)
          • Within
        • Join Functions
          • Lookup
          • Rollup
        • Logical Functions
          • Between
          • Choose
          • Coalesce
          • If
          • In
          • IsNotNull
          • IsNull
          • Switch
          • Zn
        • Math Functions
          • Abs
          • Acos
          • Asin
          • Atan
          • Atan2
          • BinFixed
          • BinRange
          • BitAnd
          • BitOr
          • Ceiling
          • Cos
          • Cot
          • Degrees
          • DistanceGlobe
          • DistancePlane
          • Div
          • Exp
          • Floor
          • Greatest
          • Int
          • Least
          • Ln
          • Log
          • Mod
          • MRound
          • Pi
          • Power
          • Radians
          • Round
          • RoundDown
          • RoundUp
          • RowAvg
          • Sign
          • Sin
          • Sqrt
          • Tan
          • Trunc
        • Text Functions
          • Concat
          • Contains
          • EndsWith
          • Find
          • ILike
          • Left
          • Len
          • Like
          • LPad
          • Lower
          • LTrim
          • MD5
          • Mid
          • Proper
          • RegexpExtract
          • RegexpMatch
          • RegexpReplace
          • Repeat
          • Replace
          • Reverse
          • Right
          • RPad
          • RTrim
          • SplitPart
          • StartsWith
          • Substring
          • Trim
          • Upper
        • Type Functions
          • Date
          • Json
          • Logical
          • Number
          • Text
          • Variant
        • Window Functions
          • CumulativeAvg
          • CumulativeCorr
          • CumulativeCount
          • CumeDist
          • CumulativeMax
          • CumulativeMin
          • CumulativeStdDev
          • CumulativeSum
          • CumulativeVariance
          • FillDown
          • First
          • FirstNonNull
          • Lag
          • Last
          • LastNonNull
          • Lead
          • MovingAvg
          • MovingCorr
          • MovingCount
          • MovingMax
          • MovingMin
          • MovingStddev
          • MovingSum
          • MovingVariance
          • Nth
          • Ntile
          • Rank
          • RankDense
          • RankPercentile
          • RowNumber
        • Operators
    • Insights
    • Booking report
    • Contact tracing report
  • 📝Release Notes
    • Release notes overview
    • Web
      • 2025
        • v3.1.7 - 16th April 2025
        • v3.1.6 - 27th February 2025
        • v3.1.5 - 23rd January 2025
        • v3.1.4 - 20th January 2025
      • 2024
        • v3.1.3 - 23rd December 2024
        • v3.1.2 - 5th December 2024
        • v3.1.1 - 3rd December 2024
        • v3.1.0 - 24th October 2024
        • v3.0.9 - 10th October 2024
        • v3.0.8 - 14th August 2024
        • v3.0.7 - 15th July 2024
        • v3.0.6 - 27th June 2024
        • v3.0.5 - 18th April 2024
        • v3.0.4 - 11th April 2024
        • v3.0.3 - 18th March 2024
        • v3.0.2 - 19th February 2024
        • v3.0.1 - 4th January 2024
      • 2023
        • v3.0.0 - 21st November 2023
        • v2.10.9 - 12th October 2023
        • v2.10.8 - 6th September 2023
        • v2.10.7 - 10th August 2023
        • v2.10.6 - 25th July 2023
        • v2.10.5 - 17th May 2023
        • v2.10.4 - 4th May 2023
        • v2.10.3 - 12th April 2023
        • v2.10.2 - 3rd April 2023
        • v2.10.1 - 20th February 2023
      • 2022
        • v2.10.0 - 29th November 2022
        • v2.9.9 - 16th November 2022
        • v2.9.8 - 27th October 2022
        • v2.9.7 - 12th October 2022
        • v2.9.6 - 29th September 2022
        • v2.9.5 - 7th September 2022
        • v2.9.4 - 22nd August 2022
        • v2.9.3 - 6th July 2022
        • v2.9.2 - 29th June 2022
        • v2.9.1 - 14th June 2022
        • v2.9.0 - 5th May 2022
        • v2.8.9 - 18th April 2022
        • v2.8.8 - 5th April 2022
        • v2.8.7 - 18th March 2022
        • v2.8.6 - 9th February 2022
      • 2021
        • v2.8.5 - 23rd December 2021
        • v2.8.4 - 15th December 2021
        • v2.8.3 - 2nd December 2021
        • v2.8.0 - 18th November 2021
        • v2.7.0 - 25th October 2021
        • v2.5.0 - 22nd September 2021
        • v2.4.0 - 23rd August 2021
        • v2.3.0 - 4th August 2021
        • v2.2.0 - 26th July 2021
        • v.2.1.0 - 16th July 2021
        • v2.0.0 - 13th July 2021
        • V1.9.0 - 24th June 2021
        • V1.8.0 - 4th June 2021
        • V1.7.0 - 23rd May 2021
        • V1.6.0 - 13th May 2021
        • V1.5.0 - 16th April 2021
        • V1.4.0 - 6th April 2021
    • Mobile
      • Android
        • 2025
          • v1.20.0 - 9th January 2025
        • 2023
          • v1.18.0 - 4th May 2023
          • v1.17.9 - 6th April 2023
        • 2022
          • v1.14.5 - 18th April 2022
          • v1.12.0 - 12th January 2022
        • 2021
          • v1.11.0 - 18th November 2021
          • v1.10.2 - 25th October 2021
          • v1.9.0 - 6th October 2021
          • V1.8.6 - 20th August 2021
          • V1.6.6 - 5th July 2021
          • V1.6.0 - 25th June 2021
          • V1.1 - 6th May 2021
          • V1.0 - 4th January 2021
      • IOS
        • 2025
          • v3.8.9 - 15th January 2025
          • v3.8.8 - January 9th 2025
        • 2023
          • v3.5.0 - 4th May 2023
          • v3.4.7 - 6th April 2023
        • 2022
          • v3.4.0 - 12th January 2022
            • v3.4.3 - 18th April 2022
        • 2021
          • v3.3.3 - 18th November 2021
          • v3.3.1 - 25th October 2021
          • v3.3.0 - 6th October 2021
          • V3.2.4 - 20th August 2021
          • V1.6.6 - 5th July 2021
          • v1.6.5 - 25th June 2021
          • v1.6.1 - 6th May 2021
          • v1.5.1 - 4th January 2021
    • Android meeting display
      • 1.7.3 - 18th April 2024
      • 1.7.2 - 15th December 2023
      • 1.7.0 - 3rd August 2023
      • v1.5.4 - 27th April 2022
      • v1.5.3 - 18th April 2022
      • v1.4.16 - 18th March 2022
      • v1.4.3 - 2nd December 2021
  • ⬇️Downloads
    • Android meeting display
  • 🚀What's new
  • 📝Request a feature
  • 📱Android mobile app
  • 📱iOS mobile app
  • 📃Licence agreement
  • 📃Terms of use
  • 📃Privacy policy
  • 📃Warranty
Powered by GitBook
On this page
  • Syntax
  • Example

Was this helpful?

Export as PDF
  1. Data and Reporting
  2. Analytics Pro ✨
  3. Functions
  4. Aggregate Functions

CountDistinct

The CountDistinct function returns the number of unique values within a column or group.

Syntax

CountDistinct(column)

Function arguments:

  • column (required) The column of values to be counted. Duplicate and Null or empty values are not counted.

Example

CountDistinct([City])

  • Returns the number of unique city names.

PreviousCountNextCountDistinctIf

Last updated 1 month ago

Was this helpful?

📈