The following example goes through creating 2 charts for one table of data to show the breakdown of event severity and event injury type for the previous month.
1. Create a table which will show a count of Event Type and Event Severity.
2. Switch the table into cross-tab by moving one of the fields into the Rows field.
3. As we want to see Type of Event/Event Severity in one column, we need to create a label field.
Click the + in the bottom left corner to add a calculated field.
4. Name the calculated field to represent the column.
Add the text you wish to be on the label and click + Add.
5. Repeat for both label fields.
6. Add the fields ahead of their respective fields.
7. Navigate to the Charts tab.
8. Change the chart type to 'Stacked Vertical Column'.
Horizontal Axis: Label Field
Vertical Axis: Metric field (Count of IDs)
Colour: Type of Event
9. Format the chart, ie add labels, change axis settings.
10. Click the + in the bottom right corner to add another visualisation.
11. Repeat steps 8 and 9.
12. Navigate to the Design screen.
You will see a 'Canvas', this is where you can rearrange the display of charts.
Click Chart Widgets from the left-hand menu to show the charts you have made.
13. Click and drag the reports onto the canvas.
Resize these to display as desired.
Additional graphics can be added from the menu on the left hand panel, ie text or images.
Publish the report.
Article is closed for comments.