Comparing Data Week Over Week for Three Months in a Table
Hi all, Is it possible, in a table, to compare data week over week over a 3 months period? I only manage to compare 2 weeks.. Thanks!
Two main options around this (with links to a sample dataset)
- 1.
Line view for 3 months, 'Compare to previous week (uplift) and weekly breakdown eg https://mixpanel.com/s/4DkbS6 - has the nice % comparison for each week, but just shows a giant row
- 2.
Table view and instead of 'compare to previous week' you add a breakdown for Time -> by Week eg https://mixpanel.com/s/2AoHwY - no %'s comparing each week due to the breakdown, but a nicer visual view with a row per week
- 1.
Rémi T.··Christopher C. you are my hero. Thank you!!! Will try and let you know if it's a success!!
- Rémi T.··
I'd love to use a table as it's much nicer to read from a dashboard. my issue is the following: I'd like 1 column per week for the past 10 weeks and 1 row per customer, any idea on how to do this in a table?
- Rémi T.··
using your first suggestion, 2 questions:
can i reverse the order of display in the table below to have the most recent week first and not have to scroll to the right?
how do i display the % of evolution vs the previous week as you did?
Hmmmm, I don't think you can change the order of the columns no, best you can do is reduce the time period so it only covers 6 days or weeks etc so you don't have to scroll =\ For the % uplift, you can click up the top Compare -> To previous Week and then it will pop up defaulting to just the # comparison, you want to click on the icon to the right of the Hash (arrow pointing up)
For the '1 column per week and 1 row per customer' you can do this too, but it'll be a little painful and not great (at least, in the way that I am thinking of) Basically you can change your breakdown to be by User -> Email or User -> ID etc (any unique property on a user essentially that is meaningful to you), and that will give you one row per user. For one column per week though, you'd need to duplicate your metric and timebox it to each week eg https://mixpanel.com/s/1vztoh which might be alright for you, but it won't give you the time ranges AFAIK. Someone else might have a better suggestion than that though, it's just the only thing I could think of to do one column per week.
- Rémi T.··
Thank you very much for your help Christopher, it's very much appreciated!! I find it a bit frustrating not being able to do a display in a table per week for a certain number of weeks easily. 😕