Charts
22 results found
-
resizable sidebar
In MongoDB Charts, some of our attributes are quite long, and it's really hard to build charts on "Fields" with long names because the attribute names are truncated. Hovering over each field name is the only way to see the full name.
This adds a lot of frustration and wastes time while building charts because it forces users to hover over every truncated field for a few seconds to read the name. When there are similar attributes, this becomes unwieldy quickly.
Example:
- CompletedAppointmentGaps
- CompletedAppointmentGapsWhileMember
- CompletedAppointmentGapsWhileNonmember
- ...
All we see is:
- CompletedApp...
- CompletedApp...
- CompletedApp...
- ...Current workaround:…
2 votes -
Add database name to the "Select Data Source" dialog
Hey, when adding a new chart the "Select Data Source" dialog pops-up. This dialog shows some of the collections I used recently. However, it only displays the collection name, not the database name. If I have a deployment with multiple databases containing the same collection names, I can not distinguish which collection belongs to which database.
Please add the database name. Something like "database-name"/"collection-name".Best regards,
Max5 votes -
Aggregation function name changes should not break user charts
Ideally users shouldn't see broken charts if it's just a function name change. To make it transparent to users, there should be some links between what's displayed on UI and the real function names. One example is that changes in CHARTS-4755 broke our charts: changing aggregation function name from "stdev" to "standard deviation" shouldn't require every user who uses that function to fix their charts.
2 votesThis has been fixed with release 1.31
-
boolean aggregation
Right now you can only count/distinct boolean types. It would be nice if you could count true or false only values.
3 votesSupported using “Count by Value”
-
Enable $lookup for charts
Our team needs to get data from a separate collection to add to a chart. It is possible to add the field to our collection in the aggregation pipeline builder, however $lookup is unavailable for use in Charts.
11 votesThe latest update of Charts allows you to add Lookup Fields from the chart builder UI.
-
Field value label alias/override
When building a chart it is currently to provide a label override. E.G. change the label from 'document.subdocument.field' to 'mylabel. There should also be an option to provide value aliases/label overrides; E.G. be able to alias an int field with value 0 to ''red". Imagine a document field "color" of type int, where int defines a color used by a client. In the charts these values 0/1/2/3 mean little as they do not describe the value; being able to provide an alias of 'red/blue/green/yellow' would make it more meaningful
2 votesThis can be done with String Binning. The feature lets you put 1 or more strings into a category and assign a new name. If the original values are numbers, you will need to convert the type to a string for this to work.
-
Move dashboards between Atlas projects and organizations
I would like to be able to move dashboards between organizations and projects. This will enable flexibility on any future organizational changes. Enable the ability to export dashboards and import them into new billing accounts or projects would be helpful. Or you enable sharing between organizations and projects, that will allow then users to convert the shared dashboard into it's own version. That would work as well.
9 votesThis is now possible, using the dashboard import/export functionality.
-
Ability to hide a chart title and release the space it occupies
I'd like to be able to create/embed charts without titles. I can currently set the title to a simple space character but the space at the top remains blank/taken.
3 votes -
Improve management of labels in charts
You can see on this snapshot the issues :
- some labels overlap when they are to close.
- at the right-top of the chart, the labels' value are truncated
- last thing, the circle is cut at the bottom
Improving the graph could be very helpful to use MongoDB Charts a little more.
1 vote -
Filters for embedded charts
While embedding it would be nice to have a filter , like [age = 40] to get all records whose age are above 40
Ex: <iframe style="background: #FFFFFF;border: none;border-radius: 2px;box-shadow: 0 2px 10px 0 rgba(70, 76, 79, .2);" width="640" height="480" src="charts?id=6e45e31f-34a6-444d-b613-b3706f0f46ec&``age=40``&theme=light"></iframe>
1 voteThis is already possible! See https://docs.mongodb.com/charts/saas/embedded-chart-options/#filter-data-on-embedded-charts
-
sort for data table via query
Hi,
Current default sort for text data table charts is a little un-intuitive (at least for me). All other charts appear to respect the sort stage in the aggregation pipeline. The data table chart has a different mechanism where the user has to explicitly click on the header to define the default sort. This is counter intuitive if there is already a sort stage in the aggregation pipeline that can be interpreted as the default sort.
I think it might make things more clear if either:
a) Default sort ALWAYS in the sort stage of the aggregation
b) Flag a…
1 voteWe’ve reworked how we do sorting, and the sort for all chart types (including tables) now happens within the aggregation pipeline.
-
Dragging groups in text chart has a bug with arrays
I am creating a chart and moving the order of data elements that are part of a group. When doing this, i am noticing that data elements with array parameters are not moving correctly. I took a screenshot see attached. The Naics code data element is not an array. Status is an array. Somehow the array parameters moved from status to NAICS while I am making changes.
2 votes -
Fonts size
If the charts generated are meant to be used directly (e.g.without editing them in third party graphic applications) like embebed in webpages, then we need to be able to change at least the size of the fonts.
p.s. no rush to implement the selection of font style, just size for now would be great. Thanks
2 votesThis is now built, will be released later in September 2020.
-
Show trendlines in charts
It would be great to add support for trendlines in column and line charts.
For example, if I have a chart for daily/weekly/monthly active users, it would be very helpful to have a trendline to show if the active users are increasing or decreasing.
11 votes -
Cumulative trends over time
By placing a time variable on the X axis, we can create a graph of records created for each day/week/month/etc. It would be very helpful to also have the ability to plot cumulative totals over time; in other words, have the point (X, Y) represent the fact that at time X, Y total records existed in the collection.
7 votes -
Filtering by fields in an Array of Objects
Currently if you have an array of objects you cannot filter by the values of those objects. Charts concatenates all of the values in that field together.
For instance, if the structure looks like this:
{ owners:
[
{"name": "Bob Smith",
{"address": 123 Main St.},
{"name": "Janet Smith",
{"address": 321 Other St.}
]
}The available filter for name would be "Bob SmithJanet Smith", which returns no results.
2 votesThis is now fixed in the latest Atlas release, and will be included in the next on-prem release in December 2019.
-
Allow charts to have reference field data in them
Adding the ability to access data in reference fields to other collections and adding that data to a chart would be very helpful. For example, a collection called "delivery" has a reference field to a "client" this client has a string "title" field. It would be very useful to be able to add the client's "title" to the chart instead of just their id.
0 votes$lookup is now available in data source pipelines in Atlas and in the 19.09 on-prem release.
-
Toggle chart legend visibility
Being able to toggle the visibility of the chart legends would be nice for use-cases where they aren't necessary.
3 votes -
Ability to do a math expression on Text -> Number
Let's say you are sale mobiles and in database you have something like:
"Model" | "Quantity" | "Price/Item"
And you want to see all your sales, you must provide in a Text -> Number the following expression: "Quantity" * "Price/Item".
Or you have another database as backup data before transformations and you want to compare counts between databases.
3 votes -
Conditional formatting
After you define a KPI, will be awesome if you can color them:
By expressions:
Red if number is less than 33.
Yellow if number is grater than 34 and less then 50.
Green if number is grater than 51.By scale:
A gradient from Red to Green (with yellow in the middle) and values from 0 to 100.Static:
Just color this KPI number purple.
NOTE: Colors and values must be configured by user.
48 votesThis is done! Rolling out to all Charts customers this week.
- Don't see your idea?