Reports Combination


Hi Everyone ,

We  need to create a custom report.I watched the training videos And I have a question.From what I understood we will have to find a default report that includes the dataset that we want to appear on custom report and then customize (hide,formulas etc).

What do we do if we want to add another column to data in a report that is not included in the AllData?I want to add in the Summary exception Report one more column with the Avg Speed.What we do in this case?What I want is if there is a way to expand the report dataset.

Αlso is it possible in the exception summary report to add more than 6 rules?

I would appreciate it if anyone can help me


Thank you in advance for your answer


Euromat Ελλάς Α.Ε

Please sign in to leave a comment.

1 comment


Γεια σας Elpiniki,

Thank you for contacting Geotab Support. To add a new dataset to the Data tab, you will need to find the data set you need from other Default reports' Data tabs. Then you will need to copy and paste the column to the custom report. After that, you need to test this by running the report in the database to se if you're getting correct results. For your request, you don't need another dataset to add to the Data tab. You will only need a formula and a cell that has 1:00:00 in hours format. The formula will use the Distance data and the Duration data in the Exceptions Detail report. You can calculate Average speed by using these two values. Please see the screenshot from an existing report to understand the formula. Please let me know if you have more assistance regarding this issue. Better yet, you can create a Support ticket with our Support department if you have a MyAdmin account. 

For your second inquiry, you can run an Exceptions Detail Report for more than 6 exceptions. Risk Management report is different than an Exceptions report and it uses 6 exceptions for better usability and report performance. 
Please let me know if you have more questions.

Ευχαριστώ πολύ,
Mert Sonmezler

Technical Support Engineer

Mert Sonmezler 0 votes