Variance Calculation Question
Hey All, I'm trying to calculate variance on some usage data with multiple calculations.
I need to be able to calculate the average of the 5 prior same days of the week.
For example for the date of 8/16 to find the variance I would need to compare the average of 8/9,8/2,/7/26,7/19,/7/12.
I also need to pull in average and total for the current day as well has show variance over 5% and anything negative.
I've tried a bunch of things but can't see to get anything to calculate properly.
Any help would be appreciated. Thanks!
Comments
-
This thread and associated YouTube video will get you started.
Make sure to contact your CSM and ask them to enable windowed functions in beast modes.
Jae Wilson
Check out my 🎥 Domo Training YouTube Channel 👨💻
**Say "Thanks" by clicking the ❤️ in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"0 -
Thanks so much! One thing that is the issue is it needs to be the same day of the week just looking back the last five weeks so if its monday, all the mondays back. I'm currently doing a lag but when I group by and sum usage it is not calculating correct so I feel like I am doing something wrong. Thanks so much for you input, good info for sure!
0 -
... set your lag to n * 7?
Jae Wilson
Check out my 🎥 Domo Training YouTube Channel 👨💻
**Say "Thanks" by clicking the ❤️ in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"0 -
correct i was doing by 7, but its still not working how it should. I will keep trying. thanks!
0 -
https://join.slack.com/t/domousergroup/shared_invite/zt-dxq99gyf-MBatRTzIbpUAqTCYfDDJZw
I've got some downtime until my next call. If you want to do a team's / zoom, ping me in the Slack group.
Jae Wilson
Check out my 🎥 Domo Training YouTube Channel 👨💻
**Say "Thanks" by clicking the ❤️ in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"0 -
Thanks for your help!
0 -
No problem @kacy . To help the community, can you post a screenshot of what you did in the end in your ETL?
Jae Wilson
Check out my 🎥 Domo Training YouTube Channel 👨💻
**Say "Thanks" by clicking the ❤️ in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"0 -
Could you please post a picture of your solution? I am trying to do the same thing, thank you!
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 616 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 738 Beast Mode
- 57 App Studio
- 40 Variables
- 685 Automate
- 176 Apps
- 452 APIs & Domo Developer
- 47 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 124 Manage
- 121 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