Overview
You want to measure the density of an occurance or a metric value based on an hour, relative to other times in the same day of the week.
Chart Data Options
Option |
Description |
|---|---|
Label |
This is the time field that will be used to identify days of the week and hours of the day. |
Series |
Typically a numeric value such as $. An item that you want to measure on your Chart |
Week Density Chart Tutorial
Summary
In order to set up a Week Density Chart you will need:
- Create a report with chart display
- Select a field to use as the Label
- Select a field to use as the Series
- Create your chart, selecting Special Purpose as the type, and Week Density as the chart
- Provide the Label and Series options and Refresh
- Customise the Chart as required
- Close the Chart Builder
- Save your report
Tutorial
1. Click on the Create link and select Report to begin building your report.
In order to complete this tutorial you will need to import some sample data to use. Make sure you have a writable data source prepared.
2. You should now be on the Initialise Report page. Select the CSV Import as the build tool.
3. Select your writable data source in order to store the spreadsheet data.
4. Select a view category
5. Select the WeekDensityChartSample.csv file.
6. Click on 
at the top of the page to move to the next step.
7. You should now see the spreadsheet preview (as pictured here). Select Report as the category for each of the columns.
8. Set the spreadsheet name to be Week Density Chart Sample and the description to Tutorial Data.
9. Change the Transaction ID field to a Dimension and ensure the Transaction Time field is recognised as a Timestamp.
10. Click on at the top of the page to move to the next step.
11. You should now be on the Step 1. Report Data page. To start with, set the Output Options to Chart Only by selecting it in the Report Options section on the right. This will ensure that the information appears as a chart.
12. Now you need to add metrics to your report. Click on the 
next to the Report category to expand it.
13. Drag and drop Transaction Time, Transaction ID, and Transaction Value into the Columns area.
14. Apply a Count Distinct to the Transaction ID and Sum to the Transaction Value fields.
15. Click on at the top of the page to move to the next step.
16. You should now be on the Report Preview page. Click on the image of a Pie Chart (pictured here) to go to the Chart Format page where you can setup your chart.
17. Click on the Chart Menu, select Special Purpose as the Chart Type and click on the picture of the Week Density Chart to select it.
18. Click Save, this will load the options for a Week Density Chart.
19. In the Chart Data section you will need to select the data for each setting in the chart.
20. Set the Label to Transaction_Time, set the Series to Count Distinct: Transaction_ID or Sum Transaction_Value.
21. Click the Refresh link to generate your chart.
22. You should now have a chart that looks like the one pictured.
23. You now need to Save and Activate your chart. Click on the Close button to go back to the Report Preview page.
24. Click on the Save Menu and use Week Density Chart Tutorial as the Name.
25. Type This Week Density Chart was created using the Charts Tutorial as the Description.
26. Enter Tutorial as the Category and Charts as the Sub Category.
27. Click Activate.
