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 y-axis. 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 y-axis. 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
- Product Ideas
- 2.1K Ideas Exchange
- Connect
- 1.3K Connectors
- 309 Workbench
- 7 Cloud Amplifier
- 10 Federated
- Transform
- 663 Datasets
- 119 SQL DataFlows
- 2.3K Magic ETL
- 823 Beast Mode
- Visualize
- 2.6K Charting
- 86 App Studio
- 46 Variables
- Automate
- 194 Apps
- 483 APIs & Domo Developer
- 87 Workflows
- 23 Code Engine
- AI and Machine Learning
- 23 AI Chat
- 4 AI Projects and Models
- 18 Jupyter Workspaces
- Distribute
- 117 Domo Everywhere
- 283 Scheduled Reports
- 11 Software Integrations
- Manage
- 143 Governance & Security
- 11 Domo Community Gallery
- 49 Product Releases
- 13 Domo University
- Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 116 Community Announcements
- 5K Archive