Line chart by Created

Lara Lehnerz

Hello,

I am looking to add a line chart to my dashboard that shows how many projects have been opened by month for the past year. Any suggestions on how to accomplish this? I was also looking at the Work Insights new feature the Time Series widget but Created is not a column option.

Any assistance will be greatly appreciated.

Thanks,

Lara

Genevieve P.

Hi @Lara Lehnerz

The way I would do this is to add a helper column in the sheet(s) that you're looking to count. This column would extract the Month from the Created column like so:

=MONTH(Created@row)

Then create a Report with all of the sheets/rows and Group it by this Month column. Once you have it Grouped by Month you can use the Summarize function in the Report to COUNT how many rows are in each month. See: Redesigned Reports with Grouping and Summary Functions

Then you can use this Grouping/Summary line to automatically create a chart in your Dashboard!

Let me know if this makes sense and works for you.

Cheers,

Genevieve

Genevieve P.

Hi @Lara Lehnerz

The way I would do this is to add a helper column in the sheet(s) that you're looking to count. This column would extract the Month from the Created column like so:

=MONTH(Created@row)

Then create a Report with all of the sheets/rows and Group it by this Month column. Once you have it Grouped by Month you can use the Summarize function in the Report to COUNT how many rows are in each month. See: Redesigned Reports with Grouping and Summary Functions

Then you can use this Grouping/Summary line to automatically create a chart in your Dashboard!

Let me know if this makes sense and works for you.

Cheers,

Genevieve

Lara Lehnerz

https://community.smartsheet.com/discussion/comment/314584#Comment_314584

Thank you Genevieve, really appreciate your help!