How do I create a graph with multiple data points?

[Messiah]

I'm being asked to create a graph to show number of incoming tickets vs number of tickets closed over time. I'd also like to get the totals for each column to be displayed above each bar. 

Thanks in advance.

[Uncle Rob · Accepted solution]

Something like this?

STEP 1 - Make a report that's a trend report with your preferred visualization (I picked spline)
Conditions:  Created on This year (or whatever).  Don't group.  Trend by Created (or whatever datetim)

STEP 2 - Add a dataset to the report.  This is the secret to putting two different things on one chart.

STEP 3 - The new dataset is a report.  Fill it out the same way.  You'll be constrained to Trend because that's what the "parent" report is.  Conditions of "Closed This Year" (or whatever).  No Grouping.  Trend by Closed Date.  Pick whatever visual (I used splines)

Save that and you're back to the "parent" report, except its got both splines.

Take care though: name the "Parent" report as if it does both things.

"BUT HOW DO I GET THE NUMBERS AT EACH DATA POINT?
Under the Style tab of each report.  Check Display

[Messiah]

Thanks Robert!!! This is exactly whaat I'm looking for!

[Uncle Rob]

No problem-o!
I admit I had to go back and try it for myself.
Thanks for keeping my edge sharp!

[Kristoff15]

Looks like for Trend it is only available on Spline to add a data set but not on a comlumn trend 😞