The example below shows the top teams
Posted: Mon Dec 23, 2024 4:30 am
The next step is to add the (W,D,L) statistics. These are all simply queries. They’re simply a selection of ‘Team result = Win’ (etc) which is then added to the cube.
Now we add the (GF (goals for), GA (goals against)) statistics. These are Sum() variable statistics where the variable is goals scored by the team and their opposition respectively.
The (GD (goal difference) statistics) is simply a calculated measure of GF – GA.
The Points statistic is a Sum(expression) where cyprus mobile number the expression is simply “If the result was a win, three points, if draw then one point”. No points are awarded for a loss so we can safely ignore that case. (5)
Finally, the ‘Position’ Column is a Rank() statistic calculated by simply ordering the number of points column to give the overall position for each of the teams.
We could have repeated this technique with any of the European leagues, or for any of the supported divisions for any of the seasons we have results for. Furthermore, we could have set this up as a parameterised selection that asked the user for the league, division and season before creating the table. This could also have been presented in the form of an interactive Excelsior report as well.
This technique could also be used to do multi-season league tables when the results of all the seasons since the Premier League started are taken into account.
Now we add the (GF (goals for), GA (goals against)) statistics. These are Sum() variable statistics where the variable is goals scored by the team and their opposition respectively.
The (GD (goal difference) statistics) is simply a calculated measure of GF – GA.
The Points statistic is a Sum(expression) where cyprus mobile number the expression is simply “If the result was a win, three points, if draw then one point”. No points are awarded for a loss so we can safely ignore that case. (5)
Finally, the ‘Position’ Column is a Rank() statistic calculated by simply ordering the number of points column to give the overall position for each of the teams.
We could have repeated this technique with any of the European leagues, or for any of the supported divisions for any of the seasons we have results for. Furthermore, we could have set this up as a parameterised selection that asked the user for the league, division and season before creating the table. This could also have been presented in the form of an interactive Excelsior report as well.
This technique could also be used to do multi-season league tables when the results of all the seasons since the Premier League started are taken into account.