Opened 6 years ago

Last modified 2 weeks ago

#291 new New feature

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

Reported by: mauser Owned by:
Priority: major Milestone: 2.x - The Great Piwik 2.x Backlog
Component: Core Keywords:
Cc: Sensitive: no

Description (last modified by matt)

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.

Attachments (6)

mockup 5 pages table.png (25.1 KB) - added by matt 4 years ago.
Table for pages
mockup 5 Referers table.png (17.0 KB) - added by matt 4 years ago.
Table for referers
mockup 5.png (28.3 KB) - added by matt 4 years ago.
Standard table
sparklines.png (2.0 KB) - added by matt 4 years ago.
Sparklines
mockup1 calendrier.png (29.5 KB) - added by matt 4 years ago.
Calendar mockup
compare periods nice ui.png (108.0 KB) - added by matt 22 months ago.

Download all attachments as: .zip

Change History (55)

comment:1 Changed 6 years ago by mauser (zawadzinski)

  • Description modified (diff)
  • Owner set to mauser

comment:2 Changed 6 years ago by matt (mattab)

  • Milestone changed from Stable release to Future features

comment:3 Changed 6 years ago by matt (mattab)

  • Description modified (diff)

comment:4 Changed 6 years ago by matt (mattab)

  • Description modified (diff)

comment:5 Changed 6 years ago by matt (mattab)

  • Description modified (diff)

comment:6 Changed 5 years ago by matt (mattab)

Depends on #397: graph to plot multiple lines

comment:7 Changed 5 years ago by kpham

comment:8 Changed 5 years ago by kpham

comment:9 Changed 5 years ago by Seb

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?

comment:10 Changed 5 years ago by matt (mattab)

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

comment:11 Changed 4 years ago by matt (mattab)

  • Description modified (diff)
  • Milestone changed from Features requests - after Piwik 1.0 to 2 - Piwik 0.6 - DigitalVibes
  • Sensitive unset

comment:12 Changed 4 years ago by matt (mattab)

  • Description modified (diff)

comment:13 Changed 4 years ago by matt (mattab)

  • Owner changed from mauser to l_biet_bleuroy

comment:14 Changed 4 years ago by matt (mattab)

  • Summary changed from Period compare mode to Add ability to compare two periods: tables, charts, reports would show data for both periods

comment:15 Changed 4 years ago by l_biet_bleuroy

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

comment:16 Changed 4 years ago by l_biet_bleuroy

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

comment:17 Changed 4 years ago by l_biet_bleuroy

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

comment:18 Changed 4 years ago by l_biet_bleuroy

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

comment:19 Changed 4 years ago by l_biet_bleuroy

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

comment:20 Changed 4 years ago by l_biet_bleuroy

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

comment:21 Changed 4 years ago by l_biet_bleuroy

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

comment:22 Changed 4 years ago by l_biet_bleuroy

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

comment:23 Changed 4 years ago by l_biet_bleuroy

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

comment:24 Changed 4 years ago by l_biet_bleuroy

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

comment:25 Changed 4 years ago by matt (mattab)

Adding mockups as attachments.

Changed 4 years ago by matt (mattab)

Table for pages

Changed 4 years ago by matt (mattab)

Table for referers

Changed 4 years ago by matt (mattab)

Standard table

Changed 4 years ago by matt (mattab)

Sparklines

Changed 4 years ago by matt (mattab)

Calendar mockup

comment:26 Changed 4 years ago by l_biet_bleuroy

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

comment:27 Changed 4 years ago by l_biet_bleuroy

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

comment:28 Changed 4 years ago by l_biet_bleuroy

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

comment:29 Changed 4 years ago by l_biet_bleuroy

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

comment:30 Changed 4 years ago by l_biet_bleuroy

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

comment:31 Changed 4 years ago by l_biet_bleuroy

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

comment:32 Changed 4 years ago by matt (mattab)

(In [1896]) Refs #291

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)

comment:33 Changed 4 years ago by matt (mattab)

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

comment:34 Changed 4 years ago by l_biet_bleuroy

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

comment:35 Changed 4 years ago by l_biet_bleuroy

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

comment:36 Changed 4 years ago by l_biet_bleuroy

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

comment:37 Changed 4 years ago by l_biet_bleuroy

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

comment:38 Changed 4 years ago by l_biet_bleuroy

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.

comment:39 Changed 4 years ago by l_biet_bleuroy

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

comment:40 Changed 4 years ago by l_biet_bleuroy

OK :

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

Add to todo list :

  • Debug Piwik_ViewDataTable_HtmlTable_AllColumns

comment:41 Changed 4 years ago by matt (mattab)

  • Milestone changed from 1 - Piwik 0.7 - DigitalVibes to 4 - Piwik 1.0 - Stable release

comment:42 Changed 4 years ago by matt (mattab)

  • Milestone changed from 4 - Piwik 1.0 - Stable release to Features requests - after Piwik 1.0

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

comment:43 Changed 3 years ago by matt (mattab)

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.

comment:44 Changed 3 years ago by matt (mattab)

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

comment:45 Changed 3 years ago by matt (mattab)

  • Owner l_biet_bleuroy deleted

comment:46 Changed 2 years ago by matt (mattab)

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)

comment:47 Changed 22 months ago by matt (mattab)

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.

comment:48 Changed 2 weeks ago by matt (mattab)

  • Milestone changed from Future releases to 2.x - The Great Piwik 2.x Backlog
  • Priority changed from major to normal

comment:49 Changed 2 weeks ago by matt (mattab)

  • Priority changed from normal to major
  • Summary changed from Add ability to compare two periods: tables, charts, reports would show data for both periods to Compare data for two different dates in tables, charts and reports
Note: See TracTickets for help on using tickets.