A simple question that I haven't been able to figure out. In an Insight report and Table format, I have one event with a few breakdowns. One of the breakdown is Time by Day. How can I sort the table by Time ? I see an option Sort but it doesn't include Time.
Hi Mattias N., 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> 👋
Feel free to ask a follow-up question once I've answered by mentioning me with @kapa.ai
To answer your question about sorting a Table format Insight report by Time in Mixpanel, I'll refer to the relevant information from the documentation.According to the Insights documentation, when you have a breakdown by Time in your Table chart, you can sort the results by clicking on the column headers. Specifically for Time breakdowns, the documentation states: "You can break down your results by the "Time" event property and break down by Hour, Day, Week, Month, Quarter, Year, Hour of Day, or Day of Week."To sort by Time in your Table format: 1. Locate the column header for your Time breakdown (which should be "Day" in your case). 2. Click on this column header. 3. Clicking once should sort the table by that time column in ascending order. 4. Clicking again should reverse the sort to descending order.If you don't see the Time column as an option for sorting, make sure that you have indeed applied the Time breakdown correctly in your report setup.It's worth noting that the sorting behavior might be slightly different depending on whether you're using the Grouped or Ungrouped view in the Table chart. The documentation mentions: "In the ungrouped view, choose the number of rows to display: In the grouped view, you can choose the number of rows you want to display for each breakdown:"If you're still unable to sort by Time after trying these steps, it might be helpful to double-check your report configuration or reach out to Mixpanel support for further assistance, as the available documentation doesn't mention any limitations on sorting by Time breakdowns.
kapa.ai is still learning and improving, please let me know how I did by reacting below.
ℹ️ Tip: Mention @kapa.ai in the thread for follow-ups or DM the app for 1-to-1 help.
kapa.ai the Time header is not clickable, I tested disable Group segments . However when I tested changing Time to by ISO 8601 instead of by Day it seems to be working.
Let me check the knowledge base for you again. One moment! 📚
Thank you for providing more details about your experience. It seems you've found a workaround, but let me explain why this might be happening and confirm your findings based on the available information.The behavior you're describing isn't explicitly mentioned in the Mixpanel documentation provided. However, your observation about the Time header not being clickable when set to "by Day" and becoming sortable when changed to "by ISO 8601" is interesting and potentially related to how Mixpanel handles different time formats.According to the Insights documentation on sorting, when you have a breakdown by Time, you should be able to sort by clicking on the column headers. The fact that this isn't working as expected for the "by Day" format could be a limitation or a bug in the current implementation.Your workaround of changing the Time breakdown to "by ISO 8601" instead of "by Day" is a good solution. ISO 8601 is a standardized date and time format, which might be treated more like a string or numeric value by Mixpanel's sorting algorithm, making it sortable.Here are a few additional points to consider: 1. The documentation mentions that for high-cardinality number data types, Insights automatically buckets them into ranges. It's possible that "by Day" is being treated differently than "by ISO 8601" in this regard.2. The typecasting feature in Mixpanel allows you to force properties into another data type. You might want to experiment with this to see if it affects the sortability of your Time column.3. If this issue persists or affects your analysis significantly, it would be worth reporting to Mixpanel support as it seems to be inconsistent with the expected behavior described in their documentation.Remember, while your workaround is effective, it's always good to ensure that changing the time format doesn't affect the accuracy or interpretation of your data in any way.
kapa.ai is still learning and improving, please let me know how I did by reacting below.
ℹ️ Tip: Mention @kapa.ai in the thread for follow-ups or DM the app for 1-to-1 help.
