How to use series for x-axis ? about mongodb-grafana

[yinsimei]

Hi, I also notice that you've added the support for 'table' in a previous commit but it seems that my queries are always executed via "getTimeseriesResults" and never fall into "getTableResult".

I guess there may be sth that I miss to make it work properly?

[JamesOsgood]

Hi, You need to change the dropdown in Grafana when defining the query from 'timeserie' to 'table' James

…

On Wed, 9 Jan 2019 at 14:50, Simei YIN ***@***.***> wrote: Hi, I also notice that you've added the support for 'table' in a previous commit but it seems that my queries are always executed via "getTimeseriesResults" and never fall into "getTableResult". I guess there may be sth that I miss to make it work properly? — You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub <#36 (comment)>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AGzx-IP7NFqwV_C4_0h2YomumFGCJkHGks5vBgGfgaJpZM4ZYZJA> .

[yinsimei]

Thanks a lot for your reply. I tried to choose 'table' for the query drop down and use 'series' for the graph.

The graph I get shows only the last result. Do I still miss something here?

Here is my query:
db.analytic_events.aggregate([
{"$match": {
"event_time": { "$gte": "$from", "$lte": "$to" },
"event_type": "CampBakingStats_1.0"
}},
{"$group": {
"_id": { "changelist" : "$custom_payload.codeCL" },
"campBakingTotalDuration" : {"$sum": "$custom_payload.campBakingTotalDuration" },
"max_event_time": { "$max": "$event_time" }
}},
{"$project": {
"name" : "$_id.changelist",
"value" : "$campBakingTotalDuration",
"ts" : "$max_event_time",
"_id": 0
}},
{"$sort":
{ "ts": 1 }
}
])

What I'm trying to do is to draw campBakingTotalDuration trend by its change list number.

[yinsimei]

Hi, it turns out to be our server plugin version is not updated.

The problem is fixed now. Thanks.