.svg)
Bar Chart Combos in QuickSight Visuals | West Loop Strategy
Master bar chart combos in QuickSight with West Loop Strategy. Combine datasets creatively to present complex insights in a clear, impactful way.
Hello everyone, my name is Duncan. I'm a data engineer with West Loop Strategy, an AWS partner. Today for our series on QuickSight visuals, I'm going to be covering bar chart combos.
Stacked bar chart combos have a lot of visual elements that can make them pretty tricky to use appropriately in your dashboard. But all of those different elements are also what's going to make them a really powerful tool to show your data graphically in your dashboard. So if you haven't yet, I really recommend you watch our previous video on bar charts as a lot of the same concepts are going to apply here.
First and foremost, there are two styles of bar chart combos: stacked and clustered. This is simply how you decide to represent the data. My opinion is, if you have a small grouping, say three main business segments, you're safe to use a cluster bar chart. If you're using more than three, I would consider using a stack bar chart and relying more on the tool tip.
Another small tip here, really try to keep the amount of dimensions to a minimum if possible, or at least keep the scope of your x -axis narrow so that you're really not overcrowding the visual and making it harder to understand the information you're trying to communicate from this visual, right? We don't want to create a scenario where we're trying to display the data graphically, but in the process we overdo it and now the waters are sort of muddied and we don't really understand what's trying to be communicated.
Now the real way to discern the normal bar chart from the bar chart combos is that you're able to include multiple lines that are not static like a reference line and can be calculated fields from your dataset or just regular fields from your dataset.
For example, here I have a bar chart combo that is grouped by business segment and the x-axis shows years from our order date field. For the value field well, we can make it quantity of sales made, so now I can add two lines. One being the total sum of sales and the other being profit. I'm going to make sure to update those to currency in my field well so that it makes sense when we read it. So now what I'm able to show is how many units of my products were sold in each business segment per year and with my lines, what sales and what profit looked like to determine if I have seen growth in my overall business. So you're still able to add the reference lines that we had in the bar chart.
I recommend taking some time to add these data labels into your tooltip to make sure that you're just making sure that you are being diligent with your y-axis. Since you're adding lines, you're going to have the left and the right y-axis. So you're going to need to make sure that those values make sense for your reader while they're looking at it. And this is where going into the format visual menu and going and making sure that you are titling them appropriately.
Thanks for joining us today. To find out more about how we help our clients use AWS cloud technologies or to schedule your own QuickSight training session, check out our website or follow us on LinkedIn.
You may also like
F.A.Q.
Find answers to common questions about cloud migrations, Amazon Web Services (AWS) and working with West Loop Strategy.
West Loop Strategy’s mission is to combine AWS technology with deep expertise to deliver best-in-class solutions to business problems, not technology for its own sake. That means efficient, cost-effective solutions that add value to your business.
Cloud migration is the process of moving your organization's data, applications, and infrastructure from on-premises servers to the cloud. If that sounds complicated or like a lot of work, consider the benefits. Moving to the cloud allows businesses to shift from large upfront capital expenditures (CapEx) on hardware and infrastructure to operational expenses (OpEx) that can be deducted from taxable income. This pay-as-you-go model improves cash flow, reduces financial risk, and provides greater flexibility to scale IT resources as needed. If you set it up right - you can stop running inflexible workloads that are "always on" and instead take advantage of native solutions that scale up and down based on your actual usage.
Our team of AWS certified Solutions Architects at West Loop Strategy is here to guide you through this transition, ensuring it's tailored to your business and its unique requirements. From initial assessment to seamless execution, we'll help you navigate the complexities of cloud migration with confidence.
AWS is the clear leader among the public cloud providers. They have the most advanced features & products, the highest uptime, the lowest prices, and the best customer support. Whether you are moving a solution from on-prem to the cloud, modernizing an old stack of legacy products, changing business intelligence platforms, or leaving Azure/GCP, AWS has a solution for you.
Achieving Advanced Tier Status within the AWS Partner Network (APN) is no easy feat. It takes a years-long track record of successful customer projects to even qualify to apply. West Loop Strategy achieved Advanced Tier status in 2022 and has earned more AWS Service Delivery designations than any other Advanced Tier partner along the way. For customers, this means that if you work with West Loop Strategy, you’re working with a dedicated partner trusted by AWS themselves to deliver work that demonstrates the AWS pillars of success – operational excellence, security, reliability, performance and cost efficiency.
West Loop Strategy is an Advanced Tier AWS Consulting Partner specializing in end-to-end cloud solutions. Our expertise spans application development and modernization, cloud migration, AI/ML and analytics, cloud security, and DevOps. Committed to delivering scalable, secure, and high-quality solutions, West Loop Strategy helps organizations make the most of the cloud on AWS.