✨ What’s new
The AI Query Helper now takes your query building experience further—combining available fields with on-demand calculations like totals, variances, revenue shares, and cancellation ratios, all through a single conversation.
Where it once helped you select and arrange fields, it now also creates new calculations using the full power of workbook formulas—helping you shape analyses more precisely and answer deeper questions faster.
All without breaking your flow.
📊 Why it matters in your day-to-day
Now, totals, subtotals, and flexible calculations are all possible—right inside the AI Query Helper.
You stay focused on shaping insights, not on setting up formulas.🚀 Go a step further – try these power-prompts
- “Highlight any market segment whose revenue share is above 25%.”
- “Identify dates in the upcoming quarter with occupancy below STLY by more than 10%."
- "Flag days of the week where occupancy decreased but ADR increased compared with the previous month."
- “Give me the variance in RevPAR by property compared with the same time last year.”
- “What percentage of total units came from direct bookings last quarter?”
You can adjust timeframes (“last 90 days,” “QTD”), segments (market, channel, room type), or thresholds depending on the question you're exploring.
🛠 How to get started
- Open a Topic— the AI Query Helper chat appears right in the center.
- Or open it anytimefrom the left-hand panel inside any workbook tab.
- Type your question or promptin everyday language.
- Your query will update automatically—with new calculations included in the results table.
You can sort, filter, and build visualizations afterward, just like always.
💬 Built from your feedback
Over the past six weeks, one in every five AI-assisted chats included a request for a calculation.
This new capability is a direct result of what you were already asking for—giving you more flexibility, faster answers, and fewer steps.
🔎 The takeaway
You can now shape queries with totals, variances, shares, and more—without leaving the conversation.
Whether you're reviewing performance, adjusting strategy, or just exploring trends, the AI Query Helper helps you move faster and dig deeper—all in one place.
Questions or feedback? Let us know in the chat!