🧐 How do I...?
-
Create an ER Diagram
Creating an Entity Relationship Diagram in Trevor is super simple. Go to the toolbar on the left-hand side, and click the compass icon. ...
-
Get lowest value
Min The min function returns the smallest value in a specific column. If the column contains date values, the smallest value is the le...
-
Get highest value
Max The max function returns the highest value in a specific column. If the column contains date values, the highest value is the most...
-
Get the average
Average The average function calculates the average of the values in a specific column. Examples To see the average price paid per...
-
Count unique values
Count unique values The count unique values function counts the number of unique values in a specific column. It's particularly usef...
-
Sum of values
Sum The sum function sums the values in a specific column. For example, you may want to find out your total sales or the sum of reserv...
-
Count values
How do I count rows in Trevor? The count function counts the total number of rows containing each of the distinct values in a specific c...