Graphs and Charts
Hi,
I am fairly new with Graphs and Charts in Smartsheet. I am trying to create a monthly operating report with different graphs. An example is a KPI trend month by month. I am stuck at the first step: I have the raw data by day. I pulled them in a report and don't know how to average by month to create the graph by month.
Any idea?
Thanks,
Anne-Solene
Answers
-
One approach would be to add a Text/Number helper column [Month Number] to your data sheet so you could then group by Month Numbers in reports or use in other formulas
In the helper column, add this formula
=IFERROR(MONTH([your date column]@row),0)
The IFERROR is there to prevent algebraic formulas (like average) from having errors if the MONTH function had an error.
If you need further help, come back and let us know what step you're on. The community is always happy to help.
Cheers
Categories
- All Categories
- 14 Welcome to the Community
- 10.8K Get Help
- 65 Global Discussions
- 69 Industry Talk
- 385 Announcements
- 3.6K Ideas & Feature Requests
- 56 Brandfolder
- 125 Just for fun
- 50 Community Job Board
- 464 Show & Tell
- 40 Member Spotlight
- 44 Power Your Process
- 28 Sponsor X
- 234 Events
- 7.3K Forum Archives