A secondary axis chart: How to add a secondary axis in Tableau?
365 Data Science
👉 Download Our Free Data Science Career Guide:✅https://bit.ly/3464fmx
👉 Sign up for Our Complete Data Science Training:✅https://bit.ly/31Wg2Ro
We are ready to start with the first secondary axis chart that will be inserted in our dashboard.
Let’s add the date of review information in to columns. And this is where we will be able to see the timing of purchases and reviews.
As usual, we are interested in a breakdown by months, so I’ll select “month”. The workspace area shows us that review dates range from February 2017 to February 2018, which is what we expected to see.
Let’s insert some data, shall we?
First, I’ll add the number of ratings, using the “Count” function. Everything’s fine and we have data for December 2017, so we can forget about that problem.
According to our initial plan, this will be a chart that shows the number of reviews and the average review score per month displayed on a secondary axis.
So, I’ll add the rating field to rows for the second time, but this time we want the average of these numbers, and we would like to create a dual axis.
Obviously, we will have to fine tune the axis scale a bit, as right now the chart doesn’t show match. I’ll simply double-click and choose a fixed range starting from 8 and going all the way up to 10 (which is the maximum review score we can have).
Let’s edit its axis. Again, that’s something, which is quite easy to do. We have to double-click on a specific axis and type the axis title we would like to have.
Follow us on YouTube: https://www.youtube.com/c/365DataScience
Connect with us on our social media platforms: Website: https://bit.ly/2V2mkN6 Facebook: https://www.facebook.com/365datascience Instagram: https://www.instagram.com/365datascience Q&A Hub: https://365datascience.com/qa-hub/ LinkedIn: https://www.linkedin.com/company/365datascience
Prepare yourself for a career in data science with our comprehensive program: https://bit.ly/2XuUwTf
Get in touch about the training at: support@365datascience.com
Comment, like, share, and subscribe! We will be happy to hear from you and will get back to you! #axis #chart #tableau #spreadsheets #statistics #datascience #365datascience
6713057 Bytes