How do I...?

Year over year charts

I want to group items by month, but have different lines for different years. Is this possible?

1 vote
Vote
Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)
You have left! (?) (thinking…)
Anonymous shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

1 comment

Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)
Submitting...
  • John McGarvey commented  ·   ·  Flag as inappropriate

    I have a similar chart that works nicely for tracking headcount, but its a bar chart instead of a line chart. I'm sure it would work the same if you chose a different chart style.

    In your view, you will need at least two fields: Date field and Type field (whatever you are measuring).

    On the Chart Format tab, place the Date field and Type field in the horizontal (x-axis) with the date field being first. Click the checkbox on both to Group By.
    On the Vertical (y-axis), place the Type field and measure with COUNT.

Feedback and Knowledge Base