Creating a Report
1. Overview |
To create a new report, click the + icon from the left menu.
2. Selecting Datasets |
You will be defaulted to the Data Source tab. You can now select the required data sets from the adjacent list of datasets.
Start typing in the Search box to quickly locate a specific dataset.
Note: If you select more than one dataset, any relationships defined by CAMMS and/or your Administrator will automatically be created on the bottom right panel. You can also configure your own relationships by clicking the Add Relationship button. When joining a large number of datasets for more complex reports you may find that:
not all required relationships get created automatically.
created relationships may need to be converted to a different ‘join’ type to give you the data you need.
If you need any assistance creating these relationships, please contact your Insights Administrator.
Tip: The Distinct checkbox, if ticked, will force the report to return unique values only. It is recommended to always tick this if you are joining more than one dataset.
Next move to the Design tab. It will automatically collapse to maximize screen space.
3. Adding a Report Part |
An Insights report is comprised of Report Parts. These report parts are the smallest units of a report which allow you to build reports modularly with ease.
Available types (based on permissions assigned to you by your Administrator) are:
Grid
Chart
Gauge
Form
Click on a report part type. If a report part does not appear by default, simply left click anywhere inside the Report Body grid and one will appear.
Once you select your report part type, you will see that it has 'flipped' to Configuration Mode. Configuration Mode allows you to configure the data sources linked to your report part to create all of your data visuals.
Tip: An added report part can be copied or removed by clicking the respective copy or delete icons in the configuration header.
While in Configuration Mode, you will see all the configurable parts of the report part on the left (red box). On the right (green box), you will see a preview of the front (the displayed portion) of the report part.
In the below example, you can see that a Grid type part has been added to the report.
If additional parts have been added to your report, they too will be accessible via the dropdown at the top of the panel allowing you to easily switch between report parts.
You can also add a title and a description to your report part by adding text into the respective fields as shown. An automatic preview will appear on the right-side panel.
If you want to apply further formatting, click the cogwheel icon placed next to the field.
To access all the properties related to a Report Part, simply click on the Report Part Properties tab on the right and choose your desired report part by using the dropdown at the top. You can also toggle between basic (less options) and advanced (more options) mode by using the Less/More links at the top.
For example, in relation to a chart you may use this panel to configure the chart type, legends and/or hover labels.
4. Adding Data Fields |
There are two ways to add data fields into a report part.
Method 1: Click on a field name from the left panel and drag-drop it on to the needed area as shown.
Method 2: Click the + icon next to the required area and select from the list of fields shown in the popup and click Ok.
Fields can easily be moved from one area to another and even rearranged. In relation to a Grid type report part for example, once you have a field in the Columns area, try dragging it to the Separator area. If you wish to delete a field, simply press the x button next to it.
If you wish to access all the properties related to a Data Field, you can
Click on the field name to activate the Field Properties tab on the right or.
Click on the Field Properties tab on the right and use the dropdown to select your desired field.
Within the Field Properties panel you can also toggle between basic (less options) and advanced (more options) mode by using the Less/More links at the top.
For example, you may use this panel to set a data format, determine sort order and/or apply conditional formatting.
5. Setting an Alias |
If you wish to change the name of a data field you can use the Field Name Alias to enter the desired name as shown.
6. Conditional formatting |
If you wish to color a cell, column or line based on a condition, click the cell color or text color icon as shown.
In the pop-up that appears, click Add Setting.
Now you can add as many conditions as you wish and apply the relevant color. In the below example, we are coloring all cells with the value 'Completed' in green.
This will now appear in your report as follows.
7. Adding Filters |
Similar to data fields you can either drag and drop a filter directly into your report’s filter panel.
This adds a blank filter to your report. Use the dropdowns to choose the filter operators and settings along with the data field you wish to filter by.
Click the Apply Filter button as shown. You can remove any filter by simply clicking on Clear Filter button upon selecting the filters that should be removed.
If you wish to access all the properties related to a Filter, you can.
Click on the cog wheel icon to access Filter Properties to select your desired filter settings.
For example, you may choose to determine filter equivalence options, toggle visibility and/or set an alias.
8. Maximising screen space |
When you are designing a report, you may want to utilise some of the tips outlined below to maximise the available screen area.
Collapse the Filter panel so you have better access to the Report Body section.
Once you have finished adding most of your data fields, separators and filters you can click and drag the left edge of the Data Source panel to maximise screen space.
When not using the right side Field/Filter/Report part panels, you can collapse it to the right using the arrow shown below.
9. Formatting the Header, Footer, Title |
The Report Designer/Format page allows the user to.
Layout and format report header and footer.
Enter a report title and description.
9.1 Add and Configure Items in Report Header and Footer Layout
In Report Designer, click Format in the left menu.
Tick Report Header & Footer check-box in Middle Panel to display Report Header and Report Footer sections with the default layout.
Click the Add Item button to add new items to the layout. An Add Item pop-up will be displayed - select an item type from the drop-down box and click OK to close it.
Click on the newly-added item to enable the Format Properties box.
Configure the properties in General Info group.
For an Image:
Give the image a unique name.
Enter the image url.
For a Text item:
Give the item a unique name.
Enter a value to display.
For a Date Time, Page Number, Horizontal Rule or Vertical Rule item:
Give the item a unique name.
The value is read-only and has already been fixed as {currentDateTime}, {pageNumber}, {horizontalRule} or {verticalRule}.
3. Configure the properties in Item Formatting group.
For Date Time and Page Number:
Choose a display format.
For Text, Date Time and Page Number:
Choose a font face and font size.
Choose text effects bold, italic and underlined.
Set text color and cell color.
Choose text alignment left, center, right or justify.
For Horizontal Rule and Vertical Rule:
Select a line pattern: Solid (default), Dot or Dash.
Select a line color.
Select the line thickness (in pixels).
4. Click Save at the top.
9.2 Layout Items in Report Header and Footer Layout
Items in the Report Header and Footer can be:
Resized vertically, horizontally or diagonally.
Dragged around.
Deleted.
Click and drag an item as shown below:
To delete, use the x icon as shown below:
9.3 Enter the Report Title and Description
In Report Designer, click Format in the left menu.
Tick Report Title & Description check-box in Middle Panel to display Title and Description text boxes.
Enter the title and description.
Configure the properties in Item Formatting group.
Choose a font face and font size.
Choose text effects bold, italic and underlined.
Set text color and cell color.
Choose text alignment left, center, right or justify.
4. Click Save at the top.