Allow pivoting on API call level (enable RowEvolutions for pivoted columns)

matomo-org / matomo

Empowering People Ethically with the leading open source alternative to Google Analytics that gives you full control over your data. Matomo lets you easily collect data from websites & apps and visualise this data and extract insights. Privacy is built-in. Liberating Web Analytics. Star us on Github? +1. And we love Pull Requests!

https://matomo.org/

GNU General Public License v3.0

19.63k stars 2.62k forks source link

Allow pivoting on API call level (enable RowEvolutions for pivoted columns) #6308

Open mgazdzik opened 9 years ago

mgazdzik commented 9 years ago

Currently pivot feature is available only in UI (via configureViewDataTable), while it would be great to also give such possibility in API. Very useful use-case would be to use such feature to allow row-evolution graphs for pivoted columns. Each label to plot would be another pivoted column. Also there could be "other" and "total" column to visualize how each of columns evolve.

Please let me know if this ticket description is sufficent or should I elaborate more on this concept ?

diosmosis commented 9 years ago

It's possible do pivot-ing in the API (otherwise the export functions wouldn't work w/ pivoted data). I don't know about row evolution w/ pivotted tables, though, I haven't tried that. If it does work, it will likely be slow.

mattab commented 9 years ago