Can i calculate networkdays in mixpanel

Hi Evan S., Please stand by as I search the Mixpanel knowledge base for an AI-powered answer. I normally take about 15 seconds or so. In case AI cannot answer your question, feel free to reach out to Mixpanel support at mixpanel.com/get-support. If you have follow-up questions for this thread, please tag me again with your question: @kapa.ai <follow-up question> 👋

Based on the knowledge sources provided, there isn't specific information about calculating "networkdays" (business days between two dates, excluding weekends and holidays) directly in Mixpanel.

Mixpanel does offer various date range and time calculation capabilities, including:

- Custom date ranges and time intervals in reports - Formula calculations for metrics - JQL (JavaScript Query Language) with time bucketing functions

However, a specific "networkdays" function similar to what exists in spreadsheet applications isn't explicitly mentioned in the provided documentation.

If you need to calculate business days between dates, you might need to:

1. Use Mixpanel's JQL with custom JavaScript to implement this calculation 2. Calculate this outside of Mixpanel and import the results 3. Use formulas with date functions if Mixpanel supports the specific operations needed

For more specific guidance, you might want to check Mixpanel's complete documentation or contact Mixpanel support directly as the knowledge sources provided don't contain enough information about this specific functionality.

ℹ️ Tip: Mention @kapa.ai in the thread for follow-ups or DM the app for 1-to-1 help.