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

  • Kelly Moore
    Kelly Moore ✭✭✭✭✭✭

    Hey @Anne-Solene Monrouzeau

    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