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

Open
zawadzinski opened this Issue Jul 8, 2008 · 40 comments

3 participants

@zawadzinski

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.

@mattab
Piwik Open Source Analytics member

Depends on #397: graph to plot multiple lines

@anonymous-piwik-user

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
Piwik Open Source Analytics member

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

@anonymous-piwik-user

(In [1731]) Refs #5711 New comparison calendar

@anonymous-piwik-user

(In [1747]) Refs #5711 Change Css calendar to resolve a display bug.

@anonymous-piwik-user

(In [1748]) Refs #5711 Fixes a css bug

@anonymous-piwik-user

(In [1778]) Refs #5711 Add Comparison DataTable (Array and Simple).

@anonymous-piwik-user

(In [1779]) Refs #5711 Add comparison values in dataTables

@anonymous-piwik-user

(In [1795]) Refs #5711 fixes a bug that create duplicate rows in DataTables

@anonymous-piwik-user

(In [1799]) Refs #5711 Comparison DataTable v0.2

@anonymous-piwik-user

(In [1800]) Refs #5711 Comparison DataTable v0.2

@anonymous-piwik-user

(In [1801]) Refs #5711 Comparison DataTable v0.2

@anonymous-piwik-user

(In [1828]) Refs #5711 Refactoring and view

@mattab
Piwik Open Source Analytics member

Adding mockups as attachments.

@mattab
Piwik Open Source Analytics member

Attachment: Table for pages
mockup 5 pages table.png

@mattab
Piwik Open Source Analytics member

Attachment: Table for referers
mockup 5 Referers table.png

@mattab
Piwik Open Source Analytics member

Attachment: Standard table
mockup 5.png

@mattab
Piwik Open Source Analytics member

Attachment: Sparklines
sparklines.png

@mattab
Piwik Open Source Analytics member

Attachment: Calendar mockup
mockup1 calendrier.png

@anonymous-piwik-user

(In [1836]) Refs #5711 Templates CoreHome.

@anonymous-piwik-user

(In [1849]) Refs #5711 Added the method of comparison for the dashboard

@anonymous-piwik-user

(In [1851]) Refs #5711 Update of the comparison in the context of merging with trunk

@anonymous-piwik-user

(In [1860]) Refs #5711 multiples subDatatables.

@anonymous-piwik-user

(In [1880]) Refs #5711 Comparison DataTables Beta Version + function disableCompareMode.

@anonymous-piwik-user

(In [1892]) Refs #5711 Correction for keydate "today"

@mattab
Piwik Open Source Analytics member

(In [1896]) Refs #5711

idSubtable, in period compare mode, is now of format $ID_CURRENT_DATE-$ID_COMPARED_DATE
the ViewDataTable then parses this idSubtable to load both data tables correctly.

It now works fine on simple datatable, I need to also port this to action data table (page views)

@mattab
Piwik Open Source Analytics member

(In [1897]) Refs #5711
remove duplicated <td>

@anonymous-piwik-user

(In [1938]) Refs #5711 Correction for filter_limit and maxrows for tables.

@anonymous-piwik-user

(In [1984]) Refs #5711 Fixes Steps bug for Comparison (ChartEvolution)

@anonymous-piwik-user

(In [1985]) Refs #5711 Dynamic Step for chart "ChartEvolution"

@anonymous-piwik-user

(In [1996]) Refs #5711 Management of filters for the comparison.

@anonymous-piwik-user

Must be done :

  • Refactoring of core/API/DataTableGenericFilter.php
  • Debug the search engine.
  • Set comparison for histogram.
  • Test all cases.
  • Add somes comments.
  • Code Review.
  • Final refactoring.
  • Do a little community doc.
@anonymous-piwik-user

(In [2009]) Refs #5711 fixes the bug of the Search engine in Comparison mode

@anonymous-piwik-user

OK :

  • Refactoring of core/API/DataTableGenericFilter.php
  • Debug the search engine.

Add to todo list :

  • Debug Piwik_ViewDataTable_HtmlTable_AllColumns
@mattab
Piwik Open Source Analytics member

Development has stopped in the branch. Moving this to post 1.0

@mattab
Piwik Open Source Analytics member

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
Piwik Open Source Analytics member

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
Piwik Open Source Analytics member

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
Piwik Open Source Analytics member

Work is being done in #3013 to add support for plotting multiple data values on a Static graph.

This feature would allow to implement "Compare to last period" feature in Email reports (Pdf/HTML), as a first "easier" step to implementing this feature.

We could implement the comparisons in the graphs (#3013) and add green/red percentages for every row of other report tables.

@mattab
Piwik Open Source Analytics member
@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 label Sep 9, 2014
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment