A dashboard table chart will display the data in the same way as it's shown in your query. You can configure the max rows, to limit how many are shown.
On all charts you can change the labels & formatting to display the data however you prefer:
A pivot table is a table of grouped values that aggregates the individual items of a more extensive table within one or more discrete categories. To create a pivot table, you need to build a query using the summarize step, with 1 metric, and 2, 3, or 4 dimensions.
E.g. the query below has a count of customers, broken down by sign-up date and country:
With pivot tables, you can move the dimensions in order to display the data in the way that makes the most sense for you, as well as row and column counts:
A single value chart displays a single record from a search, in order to make that value stand out at a glance. This one has a count of customers broken down by month:
With a single value chart, you can add a trend label and a progress bar. Note: for the trend label, you will need to have a date column in your summarize dimension.
A pie chart is a circular statistical graphic which is divided into slices to illustrate numerical proportion. Importantly, pie charts can only have 1 metric and 1 dimension.
You can customize what info you display about your data - e.g. showing the value labels:
A bar chart or bar graph is a chart or graph that presents categorical data with rectangular bars with heights or lengths proportional to the values that they represent, like so:
You can build bar charts with up to 6 metrics and up to 2 dimensions.
You can also use our 'compare different years' function if you have the data broken down by month, to get a comparison like so:
A line chart is a type of chart which displays information as a series of data points called 'markers' connected by straight line segments.
In Trevor you can build a line chart with up to 6 metrics and up to 2 dimensions.
Mixed bar line chart
A mixed bar and line chart help you compare metrics and trends by displaying one metric as bars and another metric as a line.
In the chart below, there is a count of customers displayed as a line, compared to a count of orders, shown as bars, broken down by month:
To build a chart like this in Trevor you will need 2 metrics and 1 dimension.
Stacked bar chart
A stacked chart is a form of bar chart that shows the composition and comparison of a few variables, either relative or absolute, over time. To create a stacked bar chart in Trevor you need 1 metric and 2 dimensions. This chart has a count of customers broken down by sign up month and country: