Issue with JSON querry

1

I am working with Google Analytics in Metabase. I used the GUI to generate a querry to see users data trough the time. And got this result:

{
"ids": "ga:236059210",
"start-date": "2000daysAgo",
"end-date": "yesterday",
"metrics": "ga:users,ga:sessions,ga:pageviews",
"dimensions": "ga:yearMonth",
"sort": "ga:yearMonth",
"include-empty-rows": false,
"max-results": 10000
}

i just want to implement a date filter, to controle the time interval of the plot. I've searched a lot about it and found nothing.

2

Hi @Jessezyn
Our GA implementation does not support variables currently:
Add filter to google analytics question (native queries) · Issue #6320 · metabase/metabase · GitHub - upvote by clicking :+1: on the first post

3

And it's possible to use SUM function on a especific time interval???

4

@Jessezyn I'm not sure what you mean. You can filter by a period and sum that in the GUI.
If you want to do something in native query, then that is sent directly to GA, so if it is possible to do there, then you can do it in Metabase.