Change a report's conditions, period and columns

Edit the blue report sentence to change filters, location, client status, time period, columns, sorting and highlights, or describe the change in words.

Who can do this
Owners, team admins and trainers
Where in Strix
Reports

Every report is a sentence, like “Show me a list of current clients at all locations who didn’t check in during the last 30 days”. Each blue phrase is a choice you can tap and change. Results update when you run the report again.

Steps

  1. Open a report from Reports, or start one by asking a question.
  2. Tap a blue phrase to change it:
    • Client status: Current clients (leaves out clients you marked inactive), Inactive clients, or Current and inactive clients.
    • Report on: Clients (one row per client), Exercises (one row per exercise your clients did), Sessions (one row per scheduled session, booked or not), Coaches (one row per coach on your team), Payments (one row per payment, with gross, fees and net), Membership changes (one row per change, pause or cancellation request), Churned clients (one row per client who left, with the churn rate), Workouts (one row per completed workout) Personal records (one row per client’s best lift on each exercise) or Client exercises (one row per client and exercise they did in the period). Sessions and churn reports have no client status.
    • Location: the location chosen in the top bar, All locations, or one location. A single location means clients whose home location is there, sessions held there, coaches assigned to it, or payments billed there.
    • Activity period: Today, Yesterday, Next 7 days or Next 30 days, Last 7 days through Last year, or Custom dates with a Start date and End date. Next 7 days and Next 30 days start today, so they cover sessions booked ahead.
  3. To add a filter, tap the + phrase at the end of the conditions and pick a field. Use Find a field to search. Fields are grouped as Attendance, Training, Billing, Records, Workload (coach reports) and About them.
  4. Tap a condition to change its comparison (such as is at least, is between or is any of) and value, then click Done. Click Check something else to swap the field.
    • Client dates, such as Member since or First visit, can use is in the report period instead of fixed dates. A saved report of clients who joined this month then keeps up as the month changes.
    • Dates can also count days from today: is in the last … days, is in the next … days or is more than … days ago. For example, Next visit is in the next 3 days or Member since is in the last 14 days. Today counts as the first of the last or next days.
  5. Tap and or or between conditions to switch every condition between matching all and matching any.
  6. To mix “and” with “or”, choose Add an either/or group (or Add an “all of these” group) when adding a condition. For example: clients with a check-in who are either under 18 or over 65.
  7. Remove a condition with its X. Click Undo if you remove one by mistake.
  8. Below the sentence, for list reports:
    • Columns: click Edit to add, hide or reorder columns. You can also drag column headings in the results.
    • Sorted by: click Change to pick the sort field and order. You can also click a column heading.
    • Highlights: click Add to color numbers that need attention in Red, Amber or Green, such as 3 or more no-shows.
  9. Click Run again (or press Ctrl/Cmd+ + Enter).

You can also type a change in the box under the sentence, such as “only Downtown”, “add their age” or “show it as a chart”, and click Update. The sentence changes and you see Sentence updated. Run it to see new results.

Good to know

  • A report can have up to 12 conditions, counting those inside groups.
  • Custom dates can cover up to 366 days. Weeks start on Sunday.
  • The period does not affect lifetime totals, birthdays or anniversaries. When a report only uses those, it says Dates don’t change this report.
  • When a report shows age or lifetime totals, you can count them as of an earlier date instead of today.
  • Name conditions suggest client or exercise names as you type.
  • Click How this is counted under the sentence to see exactly what each field counts.
  • If you change the sentence after running, you see These results are out of date until you run it again.

Last updated

All help articles