Cartegraph's Analytics Dashboard takes the good data you capture and allows you to analyze that data and use it to guide your decisions by getting quick access to the data you care about—and make smarter decisions throughout your workday.
Rearrange, add, resize, and remove gadgets from the dashboard at any time. These changes immediately persist. Each time you sign into Cartegraph, the dashboard displays the same gadgets in the same layout.
When you need to view the data in more detail, select any grouping, like a bar, column, or pie slice, on the chart. A dialog box opens with a detailed list of the data in that group. This is where you change the grouping you want to view. The layout of this list is the same as the List view. Also available is a List gadget, which can be used to quickly show records on your dashboard without going to a list view.
Each gadget has an action menu that allows you to:
- Edit the gadget data.
- Duplicate the gadget data to customize a Library gadget.
- Export as a PDF, PNG, or CSV to share and analyze the data as a document, image, or spreadsheet.
- List gadgets are CSV export only.
- Resize the gadget with the Size menu option.
- Only the applicable sizes are shown in the menu.
- This menu option only displays if the size can be changed.
- Permanently delete the gadget from your dashboard.
The maximum number of gadgets allowed in the dashboard is 20. The maximum number of bars in a column/bar chart is 20. Data is truncated but still visible in the Drill Down dialog box by clicking on a bar in the chart. If multiple Group By or Measure By fields are selected, the maximum number of bars is 64 (or 108 if you are doing a time series grouping). Data will be arranged so each cluster of bars has the same exact subset of categories. For example, if you are grouping by a Date Field and a Lookup, the Lookup values will be truncated to accommodate for 64 bars.
Each gadget is made of:
- a gadget type
- a title
- a recordset
- a filter
A list of roles and users to share with Gadgets created by you is automatically available in your Gadget Library. The selected roles and users will also have access to this gadget in their Gadget Library.
Bar, column, and pie gadgets also have Group by fields. This is limited to Lookup, Text, Yes/No, Date, Date/Time, and Time field types. When grouping by a Date, Date/Time, or Time field, select to group by quarter and year as well as month and year. Grouping in one of these ways also shows a clustered bar or clustered column chart. Each bar or column represents the data for a single quarter or month in a given year.
A gadget preview is available when you create or edit gadgets to see a preview of the gadget before it is saved to the dashboard and/or gadget library.
A preview is only available when the minimum required fields are selected in the create process. Once a preview can be generated, a Preview button displays. Click Preview to see what the gadget will look like in the dashboard. If any of the setup fields are changed, the Preview button displays again to let you see the updated version of the gadget. List gadgets automatically generate a preview once a recordset is selected.
The gadget previewer is available when creating editing, or duplicating a gadget.
You can have additional gadgets stored in the Gadget Library. The library includes those on your dashboard and those shared by other users.
Gadget legends show the data point attached to each color and serve as an interactive way to filter the data displayed. Select and clear the legend values to show only the selected values in the legend. The legend works this way for the bar, column, and pie charts.
The legend displays on bar and column charts if more than one group by or measure by field is selected and if the charts are grouped by a single date field with month over year or quarter over year.
Nonzero X- or Y-Axis
There might be times when the optimal starting point on one of the axes is something other than 0. You have the option to set this to another number.
Single and Multiple Groupings
If the recordset selected is a child-level recordset, then the group by options will also include the parent-level recordset fields.
The number of unique values in the Group By field has a maximum of 100. For example, the Activity library may have more than 100 Activities, so if using Activity to Group By, you will need to add a filter to limit the number of Activities displayed.
Advanced Filters should be used whenever possible to make sure the data is legible and informative. Too many records can clutter up your chart and provide no additional value. Clickto create advanced filters using the user interface rather than typing the syntax.
Group By fields can be any field except:
- An attachment
- A non-integer number
For Date, Date/Time, and Time fields, you will also need to choose one of the following for how the grouping should be performed:
- Hour of day
- Day of week
- Week of year
- Month and year
- Quarter and year
- Measured-by parameter
- Total Count is the default.
- If you select a different field, the Sum or Average option of the selected field overall records in each group displays.
- This list is limited to Integer, Floating Point, Currency, and Quantity field types.
- For Quantity fields, you also need to select the unit to convert all of the data before summing or averaging.
Use more than one grouping to create a Clustered Bar or Clustered Column chart gadget. These clustered bars of data work as two charts in one. Here are some key things to know about multiple groupings:
- The number of bars per group is limited to 8, and the total number of bars allowed is 64. If you are doing a time series grouping (month and year or quarter and year), then the total number allowed is 108.
- The second Group By field:
- Is available for bar and column charts.
- Is limited to Lookup, Text, and Yes/No fields. Date fields are not available in the second Group By field.
- Cannot be a Date, Date/Time, or Time field. Dates are only available in the first Group By field.
Multiple Measure By Fields
You can also use multiple measure by fields to create a Clustered Bar or Clustered Column chart gadget.
- Multiple measure by fields is only available when using a single grouping.
- All Measure By fields must be of a similar type.
Drill Down Gadgets
When you need to view the data in more detail, select any grouping, like a bar, column, or pie slice, on the chart, and a dialog box opens with a detailed list of the data in that group. The list shows all of the records that belong to that particular group. You can change the selected grouping using the fields near the top of the dialog box. There is a field for each group by field. This allows you to navigate through the data without closing the dialog box and selecting a different bar, column, or pie slice on the chart. The upper right-hand corner of the dialog box shows the aggregate value for the group(s) selected. Each field has an All option that is always the first item in the field. This shows all records from that particular grouping.
The list columns and arrangements are based on your persisted list view settings, depending on the recordset you are viewing. Any changes made in the drill-down view or list view display here.
There are two methods to refresh your gadget:
- Refresh your browser.
- Refresh all gadgets by clicking .