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

Aggregate multi-column data over a date range #1121

Closed
anonymous-matomo-user opened this issue Jan 21, 2010 · 5 comments
Closed

Aggregate multi-column data over a date range #1121

anonymous-matomo-user opened this issue Jan 21, 2010 · 5 comments
Labels
duplicate For issues that already existed in our issue tracker and were reported previously. Enhancement For new feature suggestions that enhance Matomo's capabilities or add a new report, new API etc.
Milestone

Comments

@anonymous-matomo-user
Copy link

When I call

index.php?module=VisitTime&action=getVisitInformationPerServerTime&idSite=2&period=day&date=last30&token_auth=xxx&viewDataTable=generateDataChartVerticalBar

this resutls in an error message:

Fatal error: Call to undefined method Piwik_DataTable_Array::getColumn() in /Users/typo3felix/Sites/piwik/core/ViewDataTable/GenerateGraphData.php on line 133

I tested this on PHP 5.2.12 and 5.3.1 using Piwik 0.5.4.

@mattab
Copy link
Member

mattab commented Feb 11, 2010

Interesting.. is this a regression from loading the graph data inline?

What is the use case that you are querying this data? Do you still have the old client side code doing the data fetch on page load?

@robocoder
Copy link
Contributor

Not a regression. The problem is that date=last30 and the expectation that the results should be summed up for the date range.

@anonymous-matomo-user
Copy link
Author

I got the same error message on another query with a date range. This iframe:

<iframe width="100%" height="350" src="http://HOSTNAME/index.php?module=Widgetize&action=iframe&moduleToWidgetize=UserSettings&actionToWidgetize=getBrowserType&idSite=2&period=day&date=2010-02-08,2010-02-11&disableLink=1" scrolling="auto" frameborder="0" marginheight="0" marginwidth="0"></iframe>

produced the error message:

Fatal error: Call to undefined method Piwik_DataTable_Array::getColumn() in /var/www/SITE/piwik/core/ViewDataTable/GenerateGraphData.php on line 133

If I change date=2010-02-08,2010-02-11 to date=2010-02-08 then the error does not appear. I was expecting to get data summarized over the entire date range.

This is with Piwik 0.5.4 and PHP 5.2.10 on CentOS 5.4.

@anonymous-matomo-user
Copy link
Author

Re: http://HOSTNAME/index.php?module=Widgetize&action=iframe&moduleToWidgetize=UserSettings&actionToWidgetize=getBrowserType&idSite=2&period=day&date=2010-02-08,2010-02-11&disableLink=1

I bypassed the Widgetize module and queried the UserSettings modules as follows:

http://HOSTNAME/index.php?module=API&method=UserSettings.getBrowserType&idSite=2&period=day&date=2010-02-08,2010-02-11&format=xml&token_auth=TOKEN

This query returned data fine. It does return data grouped by each day in the date range. With the previously mentioned iframe I wanted data summarized over the entire period. Perhaps there should be (or is) an API call that returns the data grouped over the entire date range.

PS: I hope I didn't take focus away from the original problem reported in this ticket. The error message was the same so I thought it was the same problem.

@mattab
Copy link
Member

mattab commented Mar 29, 2010

not a bug, to get aggregated data over a period, you need to set period=week or month or year, and day being any day in the date range. This is until #572 (custom date range) is implemented.

@anonymous-matomo-user anonymous-matomo-user added this to the Piwik 0.6 milestone Jul 8, 2014
This issue was closed.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
duplicate For issues that already existed in our issue tracker and were reported previously. Enhancement For new feature suggestions that enhance Matomo's capabilities or add a new report, new API etc.
Projects
None yet
Development

No branches or pull requests

3 participants