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. Window Functions

MovingMin

PreviousMovingMaxNextMovingStddev

Last updated 1 month ago

Was this helpful?

The MovingMin function finds the minimum value of a column within a moving window.

Syntax

MovingMin(column, above, [below])

Function Arguments:

  • column (required) - The column to be searched.

  • above (required) - The first row to include, counting backward from the current row.

  • below (optional) - The last row to include, counting forward from the current row. Defaults to 0 (current row will be the last row included).

πŸ“˜When using this function without a sort enforced, there can be unexpected results. In order to ensure that the values are stable, verify that there is a sorted column within the table.

Example

A table lists the weekly sales for the past year. The table is sorted ascending by the week. The MovingMin function can be utilized in order to find the minimum value within specific windows.

MovingMin([Weekly Sales], 4)

With [Weekly Sales] as the column argument and 4 as the above argument, the minimum weekly sales value is calculated for each week along with the four previous weeks. Because the below argument is not specified, it defaults to 0.

MovingMin([Weekly Sales], 0, 4)

Here, the above argument is 0, so there isn't any previous weeks included in the minimum calculation. The below average is 4, the minimum weekly sales value is computed for each week along with the next 4 weeks.

MovingMin([Weekly Sales], 2, 2)

Here, the above argument is 2, so the previous two weeks is included in the minimum calculation. In addition, the below argument is 2, so the following two weeks is also included.

MovingMin([Weekly Sales], 8, -4)

Here is an example where the below parameter is negative. The below parameter can be negative as long as the value is less than that of the above parameter. In this example, each window begins 8 weeks before the current week and ends 4 weeks before the current week, inclusive.

πŸ“ˆ