Quicksight Function Tips #2 periodOverPeriodDifference #quicksight #amazon #amazonquicksight #bi #cloudBI #cloud #spice #sql #kaggle #tipsandtricks #sqlfamily #periodoverperioddifference #lag #dataset #insight #customvisual Start Index - 5 - The start index is a positive integer, indicating 5 rows above the current row.Įnd Index - 0 - The end index is a positive integer, indicating 0 rows below the current rowĭataset Used: English Premier League Results from 1993 Ordered it by 'DateTime' - Date of the Matches Took the sum of 'FTHG' - Full Time Home Goals Its very useful to see the comparison # in a Line Chart. ![]() ![]() In the below example, I used the WindowsAvg function to compare the Home Goals scored by Manchester United from 2002 till 2020 with the 5 Year Trailing Average. For example, you can use windowAvg to calculate a moving average, which is often used to smooth out the noise in a line chart. Usually, you use custom window functions on a time series, where your visual shows a metric and a date field. The windowAvg function calculates the average of the aggregated measure in a custom window that is partitioned and sorted by specified attributes. Need to find all the combinations available from the dataset ie (All Batsmen-All Cities,All Batsmen- Individual Cities,All Cities-Individual Batsman,Individual Batsman-Individual City wise runs scored)ĭataset used: #postgresql #postgresql15 #sqltipsandtricks #sqlfamily #sqlqueries #sql #dataanalytics #database #dailycoding #datafam #postgresql #sqlserver #dataanalysis #databasequeries #dataengineering #data #databaseadministration #sqlanalytics #mysql #datawithjohn #quicksight Usecase: Dataset shows the Player wise runs scored in various cities in the IPL 2022. It will help us to exclude those long queries involving "UNION". ![]() However, you often want to see all the combinations available. Group by ROLLUP (I will cover it in a different post) function is useful if you want to add the "bottom line". SQL Function Tips #1 Group By Cube Function in PostgreSQL
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |