We're excited to announce Query Library for Atlas Charts!
Getting started with Charts is already fast, easy, and powerful. With Query Library, we have made it even easier to build charts with queries. When you log in to Charts, there are a few essential steps to visualize your data. You need to add a data source, you need to create a dashboard, and from there you can create a chart.
The Charts UI provides a user-friendly, drag and drop interface for building charts. But today, more than a quarter of users also leverage the MongoDB Query Language (MQL) to write custom queries when creating charts.
To demonstrate a simple example of what using a query looks like, we’ll use the sample movie data we make available to every Charts user through our sample dashboard. Below we are using MQL to filter for only movies in the comedy genre:
Rather than dragging the genre field into this chart and adding a filter, with a little bit of MQL knowledge, a query can speed up the chart-building workflow. As you can see above, users can now also easily save this newly created query or load a previously saved query.
Query Library builds on Charts’ existing support for queries and aggregation pipelines and makes it even more powerful to leverage MQL in building charts. Rather than recreating queries across multiple dashboards, manually sharing with team members, copying and pasting, or otherwise retrieving queries written in the past, Charts users can either save any new query for later use or load a saved query directly from the chart builder. Here’s what it looks like to load a saved query:
Best of all, these saved queries are available across your team. Any saved query is available to all members of your project. Check out our documentation for more details on saving, loading, and managing queries in Charts.
Simplifying visualization of your Atlas data
The goal of Atlas Charts is to create a data visualization experience native to MongoDB Atlas customers. It’s a quick, straightforward, and powerful tool to help you make business decisions and perform analytics on your applications. Capabilities like Query Library will help to speed up your data visualization workflow to get you quickly in and out of your data and back to what matters for your team.
To get started with Query Library today, navigate to the chart builder in any of your dashboards, simply write a query, and save it for later use!
New to Atlas Charts? Get started today by logging into or signing up for MongoDB Atlas, deploying or selecting a cluster, and activating Charts for free.
Honoring Black History Month
As Black History Month comes to an end, we reflect on and honor the history, legacies, achievements, and contributions of the Black community in the United States. Hear from three members of MongoDB’s affinity group TUPOC (the Underrepresented People of Color) to learn more about what this month means to them, and how they are honoring Black history all year round. Bryant McCombs , Manager, Customer Success I manage the Customer Success team for New England, Eastern Canada, & the Mid-Atlantic. My team is responsible for making sure that our customers have all of the resources they need to be successful in leveraging MongoDB. I’ve had a very non-linear path to tech, starting my professional career as a performance coach at an athletic training facility. I then decided to transition into financial sales consulting, but quickly realized that it was not the career path for me. So, I decided to drop everything I was doing and move to rural Australia. There, I began working as an irrigation manager on a farm the size of Manhattan. After my brief stint as a farmer, I decided to get back into coaching and landed a role as volunteer assistant track coach at the University of Pennsylvania. During my time in Philly, I also held a number of part-time jobs and began attending my first tech meetups. It was when I attended Philly Tech Week that I finally realized tech was the place for me. Several months later, I landed my first role at a startup software development consultancy as an operations manager. I was the second employee and I knew next to nothing about software development. Over the course of two years, I helped grow the team to over 60 employees while managing everything from the company accounting, human resources, account management, and more. Those two years were probably the most valuable years of my professional career in tech, and I haven’t looked back since. When I was being recruited to work at MongoDB, the values that prioritized intellectual honesty and psychological safety were very enticing to me, and I’ve found them to be embodied values throughout my tenure. MongoDB has had a huge impact on my career within a very short amount of time. In the year and ten months that I’ve been here, I’ve been promoted twice: first as an individual contributor and then to a manager role. I enjoy working at MongoDB because we are solving some pretty huge challenges every day and are in a period of consistent and rapid growth. In college, I was a history major with a focus on the African Diaspora. I remember being amazed the first time I learned about the impact various African traditions had on the culture of a wide range of places such as Brazil, the Bahamas, and the U.S. When I think about the middle passage and the incredibly harsh conditions that my ancestors endured reaching America, I can’t help but think that it’s a miracle I am even here today. Learning anything about the lives of my enslaved ancestors has never been an easy task, with no equivalent of Ellis or Angel Island and poorly maintained slave papers. However, after extensive research, I found some of the names and photos of my ancestors that were enslaved in Mississippi and North Carolina. This process helped me reclaim some of my family’s history and feel more connected to my lineage. When a lot of people think of Black history they think of slavery or black and white footage of Martin Luther King Jr. marching on the capital. However, to me, it’s a lot more than that. My parents were teenagers before the Civil Rights Act was passed and adults by the time it was widely adopted. They experienced most of their childhood and a significant part of their adulthood without basic human rights. They struggled with racist institutions and setbacks based purely on the color of their skin, and as an unintended consequence of their experience, they became stronger and more resilient individuals. I like to think that they’ve passed that strength and resilience down to me, and as I begin to start my own family, I hope that I can pass it down to my children. When I think of what Black History Month means to me, I think that Black history is unable to be contained by a month and that Black history is being made and should be celebrated every day. Kayla Warner , Internal Communications Manager As a child in Alabama, Black History month was recognized and celebrated wherever I went– school, church, and especially at home. From rote memorization of Black History facts like Madame C.J. Walker being the first female millionaire, or memorizing lines for the latest Black History month play at church, I was fully bought into celebrating the achievements of Black people. However, I never gave much thought to why it was important to recognize these achievements. As I got older, I learned about the atrocities of slavery and segregation; met people who protested and participated in the Civil Rights Movement; and realized that my father was born two weeks after Bloody Sunday. It was now clear to me that Black History doesn’t live in the past– it affects us now and shapes our future. Kayla and her father As I came of age, racial identity and consciousness became more and more important to me. But to be honest, it was less by choice and exploration– but by necessity. The deaths of Trayvon Martin, Jordan Davis, and Michael Brown made a seismic impact on my life because they were all my age. Race became the biggest conversation in my life. I had to interrogate my held beliefs and values, and define what being Black in America meant to me– when so much of Blackness in America was becoming synonymous with pain and strife. I had to forge my own identity, so I decided to do something radical. I chose joy. My definition of Blackness became one of light, celebration, laughter, and most importantly, hope. Black History Month has become a time to celebrate customs and traditions, to rejoice with levity and laughter, and to embrace my community. That communal aspect is key, especially within the Black community and other communities of color across the country. That is why I am so thankful that there is space for community at MongoDB through affinity groups like TUPOC. Onboarding as a remote employee is never an easy feat, but having a resource like TUPOC made me feel less alone and reminded me of the importance of fellowship. Beyond TUPOC, the Corporate Communications team has made me feel at home and respected as a member of the team. MongoDB’s value “embrace the power of difference” made me want to join and seeing it in action from the executive team to my peers has confirmed that I made the right choice. Courtney Turner , Campus Recruiter Black History Month is not just 28 or 29 days to reflect on the countless contributions of African American culture to society, nor is it a month to make a one-time purchase from Black businesses. Black History Month is truly a lifestyle for me. Growing up in a small town in North Carolina, I can remember my family teaching me about prominent figures in Black history like Medgar Evers, Dr. Shirley Jackson, and Carter G. Woodson. They also taught me about the harsh realities of Black history like the tragic murder of Emmett Till, the 16th Street Baptist Church bombing, and the lynching of Joe Code. As a child, my mother and late aunt encouraged me to be active in the National Association for the Advancement of Colored People, where I hosted annual Freedom banquets, sang the Negro National Anthem, and was even recognized for my contributions to the community and the state. Understanding that Historically Black Colleges and Universities (HBCUs) were created when admission wasn't granted to African Americans, I knew it was imperative that I attend an HBCU. Starting my college journey at Florida Agricultural and Mechanical University and completing my collegiate experience at North Carolina Agricultural and Technical State University, I was surrounded by black excellence and unity, but most importantly I saw the hard work HBCU students put forth to excel even when not given the same opportunities and funding as other students. This is where my passion for inclusion and advocacy arises from, leading to my passion for starting a career in recruiting. Despite the stereotypes and labels placed on African American males, my mother always reminded my two brothers and me that we were kings. This led me to run and serve in the role of Mister Black North Carolina. My platform was Reconstructing the Black Male Image, and after serving as Mister Black North Carolina, I decided to launch my own mentoring program “Dapper Distinguished Men Society”. Courtney and his mother Today, we reflect not only on Black history but all parts of the Black experience. Black history represents the tears that slaves shed in the stillness of the night while working to escape into what they thought would be freedom. Black history contains the fear that Black families felt driving through sundown towns while using Green Books for guidance, it's the feeling of not being equal, not being heard, not being appreciated, and not feeling safe enough to jog in your neighborhood, visit the local store, and relax in the comfort of your own home. It is the realization that we have progressed but have so far to go to truly be counted equal. As we reflect on Black history and glimpse into our Black future, we recognize that no matter how many times we are knocked down, we are never knocked out. Interested in joining MongoDB? We have several open roles on our teams across the globe and would love for you to transform your career with us!
How MongoDB Helps Reduce Data Fragmentation for More Connected Healthcare Data
Many differences exist across healthcare systems around the globe, but there is one unfortunate similarity: fragmentation. Fragmentation is a consequence of the inability of various healthcare organizations (both public and private) to communicate with each other or to do so in a timely or consistent manner, and it can have a dramatic impact on patient and population well-being. Interoperability and communication A patient can visit a specialist for a specific condition and the family doctor for regular checkups, perhaps even on the same day. But how can both doctors make appropriate decisions if patient data is not shared between them? Fragmented healthcare delivery, as described in this scenario, also leads to data fragmentation. Such data fragmentation can cause misdiagnosis and services duplication. It can also lead to billing issues, fraud, and more, causing preventable harm and representing a massive economic burden for healthcare systems worldwide. To improve healthcare fragmentation, we need truly interoperable health data. The longitudinal patient record A longitudinal patient record (LPR) is a full, life-long view of a patient’s healthcare history and the care they’ve received. It’s an electronic snapshot of every interaction patients have, regardless of provider and service. Ideally, this record can be shared across any or all entities within a country’s healthcare system. The LPR represents a step beyond the electronic health record, extending past a specific healthcare network to a regional or national level. It’s critical that LPRs use the same data format and structure to guarantee the ability of healthcare providers to easily and quickly interact with them. Data standards for LPRs are key to interoperability and can help address healthcare fragmentation, which, in turn, can help save lives by improving care. FHIR Fast Healthcare Interoperability Resources (FHIR) is a commonly used schema that comprises a set of API and data standards for exchanging healthcare data. FHIR enables semantic interoperability to allow effective communication between independent healthcare institutions and essentially defines “how healthcare information can be exchanged between different computer systems regardless of how it is stored in those systems” ( ONC Fact Sheet, “What is FHIR?” ). FHIR aims to solve the fragmentation problem of the healthcare system by directly attacking the root of the problem: miscommunication. As is the case for many other modern communication standards (for example, ISO 20022 for finance ), FHIR builds its REST API from a JSON schema. This foundation is convenient, considering most modern applications are built with object-oriented programming languages that have JSON as the standard file and data interchange format. This approach also makes it easier for developers to build applications, which is perhaps the most important point: The future of healthcare delivery may increasingly depend on the creation of applications that will transform how patients and providers interact with healthcare systems for the better. MongoDB: FHIR and healthcare app-ification MongoDB is a document database and is therefore a natural fit for building FHIR applications. With JSON as the foundation of the MongoDB document model developers can easily store and retrieve data from their FHIR APIs to and from the database, with no translation or change of format needed. In fact, organizations can adopt FHIR resources as the basis of a new, canonical data model that existing internal systems can begin to shift and conform to. One example is the Exafluence FHIR API , which is built on top of MongoDB. Exafluence's API allows for real-time data interchange by leveraging Apache Kafka and Spark, in either an on-premise or multi-cloud deployment. Software teams leveraging the Exafluence solutino have experienced velocity increases of their FHIR interoperability projects by 40% to 60% . MongoDB's tool set can develop value-add business solutions on the FHIR-native dataset — without ETL. Beyond FHIR , the trend toward healthcare app-ification (i.e., the increasing use of applications in healthcare) clashes with pervasive legacy architectures, which typically are not optimized for the developer experience. Because of this reliance on legacy architectures, modernization or transformation initiatives often fail to take hold or are postponed as companies perceive the risks to be too high and the return on investment is not evident. It doesn’t have to be this way, however. MongoDB’s industry-proven iterative approach to modernization reduces the risk of application and infrastructure migration and unlocks developer productivity and innovation. Interoperable, modern healthcare applications can now be built in a developer-friendly environment, with all the benefits expected from traditional databases (i.e., ACID transactions, expressive query language, and enterprise-grade security). MongoDB provides the freedom for solutions to be deployed anywhere (e.g., on-premises, multi-cloud), providing a major advantage for healthcare organizations, which typically have multi-environment deployments. Healthcare and the cloud Digital healthcare will accelerate the adoption of cloud technologies within the industry, enabling innovation at scale and unlocking billions of dollars in value. Healthcare organizations, however, have so far been reluctant to move workloads to the cloud, mostly because of data privacy and security concerns. To support such cloud adoption initiatives, MongoDB Atlas offers a unique multi-cloud data platform , integrating MongoDB in a fully managed environment with enterprise-grade security measures and data encryption capabilities. MongoDB Atlas is HIPPA-ready and a key facilitator for GDPR compliance. A holistic view of patient care Interoperable healthcare records and communication standards will make longitudinal patient records possible by providing a much-sought-after holistic view of the patient, helping to fix healthcare fragmentation. Many challenges still exist, including transforming legacy infrastructures into modern, flexible data platforms that can adapt to the exponential changes happening in the healthcare industry. MongoDB provides a developer data platform designed to unlock developer productivity and ultimately giving healthcare organizations the power to focus on what matters most: the patient. Learn more about how MongoDB supports healthcare organizations .