Line chart by Created
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
Best Answer
-
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
Answers
-
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
-
Thank you Genevieve, really appreciate your help!
