How to build a table in Data Query showing the number of visits per month over a year?

Once in Data Query, simply drag the metric "visits" into your data set:

Add the property "Months" or "Month number" too:

In order to cover an entire year, click the "custom period" tab, then select the option "set period", and indicate to the day, the period you wish to configure.

When you start the analysis, you will notice that the number of each month (1 to 12) is not in order, which makes the table less readable.

This is why we invite you to click on one of the arrows located on the property "month number". The arrow going up will sort the months in ascending order, the arrow going down in descending order.