Spaces
Build reports, presentations and spreadsheets from the data in your Tiquo account.
A space is a document, a slide deck or a spreadsheet that holds charts and tables drawn from your account. You can write one by hand, or ask Euclid to build it and then edit the result.
Open Spaces in the main sidebar, under Analytics. Every dashboard user in your organisation can open the page, and everyone sees the same spaces.
Formats
| Format | What it is | Downloads as |
|---|---|---|
| Document | A written report with headings, text, charts and data tables | PDF or Word document |
| Slides | A presentation deck you can present full screen | PDF or PowerPoint |
| Spreadsheet | Sheets with formulas, plus live data from your account | Excel workbook, or a CSV of the open sheet |
Create a space
- Select New space. On an empty Spaces page you can also pick a format card.
- Choose a Format.
- Enter a Name, up to 120 characters. If you leave it empty, the space gets a default name such as "Untitled report".
- Under Ask Euclid to build it, describe what you want. This is optional. If you fill it in, Euclid starts building as soon as the space opens.
- Choose the Data refresh: Real time or Scheduled. You can change this later.
- Select Create space.
An organisation can hold up to 500 spaces.
Find and manage spaces
The Spaces page shows a card for each space, with its format, its refresh setting and when it was last edited. Use the tabs to show one format, and Search spaces to find a space by name.
Open the More actions menu on a card to Rename, Duplicate or Delete a space. A duplicate is named "(copy)" and opens straight away. Deleting a space permanently removes it along with its saved data snapshots and its Euclid conversations. The data in your account is not affected.
Edit a space
The bar at the top of a space has the name (click it to rename), the save status, Download, the data refresh control and the tools for that format.
Changes save by themselves a moment after you stop typing. The status reads Saved, Unsaved changes or Saving…. If a colleague saves the same space while you have unsaved changes, the status changes to Edited elsewhere and a banner asks you to choose Load their version or Keep my version.
Use Fonts in the toolbar to pick the font for a document or spreadsheet. Slide decks have a heading font and a body font, and these replace the fonts of the deck's theme.
Data refresh
Each space is either real time or scheduled.
- Real time always shows the latest data and keeps updating while the space is open.
- Scheduled captures the data on a schedule, and it stays the same until the next refresh. Choose Every hour, Every day, Every week or Every month, then the minute, time, weekday or day of the month (1 to 28). Times use the timezone of the person who set the schedule, and the panel shows when the next refresh is due.
Select the refresh control in the top bar to change the setting. On a scheduled space the panel shows when the current data was captured, and Refresh now captures fresh data without waiting for the schedule.
Charts
You can add any chart from Analytics to a document or a slide. In the Add a chart window, search or browse the charts, then set what the chart should show:
- Period: today, yesterday, the last 7, 30, 90 or 365 days, the last 12 months, last week, last month, last year, or year to date
- Comparison: no comparison, the previous period, or the previous year
- Locations: all locations or the ones you pick
- Customer lists: all customers or chosen lists. This filter appears for staff with the Manage marketing lists permission
Select a chart you've placed to edit these settings.
Data tables
A data table is either a ranking or a list of records.
Rankings rank customers, products, categories or locations using the orders from the period you select. Choose the columns, the column to sort by, the order, and how many rows to show (up to 500). You can add a title to show above the table.
Records list customers, orders, bookings, enquiries or memberships that match your filters. You can:
- choose the columns to show
- add up to 12 filters. A record must match every filter
- show the result as a List of records or a Grouped summary. A grouped summary counts the records in each group and adds the totals you pick. Date fields can be grouped per day, week or month
- turn on the Totals row, which totals every matching record and not only the rows shown
- set a row limit of up to 1,000
Each table has Reload data and Download CSV. The CSV holds every matching record up to 1,000 rows, and Tiquo tells you when the download was cut off at that limit.
Who can see the data
Opening a space doesn't give anyone access to data their role doesn't allow. Charts and tables load using the permissions of the person viewing them:
| Content | Permissions needed |
|---|---|
| Charts | View analytics & reports |
| Rankings of products, categories or locations | View analytics & reports |
| Rankings of customers | View analytics & reports and View customers |
| Records of customers or memberships | View analytics & reports and View customers |
| Records of orders or bookings | View analytics & reports and View orders & enquiries |
| Records of enquiries | View analytics & reports and Manage enquiries |
Staff who are limited to certain locations only see data for those locations.
Documents
A document is a single page of rich text. Type / to insert headings, lists and other blocks, a chart, or a data table. Use the toolbar above the page to format text.
Slides
The rail on the left lists the slides. Select one to edit it, drag slides to reorder them, and select Add slide to choose a layout for a new one. Layouts are grouped into Openers, Text, Images, Data, Structure, People and Closing.
Click the text on a slide to edit it. A content area can hold text, an image or video, an analytics chart, or a data table. Images and videos come from your organisation's media library or from your computer, and uploads are saved to the media library. Videos can be MP4 or WebM, up to 150 MB.
The toolbar above the slide has these tools:
- Theme sets the layout, type and image placement of every slide. There are eight themes: Core, Grid, Pitch, Folio, Studio, Dossier, Frame and Terrain. Your content stays in place when you switch.
- Colours sets the deck's palette. A new deck uses your organisation's active theme. You can pick another organisation theme or a suggested palette, or edit the colours yourself. Save palette keeps a custom palette for use in other presentations.
- Change layout moves the current slide to another layout. Content in matching areas stays with the slide.
- Tone switches the slide between Page, Soft, Inverse and Accent backgrounds, or back to the theme default.
- Duplicate slide and Delete slide. Deleting a slide can't be undone, and a deck always keeps at least one slide.
Add Speaker notes under each slide. They are included in the PowerPoint download.
Present
Select Present to show the deck from the current slide.
| Key | Action |
|---|---|
| Right arrow, Down arrow, Page Down, Space or Enter | Next slide |
| Left arrow, Up arrow, Page Up or Backspace | Previous slide |
| Home / End | First / last slide |
| F | Full screen on or off |
| Esc | Exit the presentation |
The on-screen controls do the same.
Spreadsheets
A spreadsheet has one or more sheets, shown as tabs at the bottom. Select Add sheet and choose Blank sheet or Live data sheet. Double-click a tab to rename a sheet. Two sheets can't share a name.
Type a value or a formula into a cell, or into the formula bar above the grid. A sheet can grow to 2,000 rows and 52 columns: use Add 50 rows and Add column at the edges of the grid. Drag a column's edge to resize it. Undo and Redo are in the toolbar, with the usual keyboard shortcuts.
Formulas
Formulas start with =, for example =SUM(A1:A10). They can refer to cells on other sheets. These functions are supported:
| Type | Functions |
|---|---|
| Maths | SUM, AVERAGE, MIN, MAX, COUNT, COUNTA, PRODUCT, MEDIAN, ROUND, ROUNDUP, ROUNDDOWN, INT, MOD, POWER, SQRT, ABS |
| Conditional totals | SUMIF, SUMIFS, COUNTIF, COUNTIFS, AVERAGEIF, AVERAGEIFS |
| Logic | IF, IFERROR, IFNA, AND, OR, NOT, ISBLANK, ISNUMBER, ISTEXT, ISERROR |
| Lookup | VLOOKUP, INDEX, MATCH |
| Text | CONCAT, CONCATENATE, LEN, LEFT, RIGHT, MID, UPPER, LOWER, TRIM, TEXT, VALUE |
| Dates | TODAY, NOW, DATE, YEAR, MONTH, DAY |
Live data
Live data puts records or rankings from your account into the grid. Select a cell, then Insert data, and choose what to list. The header row goes in the cell you selected and the rows fill the cells below. Rankings and more options… opens the full data table settings.
Once the data is in place, use the menu on each column header to:
- add a field, insert one to the right, replace the field or remove it
- sort ascending or descending
- filter by the field
- edit, refresh or remove the data, or change its row limit
Live data needs empty cells below and to the right. If other cells are in the way, Tiquo asks you to clear them or move the data. Cells that show live data can't be typed over, but formulas elsewhere can refer to them.
Deleting a sheet removes its data, and formulas on other sheets that refer to it show #REF!. You can undo for a few seconds after deleting.
Build with Euclid
Each space has its own Euclid panel beside the editor. It opens by itself on a new or empty space. On other spaces, open it with the Euclid button in the dashboard header.
Ask for what you want in plain words, such as "Write a monthly performance report for last month" or "Add a sheet of product revenue for the last 30 days". Euclid can add charts and live data, write the text and lay out the space. In a slide deck it can also restyle the deck in another theme.
Euclid edits the space directly and doesn't ask for approval first. The editor is locked while Euclid works, and the panel shows how many changes were applied when it finishes. You can change or remove anything afterwards. Select Stop to end a request early, or New conversation to start again on a new subject.
Euclid in Spaces is in beta. If Euclid is turned off for your organisation, the panel says so, and an admin can turn it on in Settings > Tiquo AI. You can still build spaces by hand.
Download
Select Download in the top bar and choose a format. Charts and tables in the file show the data as it was when you downloaded it.