Skip to content

HTTPS clone URL

Subversion checkout URL

You can clone with HTTPS or Subversion.

Download ZIP

Loading…

Custom Reports, Pivot table feature for Piwik #4776

Open
mattab opened this Issue · 3 comments

2 participants

Matthieu Aubry Anonymous Piwik user
Matthieu Aubry
Owner

There are many cases where a Pivot table functionality would help get very powerful insights from the data.

This feature lets you create Pivot table, so for example you can see "For each Page URL, list all Referrers used" (each referrer is a new column in the Actions table). We need to add a new button to let user navigate through columns since there will be thousands of columns when Pivot table is enabled.

Pivot charts in GA are explained in this post and this one. See general overview

Anonymous Piwik user

from an analytics view point i think matching omnitures method of reporting multiple columns is more advantageous. i can provide screens if you like . i magine a year report broken down by month where each month was a row then each column coul be a metric like pv or uv or vistit.

another option would be compare 5 columms for 1 metric where each column was top results again broken down by a row for each month....

pics will help clarify, this would be 10 times more useful than a pivot table.

Matthieu Aubry
Owner

@lesjokolat sounds interesting, feel free to link to attach a screenshot. Like to get feedback on this hard to implement, but powerful analysis tool!

Matthieu Aubry mattab removed Major c: Core labels
Matthieu Aubry
Owner

we recently added Pivot table see in the API ref doc the parameters pivotBy and pivotByColumn but they're pretty slow. see also #6227

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Something went wrong with that request. Please try again.