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
  • Notes
  • Example

Was this helpful?

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

RankDense

PreviousRankNextRankPercentile

Last updated 1 month ago

Was this helpful?

The RankDense function assigns ranks to values in a specified column.

Like Rank function output, the sequence begins with rank 1 and assigns the same rank to duplicate values. Unlike Rank function output, however, RankDense returns a continuous sequence that doesn't skip numbers after multiple values in the referenced column are assigned the same rank. As a result, there are no gaps in the ranking value sequence.

Syntax

RankDense([column], [direction])

Function arguments:

column

[optional] The column referenced to determine rank.

direction

[optional] The directional order in which the referenced column's values are ranked.

  • Can be "asc" or "desc":

    • "asc" ranks values in ascending order with the smallest value ranked 1.

    • "desc" ranks values in descending order with the largest value assigned rank 1.

  • If unspecified, values rank in ascending order by default.

Notes

  • If neither argument is specified, the function assigns ascending ranks based on row order.

  • Ranking is based on alphabetical, alphanumeric, numerical, or chronological order, depending on the referenced column's data type.

  • After multiple values are assigned the same rank, the ranking continues with the next chronological number, leaving no gaps in the ranking value sequence.

Example

A table lists the female name trends in Hawaii for the year 2018. You can use the RankDense function to rank names based on their popularity, which is reflected by their values in the Name Count column.

RankDense([Name Count], β€œdesc”)

With [Name Count] as the column argument and "desc" as the direction argument, the name with the largest value in the Name Count column is assigned rank 1, the name with the next largest value is assigned rank 2, and so on.

Note that the RankDense column assigns rank 4 to the names Mila and Olivia because they have the same Name Count value (50). The name Mia follows as the sixth value in the descending order of values, but it's assigned rank 5 to preserve the continuous sequence.

πŸ“ˆ