Can I plot non-timeseries data from Mongo?

[rana13deb]

This is my query. I want to plot a bar graph for se_elapsed_wall_time VS se_id

db.SessionStatus.aggregate([
{"$match": {"se_start_time": {"$gte": "$from", "$lte": "$to"}}},
{"$sort": {"se_start_time": 1}},
{"$project": { "metric": "$se_id", "value": "$se_elapsed_wall_time"}}
])

[JamesOsgood]

Grafana is designed to plot timeseries data and that's the only data the plugin supports. For producing static bar graphs as you mention, I'd use the inbuilt MongoDB Charts <https://www.mongodb.com/products/charts> which need no translation layer. James

…

On Wed, 9 Dec 2020 at 18:05, rana13deb ***@***.***> wrote: This is my query. I want to plot a bar graph for se_elapsed_wall_time VS se_id db.SessionStatus.aggregate([ {"$match": {"se_start_time": {"$gte": "$from", "$lte": "$to"}}}, {"$sort": {"se_start_time": 1}}, {"$project": { "metric": "$se_id", "value": "$se_elapsed_wall_time"}} ]) — You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub <#108>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/ABWPD6EXTJZTBEREL2ZNQNTST634XANCNFSM4UT3KQHQ> .

[rana13deb]

Hi James,

Thank you for responding to my questions,
I know that grafana is designed to plot timeseries data and it natively does not support any non-timeseries plots.

But I have come across several demos online where people have used grafana and MySQL to plot non-timeseries graphs. I was hoping to use a similar approach to this tutorial : https://medium.com/grafana-tutorials/graphing-non-time-series-sql-data-in-grafana-8a0ea8c55ee3

I understand that MongoDB Charts will natively support what I am trying to do. But due to financial constraints I cannot use MongoDB's cloud or Enterprise version, also cannot subscribe to their MongoDB Charts.

-Ranadeep

[ghost]

@rana13deb I'm also trying to plot and table non-timeseries data. I've done some digging and found a possible solution. Is this scenario relevant your issue?

The reason was that of course, I needed to use a collection that existed in my database.

db.<MY_COLLECTION_NAME>.aggregate([{"$count": "name"}])

worked.

Originally posted by @Kadrian in #89 (comment)