Issues when selecting Date + Hour in Time Dimension

[aa-matthias]

trafficstars

Describe the bug When selecting Date + Hour in Time Dimension queries stop showing. The error i get via Grafana Log is:

logger=plugin.blackcowmoo-googleanalytics-datasource t=2024-09-12T16:31:29.306872536+02:00 level=error msg=timeConverter error="parsing time "(other)00000" as "200601021504": cannot parse "(other)00000" as "2006"" logger=plugin.blackcowmoo-googleanalytics-datasource t=2024-09-12T16:31:29.306909005+02:00 level=error msg="parseRow: Failed to parse time dimension" error="parsing time "(other)00000" as "200601021504": cannot parse "(other)00000" as "2006""

Grafana Version & Plugin Version 11.2.0 with 0.3.0

To Reproduce Steps to reproduce the behavior: Query as shown in the Screenshot below - Data stops loading (changing Time Dimension to something else works)

Expected behavior Graph should be shown as usual.

Screenshots

Additional context Add any other context about the problem here.

[lcc3108]

When I tested it, it was operating normally.

Can you give me more detailed information for reproduction?

[aa-matthias]

I actually cannot provide that much - worked on friday, broken today again... is there a way to fetch the raw result returned by the google api to diagnose that?

[lcc3108]

change log.level=debug grafana.ini file

https://github.com/grafana/grafana/blob/main/conf/defaults.ini#L1055

https://grafana.com/docs/grafana/latest/setup-grafana/configure-grafana/#log

[lcc3108]

@aa-matthias As a result of analyzing the data, I think there was a change in the ga api. <-- Maybe

When the amount of data increases, the rest of the values are added to the field (other).

This operates independently of the maximum row number of api requests.

Let me look more closely at the ga api policy.

In the above case, the field of the date hour must be parsed by time, but it occurs because the other cannot be time parsed due to other changes.

[lcc3108]

https://support.google.com/analytics/answer/13331684?hl=en

[aa-matthias]

thanks - sorry, i kept having this topic in my backlog but missed to reply so far.