Database Reference
In-Depth Information
Fig. 9.16
Dashboard of the Northwind case study
May 1998 since in the Northwind data set, the sales for this month are not
complete (sales stop at May 4, 1998).
The top right gauge shows the percentage of the sales in April 1998 with
respect to the sales in April 1997. The gauge defines a range (shown in the left
side of the scale) with a gradient from light gray to white and ranging from
0 to 105%. This corresponds to the KPI targeting a 5% increase of monthly
sales amount with respect to the same month of the previous year. The query
for the gauge is given next:
WITH MonthlySalesApr1997 AS (
SELECT SUM(S.SalesAmount) AS TotalSales
Search WWH ::
Custom Search