I have an atlas cluster and I connected charts to it. I have zero experience with data visualizations (or building dashboards) and I’d like to chart the number of documents in my database over time. E.g., if in January 10 documents were created, and in February another 10 were created, then the chart should display 10 for January and 20 for February.
I know the _id field has information when the document was created, but I have no idea how to display it in the chart. So far, all I have is document count using _id in the y-axis.
What is the best way to accomplish what I’m trying to do? Is using a bar chart the best visualization to use in this situation?
Also, for some reason whenever I’m creating a chart, I get alerts saying “Query Targeting: Scanned Objects / Returned has gone above 1000”. Is there any way to stop this for happening?
You can use the exact same steps above but choose “Date of the Month” for the binning period.
Or, if you just want to know how many documents were added in the last 24 hours, you could choose a number chart, encode count(_id) in the value channel, and add a date filter to include just the last 24 hours.