Trevor chart types

Dashboard table

Screenshot 2023-08-15 at 15.58.15.png

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:

date formatting.gif


Pivot table

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:

Screenshot 2023-08-15 at 16.05.30.png

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:

pivot .gif


Single value

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:
Screenshot 2023-08-15 at 16.18.50.png

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. 

single value.gif


Pie chart

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:

Screenshot 2023-08-15 at 16.25.20.png


Bar chart

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:

Screenshot 2023-08-15 at 16.27.38.png

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:

Screenshot 2023-08-15 at 16.34.03.png


Line chart

A line chart is a type of chart which displays information as a series of data points called 'markers' connected by straight line segments. Screenshot 2023-08-15 at 16.58.04.png

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:

Screenshot 2023-08-15 at 17.06.07.png

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:

Screenshot 2023-08-15 at 17.14.43.png

Was this article helpful?

0 out of 0 found this helpful

Have more questions? Submit a request



Please sign in to leave a comment.