1

Calculator Improvements: Earlier/Later Interval + Grouping Calculation

(edited by Fernando Brochetto 05/02/2021 14:40:41)

Topic: Calculator Improvements: Earlier/Later Interval + Grouping Calculation

Hello,
We have one new request for the reports.

Problem:
We have some clients that wants to know the earlier time that the units started a trip (sometimes the engine) and the later time that the units ended a trip, but the total value of all the units isn't coming with the earlier and later trip times, it is coming with the first trip inicial time and last trip final time.

Solution:
Create in the classification configurations of the report a checkbox to alternate between the first/last trip or the earlier/later trip time.

Users:
Will be able to know quickly the earlier and the later trips of every unit. This allow them for knowing if a vehicle has worked before/after it was able to and already know the time.

Fernando Brochetto
Technical Support, Rastreasul

fernando@rastreasul.com.br
2

Calculator Improvements: Earlier/Later Interval + Grouping Calculation

Re: Calculator Improvements: Earlier/Later Interval + Grouping Calculation

try to use the engine hours report, just uncheck the detalization

3

Calculator Improvements: Earlier/Later Interval + Grouping Calculation

Re: Calculator Improvements: Earlier/Later Interval + Grouping Calculation

Hello hasan.ahmed,
Didn't worked here, but anyways, trips would be better because our trips are configured for the vehicle to have some displacement, so if the vehicle just turn on the ignition at night or early morning, it won't appear in the report.

Fernando Brochetto
Technical Support, Rastreasul

fernando@rastreasul.com.br
4

Calculator Improvements: Earlier/Later Interval + Grouping Calculation

Re: Calculator Improvements: Earlier/Later Interval + Grouping Calculation

you could add a filtration in the report like min distance 1 km

5

Calculator Improvements: Earlier/Later Interval + Grouping Calculation

Re: Calculator Improvements: Earlier/Later Interval + Grouping Calculation

Hello Fernando Brochetto,

I apologise for the delay, but your question has not been ignored.

Am I to understand, that you want to display the earliest and latest time in the grouping line in the Trip report, for example, for a week, according to chronology without reference to the date (see screenshot)?
https://i.paste.pics/8c920247f7e3abf6f91f15b29e2453c6.png
If it's true, please, tell me, in what cases do you want to use this option? For what analysis is this useful?

Nastassia Maslovskaya
Business Analyst, Wialon
6

Calculator Improvements: Earlier/Later Interval + Grouping Calculation

Re: Calculator Improvements: Earlier/Later Interval + Grouping Calculation

Hello mana,
Yes, that's what I need: instead of appearing 03:24:23 the report should have the value of 00:33:44, the latest time is correct. But if a driver ends a trip in the next day, the report should present the value with the yyyy-mm-dd as 354-NYH, as it already is.

It's very common that clients wants to know when a driver has started and finished to ride in a day. As they have lots of vehicles generally, they want this in a table very quickly. Today you have to detail the report to find the earliest and latest time, so this request would solve this need, the table should show these times. For calculating an estimate time of working hours, some clients do sometimes the math of latest time - earliest time too.

Fernando Brochetto
Technical Support, Rastreasul

fernando@rastreasul.com.br
7

Calculator Improvements: Earlier/Later Interval + Grouping Calculation

Re: Calculator Improvements: Earlier/Later Interval + Grouping Calculation

Fernando Brochetto hello,

in general, this is an interesting and understandable idea. We didn’t have such requests before.

It's very common that clients wants to know when a driver has started and finished to ride in a day.

Please, tell us more, how your clients use such information.

Nastassia Maslovskaya
Business Analyst, Wialon
8

Calculator Improvements: Earlier/Later Interval + Grouping Calculation

(edited by Fernando Brochetto 27/03/2020 17:59:46)

Re: Calculator Improvements: Earlier/Later Interval + Grouping Calculation

Hello mana ,
For example, here in Brazil if a driver works between 22 and 05 hours, he gets an extra of 20%.
There is also drivers that parks the vehicle of the company every day inside their houses: as generally they work visiting clients, they doesn`t have to drive trought the company, so they need to know if the vehicle has started to work between 07:20-07:40 and finished between 17:30-18:00.
These two examples are very common cases.
So with this new feature, they can control this very easy knowing when they started and finished to work.

Fernando Brochetto
Technical Support, Rastreasul

fernando@rastreasul.com.br
9

Calculator Improvements: Earlier/Later Interval + Grouping Calculation

Re: Calculator Improvements: Earlier/Later Interval + Grouping Calculation

Fernando Brochetto,

thanks for your cases. I will note this proposal in Wialon Hosting backlog.
As you can see, other partners have not yet supported your request. As you already know, we include in the plan tasks that will be useful and valuable to at least several partners. If other partners support your idea and add some cases from real life, we can increase issue priority.

Nastassia Maslovskaya
Business Analyst, Wialon
10

Calculator Improvements: Earlier/Later Interval + Grouping Calculation

Re: Calculator Improvements: Earlier/Later Interval + Grouping Calculation

Thank you mana !!!

Fernando Brochetto
Technical Support, Rastreasul

fernando@rastreasul.com.br
11

Calculator Improvements: Earlier/Later Interval + Grouping Calculation

Re: Calculator Improvements: Earlier/Later Interval + Grouping Calculation

Hello mana
If you look again in the images I sent before, I was talking with our client and saw a problem with some values. The column "Jornada" is configurated to result in the difference of "Fim" and "Inicio". but the total working hours was suppose to be calculated by the sum of the groupment per day values, for example: in the first line the Jornada value is 97.63, calulated by the difference of 03/02 15:43 and 07/02 17:21. But what we need is the sum of 2.17 + 9.61 +15.15 +17.72 + 9.34 = 53,99 h.
Do you think that with this improvement requested before, could maybe be possible to also configure the math calcs between every groupment type?

Fernando Brochetto
Technical Support, Rastreasul

fernando@rastreasul.com.br
12

Calculator Improvements: Earlier/Later Interval + Grouping Calculation

Re: Calculator Improvements: Earlier/Later Interval + Grouping Calculation

Hello, dear Fernando Brochetto!

If I understand correctly, you are talking about changing the settlement rule in the grouping line. You want the difference between the beginning and the end to be calculated in all lines by day, and in the grouping line the sum of these differences should be calculated. However, in the grouping row, as well as in the total row, the value is calculated according to the formula introduced for the column as a whole. That is, if you have a subtraction operation, we calculate the difference in this line as well (this principle works, for example, in Excel, when the formula is stretched for a column).
And the development that we talked about earlier will not affect this calculation.

If I am not right in interpreting your request, please let me know.

Nastassia Maslovskaya
Business Analyst, Wialon
13

Calculator Improvements: Earlier/Later Interval + Grouping Calculation

Re: Calculator Improvements: Earlier/Later Interval + Grouping Calculation

Hello mana, yes, exactly.
Do you think this improvement could be done somehow?

Fernando Brochetto
Technical Support, Rastreasul

fernando@rastreasul.com.br
14

Calculator Improvements: Earlier/Later Interval + Grouping Calculation

Re: Calculator Improvements: Earlier/Later Interval + Grouping Calculation

Hello Fernando Brochetto,

with the current implementation and the logic of the Сalculator, and in particular, the Total row, we cannot make such changes. Perhaps, when we start to further develop this tool (add functions, change the logic of the whole work), we will consider this suggestion.

Nastassia Maslovskaya
Business Analyst, Wialon
15

Calculator Improvements: Earlier/Later Interval + Grouping Calculation

Re: Calculator Improvements: Earlier/Later Interval + Grouping Calculation

Hello mana, do we have any news on these features?
If calculator had more improvements, we could solve both requests, for example:
1. In calculator, configurate the column of Inicial time to show the highest value instead of the last;
2. In calculator, configure the column of equation to sumn according to detailed fields. For example (C2-C1)/const3600 should result 160.64 h in standard level and 79.44 in detailing level.

Fernando Brochetto
Technical Support, Rastreasul

fernando@rastreasul.com.br
16

Calculator Improvements: Earlier/Later Interval + Grouping Calculation

Re: Calculator Improvements: Earlier/Later Interval + Grouping Calculation

Hello Fernando Brochetto,

Unfortunately, I have no good news for you yet.
Plans for the near future have been agreed and the task of analysing and reworking the Total line is not on this list. We continue to collect requests and suggestions from our partners on this topic.
I will keep you informed.

Nastassia Maslovskaya
Business Analyst, Wialon