How to Have different Groupings for avg Score
In this instance, I am getting Google Reviews 0-5 stars and averaging them overall time. But this is the all-time average ending in that quarter.
I know I can group by quarter and year but that would only give me the reviews in that time frame.
I want to have it calculate the all-time score up until that quarter. For instance, if I'm looking at a second-quarter score it should include all the reviews until the final date in the quarter 6-30-2024.
I can join in the date of the last or first day of the quarter no problem but I'm having a hard time grouping these or using SQL to partition it.
SELECT Qr-Year 2
,AVG(STAR RATING
) OVER(PARTITION BY Qr-Year 2
) AS Avg Rating per Quarter
FROM Detailed Google Reviews
The problem with the above SQL is that somehow over is not recognized as a command.
Answers
-
so i found my own solution to make a moving average.
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 620 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 742 Beast Mode
- 58 App Studio
- 41 Variables
- 686 Automate
- 176 Apps
- 453 APIs & Domo Developer
- 47 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 395 Distribute
- 113 Domo Everywhere
- 276 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