Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Compare data for two different dates in tables, charts and reports #5711

Closed
zawadzinski opened this issue Jul 8, 2008 · 14 comments · Fixed by #14365
Closed

Compare data for two different dates in tables, charts and reports #5711

zawadzinski opened this issue Jul 8, 2008 · 14 comments · Fixed by #14365
Assignees
Labels
c: Platform For Matomo platform changes that aren't impacting any of our APIs but improve the core itself. Enhancement For new feature suggestions that enhance Matomo's capabilities or add a new report, new API etc. Major Indicates the severity or impact or benefit of an issue is much higher than normal but not critical.
Milestone

Comments

@zawadzinski
Copy link
Contributor

This feature is important to web marketers and to a web analytics solution in general. The user should be able to select two periods to compare in the Piwik UI. The graphs, tables, sparklines, texts, would show values for both periods as well as the % of evolution.

@anonymous-matomo-user
Copy link

Hi, I have working on a Piwik for a few weeks and my project needs a period compare mode. Even if this feature is planned after V1, nobody has post on this ticket.
Did anybody work on it? And what is the progress? Could I help to develop the feature since I quickly need it?

@mattab
Copy link
Member

mattab commented May 29, 2009

nobody is working on it.

The best way if you would like to contribute this back to core, is to post here your specification of what you want to do and how you are planning to do it, and we might be able to review and help you out. This is not a trivial task so it requires careful planning. that would be great new feature though

@mattab
Copy link
Member

mattab commented Feb 9, 2010

Attachment: Table for pages
mockup 5 pages table.png

@mattab
Copy link
Member

mattab commented Feb 9, 2010

Attachment: Table for referers
mockup 5 Referers table.png

@mattab
Copy link
Member

mattab commented Feb 9, 2010

Attachment: Standard table
mockup 5.png

@mattab
Copy link
Member

mattab commented Feb 9, 2010

Attachment: Sparklines
sparklines.png

@mattab
Copy link
Member

mattab commented Feb 9, 2010

Attachment: Calendar mockup
mockup1 calendrier.png

@mattab
Copy link
Member

mattab commented Mar 2, 2011

This feature might be picked up soon as requests are increasing. If you are interested in sponsoring the feature, please contact us at services at piwik.org

Note that the code in the branch cannot be reused, but definitely a good place to look at for ideas on how to implement this the easiest way.

@mattab
Copy link
Member

mattab commented Mar 4, 2011

Comparing 2 reports together is useful for dates, but also to compare visitor segments (eg. All visitors VS Visitors coming from Adwords) - see #2135

@mattab
Copy link
Member

mattab commented Nov 8, 2011

See this example to integrate "Time comparisons" in a table: http://www.shufflepoint.com/assets/slides/267_prr.png

But a green/red indicator might be as good or better than 2 horizontal lines per row...

This would be used

  • In all tables in the UI when comparing 2 periods
  • In the PDF/Email reports by default (compared to N-1 period)

@mattab
Copy link
Member

mattab commented Jun 25, 2012

Attachment:
compare periods nice ui.png

Related to comparing segments #7716 since both would use same mechanism

@zawadzinski zawadzinski added this to the 2.x - The Great Piwik 2.x Backlog milestone Jul 8, 2014
@mattab mattab removed the c: Core label Aug 3, 2014
@mattab mattab added this to the Mid term milestone Aug 3, 2014
@mattab mattab added the c: Platform For Matomo platform changes that aren't impacting any of our APIs but improve the core itself. label Sep 9, 2014
@mattab mattab modified the milestones: Mid term, Long term Dec 5, 2016
@Japhys
Copy link

Japhys commented Aug 10, 2017

Is this something we can expect in the future? I really would like to have this feature! I switched from GA to Piwik on a site with millions of visitors a month, I really miss the ability to compare monthly and quarterly reports in a quick and easy way

@mattab
Copy link
Member

mattab commented Sep 18, 2017

Yes, we hope to implement this feature in the future. If your company can sponsor this change, it would certainly help make it happen faster 👍 https://piwik.org/development/

@tsteur
Copy link
Member

tsteur commented Jan 24, 2019

Unassigning myself for now as I'm not sure when I find time to work on it again. Started work on it here: https://github.com/matomo-org/matomo/compare/5711

Done so far:

  • For regular data tables support date1=&period1= for date comparison, as well as &segment1=...&segment2=&segment3=&segment4= for segment comparison. both can be used together
  • Adjusted date selector to support comparisons (not fully finished eg compare date needs to adjust automatically depending on selection of comparison period and selected period etc)
  • When comparing data, we automatically flatten the data (at least for now)... maybe some reports want to define different behaviour and only work on first row level data (eg acquisition websites, etc)
  • Data structure looks like
    • Label1
      • Date1 (present if comparing date)
        • Segment1 (present if comparing segment)
        • Segment2 (present if comparing segment)
      • Date2 (present if comparing date)
        • Segment1 (present if comparing segment)
        • Segment2 (present if comparing segment)
    • Label2
      • ....

To be done:

  • Add comparison selection to segment selector: We would only allow to compare to other already created segments
  • In API response I currently set the segment expression in the API output as label but would need to show ideally the segment name if the segment expression is found
  • Need to automatically expand all rows in html table when comparing data? not sure...
  • Define how API output could look like when using simple datatable (sparklines, evolution graph)
  • Support comparison for bar, pie, ... charts
  • Support comparison for evolution graphs
  • Support comparison for sparklines
  • Support comparison ideally in row evolution

@tsteur tsteur removed their assignment Jan 24, 2019
@mattab mattab modified the milestones: 3.9.0, 3.10.0 Mar 18, 2019
@mattab mattab modified the milestones: 3.10.0, 3.11.0 May 28, 2019
@mattab mattab modified the milestones: 3.11.0, 3.12.0 Jul 23, 2019
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
c: Platform For Matomo platform changes that aren't impacting any of our APIs but improve the core itself. Enhancement For new feature suggestions that enhance Matomo's capabilities or add a new report, new API etc. Major Indicates the severity or impact or benefit of an issue is much higher than normal but not critical.
Projects
None yet
Development

Successfully merging a pull request may close this issue.

6 participants