Create Daily Change Report / Racing Bar Chart Type Data

  • 6 August 2020
  • 1 reply

Through our MixPanel implementation, I’m able to go in and see which model drone people are using when they fly with our software.  I also found a way to export a snapshot of THAT day.


However, I want to see that report broken down by day for the past 30 or 90 days so I can generate a “racing bar chart” showing what drones people are using over time.

Bottom line, just want to be able to export the  daily “model” data count by day for the past 30 days.

How do I do this?

1 reply

Userlevel 3
Badge +1

Hi @egoldy,

Have you tried the following:

  • Build an Insights report - event: “Fly_drone”
  • Breakdown by property: “drone_model”
  • Breakdown by Date: “Day”

Here’s an example from a demo project that tracks events for a video streaming app:

I used the event “watch video” and broke down by “genre” and Date > Day.


The result looks like this:


You can drag the properties in the Breakdown to change the order if you’d like to see for each “drone_model” how the days compare to each other.

Let me know if this solves your question!