# Data and Reporting

- [Data and reporting](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/data-and-reporting.md)
- [Analytics](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics.md): UMA's dashboard interface provides rich analytics on utilisation, with both historical and real-time data.
- [Analytics Pro ✨](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro.md)
- [Dashboard](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/dashboard.md): Analytics Pro has multiple pages providing data insights. The first three pages focus on reservations, while the rest cover sensor data.
- [Space Usage](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/dashboard/space-usage.md): This page provides insights into reservation levels and how the space is being utilised.
- [Reservations Trend](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/dashboard/reservations-trend.md): This page shows the trend of reservations for the selected time frame.
- [Users Reservations Trend](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/dashboard/users-reservations-trend.md): This page provides user-level insights into reservation data.
- [Buildings Level Insight](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/dashboard/buildings-level-insight.md)
- [Comparison Analysis](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/dashboard/comparison-analysis.md)
- [Energy Log](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/dashboard/energy-log.md): This page provides insights into the data from the Energy sensor, measured in kWh. The charts are based on data representing the average energy consumption per hour for each resource.
- [Occupancy Log](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/dashboard/occupancy-log.md): This page provides insights into the data only for People Count Sensors. The charts use the average occupancy per day per resource.
- [Air Quality](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/dashboard/air-quality.md): This page provides insights into the data from the Air Quality Sensor, measured in mg/m3 unit. The charts are based on data representing the average air quality per day for each resource.
- [Co2 Log](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/dashboard/co2-log.md): This page provides insights into the data from the CO₂ sensor, measured in ppm unit. The charts are based on data representing the average Co2 level per day for each resource.
- [Temperature Log](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/dashboard/temperature-log.md): This page provides insights into the data from the Temperature sensor, measured in celsius. The charts are based on data representing the average temperature level per day for each resource.
- [Ambient Noise](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/dashboard/ambient-noise.md): This page provides insights into the data from the Ambient Noise sensor, measured in dBa unit. The charts are based on data representing the average ambient noise level per day for each resource.
- [Sound Level](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/dashboard/sound-level.md): This page provides insights into the data from the sound sensor, measured in dBa unit. The charts are based on data representing the average sound level per day for each resource.
- [Humidity Log](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/dashboard/humidity-log.md): This page provides insights into the data from the Humidity sensor, measured in percentage. The charts are based on data representing the average humidity level per day for each resource.
- [Functions](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions.md)
- [Aggregate Functions](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/aggregate-functions.md)
- [ArrayAgg](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/aggregate-functions/arrayagg.md)
- [ArrayAggDistinct](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/aggregate-functions/arrayaggdistinct.md)
- [Avg](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/aggregate-functions/avg.md)
- [AvgIf](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/aggregate-functions/avgif.md)
- [Corr](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/aggregate-functions/corr.md)
- [Count](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/aggregate-functions/count.md)
- [CountDistinct](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/aggregate-functions/countdistinct.md)
- [CountDistinctIf](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/aggregate-functions/countdistinctif.md)
- [CountIf](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/aggregate-functions/countif.md)
- [GrandTotal](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/aggregate-functions/grandtotal.md)
- [ListAgg](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/aggregate-functions/listagg.md)
- [ListAggDistinct](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/aggregate-functions/listaggdistinct.md)
- [Max](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/aggregate-functions/max.md)
- [MaxIf](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/aggregate-functions/maxif.md)
- [Median](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/aggregate-functions/median.md)
- [Min](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/aggregate-functions/min.md)
- [MinIf](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/aggregate-functions/minif.md)
- [PercentileCont](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/aggregate-functions/percentilecont.md)
- [PercentileDisc](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/aggregate-functions/percentiledisc.md)
- [PercentOfTotal](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/aggregate-functions/percentoftotal.md)
- [StdDev](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/aggregate-functions/stddev.md)
- [Subtotal](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/aggregate-functions/subtotal.md)
- [Sum](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/aggregate-functions/sum.md)
- [SumIf](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/aggregate-functions/sumif.md)
- [SumProduct](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/aggregate-functions/sumproduct.md)
- [Variance](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/aggregate-functions/variance.md)
- [VariancePop](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/aggregate-functions/variancepop.md)
- [Array Functions](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/array-functions.md)
- [Array](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/array-functions/array.md)
- [ArrayContains](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/array-functions/arraycontains.md)
- [ArrayDistinct](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/array-functions/arraydistinct.md)
- [ArrayExcept](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/array-functions/arrayexcept.md)
- [ArrayIntersection](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/array-functions/arrayintersection.md)
- [ArrayJoin](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/array-functions/arrayjoin.md)
- [ArrayLength](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/array-functions/arraylength.md)
- [ArraySlice](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/array-functions/arrayslice.md)
- [Sequence](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/array-functions/sequence.md)
- [Date Functions](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/date-functions.md)
- [ConvertTimeZone](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/date-functions/converttimezone.md)
- [DateAdd](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/date-functions/dateadd.md)
- [DateDiff](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/date-functions/datediff.md)
- [DateFormat](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/date-functions/dateformat.md)
- [DateFromUnix](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/date-functions/datefromunix.md)
- [DateLookback](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/date-functions/datelookback.md)
- [DatePart](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/date-functions/datepart.md)
- [DateParse](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/date-functions/dateparse.md)
- [DateTrunc](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/date-functions/datetrunc.md)
- [Day](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/date-functions/day.md)
- [EndOfMonth](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/date-functions/endofmonth.md)
- [Hour](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/date-functions/hour.md)
- [InDateRange](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/date-functions/indaterange.md)
- [InPriorDateRange](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/date-functions/inpriordaterange.md)
- [LastDay](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/date-functions/lastday.md)
- [MakeDate](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/date-functions/makedate.md)
- [Minute](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/date-functions/minute.md)
- [Month](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/date-functions/month.md)
- [MonthName](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/date-functions/monthname.md)
- [Now](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/date-functions/now.md)
- [Quarter](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/date-functions/quarter.md)
- [Second](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/date-functions/second.md)
- [Today](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/date-functions/today.md)
- [Weekday](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/date-functions/weekday.md)
- [WeekdayName](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/date-functions/weekdayname.md)
- [Year](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/date-functions/year.md)
- [Financial Functions](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/financial-functions.md)
- [CAGR](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/financial-functions/cagr.md)
- [Effect](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/financial-functions/effect.md)
- [FV](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/financial-functions/fv.md)
- [IPmt](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/financial-functions/ipmt.md)
- [Nominal](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/financial-functions/nominal.md)
- [NPer](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/financial-functions/nper.md)
- [Pmt](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/financial-functions/pmt.md)
- [PPmt](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/financial-functions/ppmt.md)
- [PV](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/financial-functions/pv.md)
- [XNPV](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/financial-functions/xnpv.md)
- [Geography Functions](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/geography-functions.md)
- [Area](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/geography-functions/area.md)
- [Centroid](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/geography-functions/centroid.md)
- [Distance](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/geography-functions/distance.md)
- [Geography](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/geography-functions/geography.md)
- [Intersects](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/geography-functions/intersects.md)
- [Json (geography)](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/geography-functions/json-geography.md)
- [Latitude](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/geography-functions/latitude.md)
- [Longitude](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/geography-functions/longitude.md)
- [MakeLine](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/geography-functions/makeline.md)
- [MakePoint](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/geography-functions/makepoint.md)
- [Perimeter](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/geography-functions/perimeter.md)
- [Text (geography)](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/geography-functions/text-geography.md)
- [Within](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/geography-functions/within.md)
- [Join Functions](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/join-functions.md)
- [Lookup](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/join-functions/lookup.md)
- [Rollup](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/join-functions/rollup.md)
- [Logical Functions](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/logical-functions.md)
- [Between](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/logical-functions/between.md)
- [Choose](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/logical-functions/choose.md)
- [Coalesce](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/logical-functions/coalesce.md)
- [If](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/logical-functions/if.md)
- [In](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/logical-functions/in.md)
- [IsNotNull](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/logical-functions/isnotnull.md)
- [IsNull](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/logical-functions/isnull.md)
- [Switch](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/logical-functions/switch.md)
- [Zn](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/logical-functions/zn.md)
- [Math Functions](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/math-functions.md)
- [Abs](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/math-functions/abs.md)
- [Acos](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/math-functions/acos.md)
- [Asin](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/math-functions/asin.md)
- [Atan](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/math-functions/atan.md)
- [Atan2](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/math-functions/atan2.md)
- [BinFixed](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/math-functions/binfixed.md)
- [BinRange](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/math-functions/binrange.md)
- [BitAnd](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/math-functions/bitand.md)
- [BitOr](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/math-functions/bitor.md)
- [Ceiling](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/math-functions/ceiling.md)
- [Cos](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/math-functions/cos.md)
- [Cot](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/math-functions/cot.md)
- [Degrees](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/math-functions/degrees.md)
- [DistanceGlobe](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/math-functions/distanceglobe.md)
- [DistancePlane](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/math-functions/distanceplane.md)
- [Div](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/math-functions/div.md)
- [Exp](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/math-functions/exp.md)
- [Floor](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/math-functions/floor.md)
- [Greatest](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/math-functions/greatest.md)
- [Int](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/math-functions/int.md)
- [Least](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/math-functions/least.md)
- [Ln](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/math-functions/ln.md)
- [Log](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/math-functions/log.md)
- [Mod](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/math-functions/mod.md)
- [MRound](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/math-functions/mround.md)
- [Pi](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/math-functions/pi.md)
- [Power](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/math-functions/power.md)
- [Radians](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/math-functions/radians.md)
- [Round](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/math-functions/round.md)
- [RoundDown](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/math-functions/rounddown.md)
- [RoundUp](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/math-functions/roundup.md)
- [RowAvg](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/math-functions/rowavg.md)
- [Sign](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/math-functions/sign.md)
- [Sin](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/math-functions/sin.md)
- [Sqrt](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/math-functions/sqrt.md)
- [Tan](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/math-functions/tan.md)
- [Trunc](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/math-functions/trunc.md)
- [Text Functions](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/text-functions.md)
- [Concat](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/text-functions/concat.md)
- [Contains](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/text-functions/contains.md)
- [EndsWith](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/text-functions/endswith.md)
- [Find](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/text-functions/find.md)
- [ILike](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/text-functions/ilike.md)
- [Left](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/text-functions/left.md)
- [Len](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/text-functions/len.md)
- [Like](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/text-functions/like.md)
- [LPad](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/text-functions/lpad.md)
- [Lower](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/text-functions/lower.md)
- [LTrim](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/text-functions/ltrim.md)
- [MD5](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/text-functions/md5.md)
- [Mid](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/text-functions/mid.md)
- [Proper](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/text-functions/proper.md)
- [RegexpExtract](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/text-functions/regexpextract.md)
- [RegexpMatch](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/text-functions/regexpmatch.md)
- [RegexpReplace](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/text-functions/regexpreplace.md)
- [Repeat](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/text-functions/repeat.md)
- [Replace](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/text-functions/replace.md)
- [Reverse](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/text-functions/reverse.md)
- [Right](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/text-functions/right.md)
- [RPad](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/text-functions/rpad.md)
- [RTrim](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/text-functions/rtrim.md)
- [SplitPart](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/text-functions/splitpart.md)
- [StartsWith](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/text-functions/startswith.md)
- [Substring](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/text-functions/substring.md)
- [Trim](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/text-functions/trim.md)
- [Upper](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/text-functions/upper.md)
- [Type Functions](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/type-functions.md)
- [Date](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/type-functions/date.md)
- [Json](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/type-functions/json.md)
- [Logical](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/type-functions/logical.md)
- [Number](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/type-functions/number.md)
- [Text](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/type-functions/text.md)
- [Variant](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/type-functions/variant.md)
- [Window Functions](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/window-functions.md)
- [CumulativeAvg](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/window-functions/cumulativeavg.md)
- [CumulativeCorr](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/window-functions/cumulativecorr.md)
- [CumulativeCount](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/window-functions/cumulativecount.md)
- [CumeDist](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/window-functions/cumedist.md)
- [CumulativeMax](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/window-functions/cumulativemax.md)
- [CumulativeMin](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/window-functions/cumulativemin.md)
- [CumulativeStdDev](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/window-functions/cumulativestddev.md)
- [CumulativeSum](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/window-functions/cumulativesum.md)
- [CumulativeVariance](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/window-functions/cumulativevariance.md)
- [FillDown](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/window-functions/filldown.md)
- [First](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/window-functions/first.md)
- [FirstNonNull](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/window-functions/firstnonnull.md)
- [Lag](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/window-functions/lag.md)
- [Last](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/window-functions/last.md)
- [LastNonNull](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/window-functions/lastnonnull.md)
- [Lead](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/window-functions/lead.md)
- [MovingAvg](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/window-functions/movingavg.md)
- [MovingCorr](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/window-functions/movingcorr.md)
- [MovingCount](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/window-functions/movingcount.md)
- [MovingMax](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/window-functions/movingmax.md)
- [MovingMin](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/window-functions/movingmin.md)
- [MovingStddev](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/window-functions/movingstddev.md)
- [MovingSum](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/window-functions/movingsum.md)
- [MovingVariance](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/window-functions/movingvariance.md)
- [Nth](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/window-functions/nth.md)
- [Ntile](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/window-functions/ntile.md)
- [Rank](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/window-functions/rank.md)
- [RankDense](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/window-functions/rankdense.md)
- [RankPercentile](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/window-functions/rankpercentile.md)
- [RowNumber](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/window-functions/rownumber.md)
- [Operators](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/operators.md)
- [Export](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/export.md)
- [Export workbook data](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/export/export-workbook-data.md)
- [Schedule export](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/export/schedule-export.md)
- [Manage schedule exports](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/export/manage-schedule-exports.md)
- [Download and export limitations](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/export/download-and-export-limitations.md)
- [Charts](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/charts.md)
- [Build a Chart](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/charts/build-a-chart.md)
- [Bar Chart](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/charts/build-a-chart/bar-chart.md)
- [Line Chart](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/charts/build-a-chart/line-chart.md)
- [KPI Chart](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/charts/build-a-chart/kpi-chart.md)
- [Scatter Plot](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/charts/build-a-chart/scatter-plot.md)
- [Sankey Diagram](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/charts/build-a-chart/sankey-diagram.md)
- [Funnel Chart](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/charts/build-a-chart/funnel-chart.md)
- [Gauge Chart](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/charts/build-a-chart/gauge-chart.md)
- [Waterfall Chart](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/charts/build-a-chart/waterfall-chart.md)
- [Area Chart](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/charts/build-a-chart/area-chart.md)
- [Combo Chart](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/charts/build-a-chart/combo-chart.md)
- [Box and Whisker Chart](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/charts/build-a-chart/box-and-whisker-chart.md)
- [Pie and Donut Chart](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/charts/build-a-chart/pie-and-donut-chart.md)
- [Maps](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/charts/build-a-chart/maps.md)
- [Customise a Chart](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/charts/customise-a-chart.md)
- [Create and format trellis charts](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/charts/customise-a-chart/create-and-format-trellis-charts.md)
- [Mark Tooltip Field](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/charts/customise-a-chart/mark-tooltip-field.md)
- [Format Chart Legend](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/charts/customise-a-chart/format-chart-legend.md)
- [Display Chart Data Labels](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/charts/customise-a-chart/display-chart-data-labels.md)
- [Format Chart Axis Position](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/charts/customise-a-chart/format-chart-axis-position.md)
- [Display Chart Reference Marks](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/charts/customise-a-chart/display-chart-reference-marks.md)
- [Add Trend Lines](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/charts/customise-a-chart/add-trend-lines.md)
- [Add a Custom Colour Scale](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/charts/customise-a-chart/add-a-custom-colour-scale.md)
- [Insights](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/insights.md)
- [Booking report](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/booking-report.md)
- [Contact tracing report](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/contact-tracing-report.md)


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://support.meetuma.ai/uma-knowledgebase/data-and-reporting.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.