API pivotBy and pivotByColumn

[meyerdominik]

matomo-org/matomo#4776 (comment)

What pivotBy-dimensions are available?
I can't seem to find any documentation about that. Neither is anything working, that I've tried to guess. I'm always getting the error Invalid dimension '<...>'..

Example: I want to pivot the VisitsSummary.getVisits by country.

https://<matomo-url>/?module=API
&method=VisitsSummary.getVisits
&idSite=2
&date=last7
&period=day
&format=xml
&language=de
&token_auth=<api-token>
&filter_limit=-1
&pivotBy=<??>
&pivotByColumn=Country

[michalkleiner]

Have you checked https://developer.matomo.org/api-reference/reporting-api#optional-api-parameters docs?

[meyerdominik]

Yes, I have. It just says:

[...]To pivot a report, this query parameter must be set to the ID of the dimension to pivot by. For example, queryParam=Referrers.Keyword would pivot against the Keyword dimension.

Sadly my question isn't answered by the docs.

[meyerdominik]

I finally found them: All available dimensions can be requested with the method CustomReports.getAvailableDimensions

Imho this needs to be described in the Optional API parameters -> pivotBy; section.

[michalkleiner]

It seems like that method possibly comes from a premium plugin that not all users may have available to them, can you confirm that you do use the Custom Reports premium plugin? Does it only apply then?

[meyerdominik]

Oh yes it is, I wasn't aware of that (I asked a colleague).

[sgiehl]

pivotBy is only supported by custom reports and a couple of reports in core, that have a second dimension, like event reports. So this can't be used for all reports.