Charts
22 results found
-
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.
-
Ability to Bin Dates by Week on Charts
Th binning feature is fantastic! My only issue is that there isn't the ability to bin weekly. Our data is across Monday to Friday so every weekend bring a drop in our graph. Please add this feature !
13 votes -
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.
-
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 -
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.
-
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 -
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 -
Allow to add custom labels on axes values
Some of data is stored as numerical value but later is changed into text by enums. It would be useful to, add key value pair, so in a chart instead of 1 on the axis, there would be text field e.g. 'accepted users'
4 votesThis can now be accomplished with String Binning. Alternatively if the enums reference values in another collection, you can use the new Lookup Fields feature to get access to the string codes for each value.
-
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”
-
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 -
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 -
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 -
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 -
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
-
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.
-
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.
-
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.
-
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
- Don't see your idea?