Weekly Data Report Showing Trends by Month
We export data weekly showing the number of registrations for a variety of products. I have the data in a line graph showing the trend over time but the graph doesn't display the value of the date. Ideally, I would like to simply display the value of each month on my dashboard while retaining the data that is updated weekly.
Is there a formula I can use to display the data monthly or even compare month over month data trends based on the way my sheet is set up? Any assistance is appreciated!
Help Article Resources
Check out the Formula Handbook template!