Build a dashboard

​

Before you start

​

1. Create a dataset

1. Open Dashboards and create Lesson - regional sales.
2. In the editor, select Add query and name it Category sales.
3. Copy the complete SQL below into the dataset editor.
4. In Filters, define region as a required, non-null String with default North.
5. Preview the query using that default.

WITH orders(order_id, category, region, amount) AS (
  VALUES
    (1, 'Books',  'North', 20),
    (2, 'Games',  'South', 30),
    (3, 'Games',  'North', 15),
    (4, 'Books',  'North', 40),
    (5, 'Garden', 'South', 25),
    (6, 'Garden', 'North', 10)
)
SELECT category, SUM(amount) AS sales
FROM orders
WHERE region = :region
GROUP BY category
ORDER BY category;

​

2. Add two widgets

1. Select Add widget and choose Table.
2. Select Category sales as its dataset and show category and sales.
3. Add a Bar widget using the same dataset.
4. Use category for the category axis and sales for the numeric measure.
5. Name the widgets Sales values and Sales by category and arrange them in the layout.

​

3. Activate and refresh

1. Select Save & activate.
2. Open the dashboard and select Refresh data.
3. Wait for the refresh to finish.
4. Check the displayed revision and result time.
5. Verify the three North totals in both widgets.

​

Change one thing

​

Check the result

​

Clean up

​

Continue