Ok.
Excellent!
We are ready to start with the first chart that will be inserted in our dashboard.
Therefore, I’ll rename the worksheet’s name to Chart 1, ok?
Good.
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.
Excellent!
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).
However, right now, the two charts overlap in a strange way and we are unable to see
their trends.
So, I’ll increase the size of the axis to 12, and will change the fill color of both
variables – number of ratings and average ratings.
That’s easy to do.
I need to select one of the two variables and then click on the color button under “Marks”.
Once we’ve opened the “Edit colors” menu, we can choose which variable’s color
we would like to change to a color we like better.
I like yellow and blue.
Awesome  I am not really a fan of opacity, which adds
a transparency effect and sort of mixes the colors we have in our chart.
Therefore, I’ll opt for 100% opacity for both variables.
See?
The chart looks nicer.
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.
I’ll change “count of rating” to “number of ratings”, “month of review date”
to “month”, and I believe average rating doesn’t need to be changed.
Very good  This is our first chart.
Does it give us any meaningful information?
Well, yes, I believe it does.
First off, we can see that the number of reviews left by people has been increasing, which
is pretty great.
The average review score is almost 9 and sometimes even higher than 9, which is a pretty high
score (but should be interpreted and compared with the rest of the market).
Moreover, we don’t see a dependence between number of reviews and average ratings, which
means that average review scores are not influenced by the number of people leaving reviews.
All of this is quite interesting.
Let’s keep up the good work we have been doing in our next lesson, when we will create
the second chart for our dashboard.
Thanks for watching!