Skip to main content

Filter the same month's income over multiple years.


1 comment

  • Tiffanie Staver
    Justin Mauldin commented  ·  
    Hi Stacey,

    Thank you for reaching out to us with your question.

    You can accomplish this by adding two fields to your table that is going to pull the month number of the "Arrival" date and the year of your "Arrival." Then you will group by that month number and year in your graph view.

    For example, January would be month number 1 and all "Arrivals" that happened in January would get labeled with the number "1" in the new field you create. Then once you group by the new month number and year fields, you would see 1-12 on the x-axis your chart and 5 colored lines (each representing a different year) charted on the graph.

    To set this up, you would first add a calculated number field to your table. This will become your month number and you will put in the formula: date({Arrival}).

    Next, you will setup a calculated text field to your table. This will become your arrival year and you will put in the formula: year({Arrival}).

    Then you will need to add these new fields to your view and change your horizontal value settings to be grouped first by the new month number field you added and then also grouped by the new arrival year field. You will keep the vertical value the same as you had before with summing the "Commission."

    Just let us know if you have any further questions.

    Thank you,



Please sign in to leave a comment.

Powered by Zendesk