Weekly Average Graphed by Month
I am looking to graph sales data of the weekly average of items sold per month, not sure of the best way to accomplish this. The current dataset that I am working with is essential a transaction detail dataset coming out of NetSuite Analytics Connect, my query references several different tables but I have joined them all together.
I have attached an image of the graph that was generated from an excel sheet that we are looking to recreate.
Best Answers

Keep in mind this is not a fully fleshed out solution, but does work if you are just looking at general trends. Depends how exact you want/need to be in your weekly average. But one possible solution is to graph by month, and then have a beast mode like this.
SUM(
value
)*12/52This is likely better than just dividing by 4.
You could also adjust this as needed to dial in how you want to approach weekly average.
SUM(value)12/365*7
Then just set it up in a stacked bar chart with your group as the series and weekly_average as the yaxis. It's important to note that this approach isn't super flexible. You'll need to always graph by month, or adjust your beast mode. If you wanted a more robust option, that is possible, but would use a date dimension table and ETL.
David Cunningham
** Was this post helpful? Click Agree π, Like ποΈ, or Awesome β€οΈ below **
** Did this solve your problem? Accept it as a solution! βοΈ**1 
Here's what I came up with on how to solve this:
If I solved your problem, please select "yes" above
1
Answers

Keep in mind this is not a fully fleshed out solution, but does work if you are just looking at general trends. Depends how exact you want/need to be in your weekly average. But one possible solution is to graph by month, and then have a beast mode like this.
SUM(
value
)*12/52This is likely better than just dividing by 4.
You could also adjust this as needed to dial in how you want to approach weekly average.
SUM(value)12/365*7
Then just set it up in a stacked bar chart with your group as the series and weekly_average as the yaxis. It's important to note that this approach isn't super flexible. You'll need to always graph by month, or adjust your beast mode. If you wanted a more robust option, that is possible, but would use a date dimension table and ETL.
David Cunningham
** Was this post helpful? Click Agree π, Like ποΈ, or Awesome β€οΈ below **
** Did this solve your problem? Accept it as a solution! βοΈ**1 
I don't have a solution at the moment, but I think the solution will depend on how your data is structured, if there are records for every date, and how you want to handle when a week straddles two different months.
0 
Here's what I came up with on how to solve this:
If I solved your problem, please select "yes" above
1 
@ColemenWilson Thanks for your help on this! This is exactly what I needed.
1
Categories
 All Categories
 1.8K Product Ideas
 1.8K Ideas Exchange
 1.5K Connect
 1.2K Connectors
 299 Workbench
 6 Cloud Amplifier
 8 Federated
 2.9K Transform
 100 SQL DataFlows
 616 Datasets
 2.2K Magic ETL
 3.8K Visualize
 2.5K Charting
 730 Beast Mode
 55 App Studio
 40 Variables
 682 Automate
 175 Apps
 451 APIs & Domo Developer
 46 Workflows
 10 DomoAI
 34 Predict
 14 Jupyter Workspaces
 20 R & Python Tiles
 394 Distribute
 113 Domo Everywhere
 275 Scheduled Reports
 6 Software Integrations
 121 Manage
 118 Governance & Security
 8 Domo Community Gallery
 38 Product Releases
 10 Domo University
 5.4K Community Forums
 40 Getting Started
 30 Community Member Introductions
 108 Community Announcements
 4.8K Archive