Ask Leina for an event and date range in chat. Get daily event counts and a visual bar chart delivered to your thread, along with the underlying query filters.
Video could not play. Check your connection and try again. Open Video
This walkthrough queries the agent_command_called event to generate daily counts and a bar chart, with in-progress days clearly marked. Substitute your own event name to run the query.
Connect the tools you want Leina to read from and update.
Queries event counts, user metrics, and trend data from your connected PostHog project.
Use Slack to send the request and receive the table and chart in your thread.
Run queries and discuss analytics directly where your team collaborates. Set Up Leina in Slack
Choose your project, event name, aggregation type (total events or unique users), date range, and reporting timezone.
Ask for a daily data table and a chart, along with the filters, time window, and retrieval timestamp so you can check the result.
Compare the query conditions with PostHog, then check a completed day and the full reporting window before sharing.
Replace the bracketed values with your own, then send the prompt in your connected chat.
@Leina In PostHog project [project], count total occurrences of [event_name] from [start timestamp] through [end timestamp], grouped by day in [timezone]. Apply [filters, or none]. Return the daily values and a bar chart in this thread. Include the project name, reporting window, active filters, and retrieval timestamp. Mark any incomplete days or data gaps. Only perform read operations.
@Leina Show the breakdown and exact query parameters for [completed date] from that result so I can verify it in PostHog. Distinguish total occurrences from unique users, and note any filters applied.
When verifying metrics, distinguish between total event occurrences and unique users—daily unique-user figures cannot simply be added together to calculate the multi-day total. Ensure your manual comparison in PostHog uses the exact same project, filters, and reporting timezone.
Read the full walkthrough covering time boundaries, additive versus non-additive metrics, and troubleshooting discrepancies.
A structured Markdown worksheet for documenting query parameters and spot-checking analytics results.
Yes. Slack is where you interact with Leina in channels and threads, while the PostHog connection provides read access to the project analytics you want to query.
Yes. Replace the placeholder with any custom event tracked in your PostHog project, and specify any property filters or user criteria in your prompt.
Yes. Once you have verified your query parameters with an initial request, you can ask Leina to deliver the report on a recurring schedule to your chosen Slack channel.
Connect your accounts, paste the prompt into chat, and let Leina handle the reporting.
Connect Your Apps
