Skip to main content

AI Generated Cells in Reports

How to generate good AI prompts for Mesh AI Analytics

Ethan avatar
Written by Ethan
Updated over a month ago

The AI Generated Cells in Mesh AI can take your natural language descriptions for a type of analysis and create graphs, tables, lists, and other outputs that meet your needs. But it's not a mind reader - it's more like a junior analyst that has just joined your team and needs good descriptions. This article gives some hints to help you describe your needs.

  1. Specify the Type of Output You Want – For example, if you want a graph chart, table, or summary, say so (e.g., "Show a pie chart of... " or "Create a list of... ").

  2. Be Specific About Your Analysis Needs – Instead of "Show shift data," try "Show a bar graph of how many shifts each associate has."

  3. Include Key Details – If your analysis deals with specific jobs, request types, positions, or others, mention them and how they're used (e.g., "only for Night shifts", or "only for weekend shifts").

  4. Tell the AI How Your Team Uses the System – The AI understands Mesh AI concepts like Shifts, Requests, and Associates, but it doesn’t know the specific ways your team uses them. If your team has unique workflows or definitions, include them. (Example: “Having a 'Conference' request doesn't lower the number of shifts that person can have.”)

  5. Describe Your Thought Process – If you usually follow certain steps to analyze data, explain them in your prompt. (Example: “First, gather all approved requests, then calculate the total days per associate.”) This helps the AI match your approach instead of guessing.

  6. Mention Relevant Rules – The AI doesn’t know your team’s scheduling rules unless you include them. If a rule matters to your analysis, spell it out. (Example: “List any cases where a doctor has more than four night shifts in a row.”)

  7. If It’s Wrong, Refine It – If the result isn't quite right, tweak your request instead of starting over (e.g., changing "A pie chart of shifts" to "A pie chart of shifts but only for associates with the ER position").

Examples

❌ Unclear Prompt

✔️ Clear & Effective Prompt

Show shifts numbers.

Create a graph of the number of shifts each associate has.

Who works too much?

Show a list of the people who have more than 9 shifts.

Show max shifts per week.

For each week, calculate the number of shifts each associate has that week; then show a table of the maximum number of shifts that associate has in any one week.

Find weeks where people are overbooked.

Give me a list of times that people have more than 2 shifts in any week, along with the shifts that contribute in order by start date.

Break down shifts by job.

Show a stacked bar graph of the number of shifts each associate has, separated by job.

Find out if scheduling rules are broken.

List all shifts where someone is scheduled for more than 5 consecutive days, along with the shift details.

Tell me the percentage of Prefer On - Day requests that were honored

Show the percentage of Prefer On - Day requests being honored. Having a Prefer On - Day request means the associate wants a shift that starts between 8am and 4pm during that request.

Shifts for each person vs. GME limit.

List the amount of shifts each person has worked compared to the GME limits. The GME limits for our team are: no more than 1 in 4 'In Hospital Call' days and no more than 1 in 3 'Home Call' days, and no more than two weekends in a 28 day period.

Did this answer your question?